Updated · Built and checked by the PlinzoTools team, formulas tested against published sources
Convert a column of values into a comma, semicolon, or custom-delimited list -- and back.
New York,Los Angeles,Chicago,Houston,Phoenix,Philadelphia,San Antonio,San Diego,Dallas,San Jose
Spreadsheet data often comes as a column -- one value per line -- but many contexts (a SQL "IN" clause, a CSV cell, a comma-separated tag list) need that same data as one delimited string, or vice versa. This tool converts in both directions, with extra options most simple converters skip: removing duplicates, sorting, trimming whitespace, quoting each value, and adding a prefix.
Choose your direction: "Column to List" (paste values one per line, get a delimited string) or "List to Column" (paste a delimited string, get one value per line -- with auto-delimiter detection if you're not sure what separator your data uses). Pick your delimiter (comma, semicolon, pipe, tab, space, or a custom one), and toggle options like removing empty lines, trimming whitespace, removing duplicates, sorting, quoting each value, or adding a prefix.
Building a SQL "IN (...)" clause from a spreadsheet column of IDs, with each value automatically quoted. Converting a comma-separated tag list back into one-per-line for editing in a spreadsheet. Deduplicating and alphabetizing a list of values pasted from another source.
When several options are switched on at once, it helps to know how they combine, because the same input can produce different-looking results depending on which cleanup steps apply. Think of the process as a short pipeline: the input is split into individual items, cleanup such as trimming and empty-line removal is applied, duplicates are removed, the list is sorted, and finally each item is quoted, prefixed, and joined with your delimiter. Trimming matters most for duplicates, because "Apple" and "Apple " with a trailing space are different strings until whitespace is removed. If you find duplicates surviving, turn trimming on and try again.
Suppose a spreadsheet column holds five customer IDs: 1041, 1042, 1041, 1050, and a blank cell. You paste the column, remove empty lines, remove duplicates, and enable single-quote wrapping with a comma delimiter. The output is '1041','1042','1050', and you can paste it between parentheses after an IN keyword in your query. If the IDs are numeric columns in your database, turn quoting off so they are not treated as text; this is a common cause of type errors or slow queries. Always run a query like this against a test dataset first, and remember that very long IN lists may hit limits in some database systems.
The conversion happens in your browser, so lists containing internal identifiers are not sent anywhere by this tool. Still, take care when pasting personal data into any tool and review your organization's own rules.
Yes -- enable the quote option (single or double quotes) to wrap every value, producing output ready to paste into a SQL "IN" clause or similar quoted-list context.
When converting a list back to a column, the tool counts occurrences of each common delimiter (comma, semicolon, pipe, tab, space) in your input and picks whichever appears most often, defaulting to comma if none are found.
Values that look the same may differ by capital letters or by invisible spaces. Turn on trimming, and check whether letter case differs between the entries.
Sorting compares text character by character, so 10 begins with 1 and comes before 2. If you need numeric order, sort the numbers in your spreadsheet first.
Use a different delimiter such as a pipe or semicolon, or enable quoting so each value is wrapped and the boundaries stay clear.