Updated · Built and checked by the PlinzoTools team, formulas tested against published sources
Convert delimited plain text into properly formatted CSV.
Your CSV will appear here.
This tool converts plain text -- one record per line, fields separated by a delimiter you choose from a dropdown (comma, semicolon, pipe, or space) -- into standard CSV output.
Paste your delimited text and select the delimiter used. The converted CSV appears instantly.
You choose the field separator from a dropdown with four options: comma, semicolon, pipe, and space. The tool splits every non-empty line of your text at each occurrence of that character, then writes the fields back joined by commas. If you pick comma, the text is split at commas and rejoined with commas, which is useful mainly to clean the data and to add proper quoting where needed. There is no free-text custom delimiter box, and a tab is not in the menu; for tab-separated data, use the TSV to CSV Converter on this site.
Blank lines are discarded. Each remaining line becomes one CSV row. When writing the output, any field that contains a comma, a double quote, or a line break is wrapped in double quotes, with any inner quotes doubled. This matters most when you convert from semicolon, pipe, or space separated text, because the source fields may legitimately contain commas. For example, a semicolon-separated line reading Smith, John;42;Boston becomes "Smith, John",42,Boston so the name stays in one column.
Suppose you have a pipe-separated log with made-up rows: order|customer|total on the first line, then 1001|Alice Green|59.90, then 1002|Bob Stone|12.00. Select Pipe and the output is three comma-separated lines: order,customer,total then 1001,Alice Green,59.90 then 1002,Bob Stone,12.00. You can then download the result as converted.csv and open it in a spreadsheet.
It is a good fit for turning semicolon-separated exports, which many European spreadsheet locales create, into the comma-separated files that most international web services expect. It also helps with pipe-delimited legacy exports and simple whitespace-delimited lists copied from a terminal. Since all processing happens in your browser tab, you can prepare a file for import into a mailing tool, a database, or a spreadsheet without uploading the data anywhere.
After converting, it is good practice to run the result through the CSV Row Counter to confirm that the number of records matches what you expected, and to open the file in a spreadsheet application to confirm columns line up. If your data contains free-text fields with unpredictable punctuation, a tool that reads quoted input on the source side will be safer.
Not a free-form one -- the dropdown offers comma, semicolon, pipe (|), and space only. There is no custom delimiter option and no tab option here; for tab-separated data use the TSV to CSV Converter instead.
No. The tool offers comma, semicolon, pipe, and space. For tab-separated text use the TSV to CSV Converter instead.
Yes. In the output, any field containing a comma, a double quote, or a line break is wrapped in quotes so it remains one column.
The delimiter you selected likely does not appear in the text. Try a different option from the menu and check that your separators match.
No. It splits every line at the chosen delimiter without reading quotation marks, so it works best on simple, unquoted data.