Convertisseur colonnes de texte vers CSV
Convert column-aligned text — the kind where values line up in neat columns by spacing — into clean CSV. The tool finds the column boundaries (or you set the widths), previews the split, and exports CSV.
Un aperçu tabulaire en direct apparaît ici.
Best for aligned, tabular text; leave widths blank to auto-detect the columns.
Convert aligned text columns into CSV
Some text is not delimited by a character at all — it is aligned into columns by spaces, like a console table or a monospaced report. To convert text columns to CSV, the tool reads the column positions and turns each aligned field into a CSV cell.
Paste or upload the text. With column widths left blank, it detects boundaries by finding the spacing gaps shared across every row; or set exact widths for tricky layouts. The live preview shows the columns so you can confirm the split before exporting.
If your data is actually separated by tabs or pipes, use delimited text to CSV. For strict fixed-length records, see fixed width to CSV.
How to use it
Coller ou téléverser
Add your text or drop a file — it is read locally in your browser, never uploaded.
Preview & adjust
Check the live table and the row / column counts, then tweak the delimiter or options if a column looks off.
Copy or download
Grab the result with Copy or Download. You can reopen recent conversions from this device too.
Input and output example
Aligned column text is split at the column gaps into CSV.
id name role
01 Ada Designer
02 Lin Engineerid,name,role
01,Ada,Designer
02,Lin,EngineerReading columns the way you see them
Aligned text is easy for humans and tricky for naive splitters — here is how it is handled.
Detecting column gaps
The parser looks for character positions that are blank in every row and treats those as the boundaries between columns. This matches how your eye separates an aligned table, so most console output and reports convert without any configuration.
When auto-detection needs help
If a column can be empty, or two columns touch with no gap, type explicit widths (for example 6 10 12). A trailing 0 grabs whatever remains on the line, which is handy for a final free-text column.
Trimming padding
Each extracted value is trimmed, so the padding that aligned the columns does not end up inside your data.
Verifying the result
The column-count indicator flags rows that did not split into the expected number of fields, making misalignment obvious before you download.
When text is a table in disguise
Plenty of useful data arrives as text that is really a table — the output of a command-line tool, a copied report, or a log formatted into neat columns. The information is all there; it just needs structure. Treating those aligned columns as fields, rather than splitting on a single character, is what turns the text into something a spreadsheet or database can use. Auto-detection handles the common case by reading the spacing gaps shared across rows, while explicit widths cover layouts where a column can be blank or two columns touch. Either way, the preview is your safety net: if a width is wrong, the misalignment is obvious, so you can fix it before the CSV ever leaves your browser.
Text Columns to CSV Converter — FAQ
What counts as column text?
Text whose values line up in columns by spacing, such as console output or a monospaced report.
How are column boundaries found?
Positions that are blank in every row are treated as gaps between columns; you can also set widths manually.
What if columns touch with no space?
Enter explicit widths — auto-detection needs at least one space between columns.
Is the padding removed?
Yes, each value is trimmed so alignment spaces are not kept.
Related converters and guides
Converting lists and columns to CSV
This tool handles several related jobs people search for under different names.
List to CSV
If you have a plain list — one item per line — paste it in and the tool creates a single-column CSV. To create multiple columns from a list, separate your items with a consistent delimiter (tab, pipe or comma) and the auto-detect picks it up immediately. For a dedicated list converter, this page and the text to CSV tool both work well.
Column to CSV
Space-aligned or tab-aligned columns from a report, terminal output or legacy export can be tricky — commas inside values break naive splits. Set the input to Largeur fixe and type the column widths (e.g. 10 8 12), and the parser slices every row at the right positions without touching the cell contents. For tab-separated columns, leave input on Auto-detect.
Turning rows into columns (transposing)
If your data has items that should be column headers rather than row values, download the CSV first and use the Inverser option or a spreadsheet transpose function. The converter itself works row-by-row, so transposition is a post-step.