Text to CSV Converter
Turn a plain table into CSV rows.
About this tool
Split on chooses how the plain text becomes cells. Aligned spaces splits on two or more spaces. The other choices keep quoted fields together. Output CSV format writes those cells again, so the written delimiter can differ from the split.
Irregular spacing can merge or split cells.
How to use it
- Paste aligned text or separated text, or open a file.
- Choose how to split the lines, then choose the CSV delimiter to write.
- Use Convert to CSV.
Limitations
- Irregular spacing can merge or split cells.
A plain grid split, then written as CSV
Aligned spaces and real separators are different modes
The split control chooses how lines become cells. In the aligned-spaces mode, blank lines are dropped, each remaining line is trimmed, and the line is cut on runs of two or more whitespace characters. A single space does not cut. That is why a sentence stays one cell, and why two spaces or a wide gap between columns become the boundary. In the other modes the line is parsed with a delimiter: comma, semicolon, tab, pipe, or a one-character custom mark, using the quote and escape set beside the split control.
The writer uses the output dialect. Separator, quote, and escape on the way out can differ from the split. The preview is instructed that every row is data. This page does not promote the first line into a header row by itself. If the first line was titles, they are cells in row one until a later tool is told that a header exists. No c1, c2 names are inserted here. Those names appear in the CSV-to-XML path when a header is off, which is a different conversion.
What the spaces mode cannot see
A column that is separated by only one space merges with its neighbor. A cell that itself contains two spaces will split. Alignment that uses tabs should use the tab mode, not the spaces mode. Quotes in the plain text are honored only in the delimiter modes that use the quote character. The spaces mode does not apply CSV quoting rules. It cuts on whitespace runs.
The rectangle you get
Rows can have different lengths when the source lines had different numbers of gaps. The writer does not pad them to a rectangle. A later transpose would pad. Empty lines disappear in spaces mode, so a blank line you used as a paragraph break is not an empty CSV row. Use this page to turn a monospace table or a delimited plain paste into CSV text. Check one line of output against one line of input before you convert a long file, especially when spaces and commas are mixed in the same paste.
Privacy
Your input is processed in your browser and is not uploaded to UtilChain. File names, text, and results are not sent to analytics.

