The Salesforce picklist values limit is 1,000 for a custom picklist and 500 for a multi-select, and each value can be up to 255 characters. The tool above checks your list against each kind before you load it: type how many values you have, paste the column itself, or paste the error your sync returned.
How to read the result
Start with the verdict line: it says whether your list fits and by how much it misses. Each row under it is one kind of picklist: custom, multi-select, global value set, controlling field or a standard picklist like Lead Status. Open Why on a row for what fails past the limit and what to do instead. A pasted column also shows how many values are distinct, how many repeat and which line holds the longest value, and none of it leaves your browser.
Watch the restricted ones. A restricted picklist only accepts the values an admin defined, so an import or sync that sends anything else fails, value by value. Global value sets are always restricted. If your source has more spellings than your picklist, map them before the write.
Multi-select picklists store every pick as one value separated by semicolons. An import that sends one region replaces the other regions on that record, so send the full set each time.
When your list is too long
Past the limit, a picklist is the wrong home for the list. A lookup to a small custom object holds the list as records, so you can add values without changing the field. A controlling field starts with a lower limit than other picklists; a System Administrator can ask Salesforce Support to raise it, and grouping values (regions instead of countries) often keeps you under.
If the list comes from enrichment, such as industries, job functions or countries, map it to your own values in a table before the export, and the picklist never sees a stray spelling. Oneprofile does this in a table step, then writes each column to the Salesforce field you pick.
