Text to Columns:Split Pasted Text into a CSV Grid
Turn comma, tab, semicolon, pipe, or space-separated text into a proper CSV. Auto-detection picks the delimiter for you, and every character stays in your browser.
Turn comma, tab, semicolon, pipe, or space-separated text into a proper CSV. Auto-detection picks the delimiter for you, and every character stays in your browser.
Paste a block of delimited text, pick how it is separated, and get a clean CSV grid back. The tool reads each line as a row and splits it into columns.
Drop in any block of delimited or messy text: a copied spreadsheet range, a log dump, a list, or rows separated by commas, tabs, pipes, or spaces. Each line becomes one row.
Leave it on Auto-detect to let the tool score commas, tabs, semicolons, and pipes for the most consistent split, or force a specific delimiter. Use Custom for unusual separators like :: or ~.
Toggle whether the first line is a header (otherwise col1, col2, ... are generated), then copy or download the RFC-4180 CSV. Fields with commas, quotes, or newlines are quoted automatically.
A focused converter for the everyday problem of pasted text that should have been a CSV.
It scores commas, tabs, semicolons, and pipes by how consistently they split your lines into the same number of columns, then falls back to whitespace when none fit. No guessing on your part.
Lines with fewer fields are padded and over-long rows are kept aligned to the widest line, so the grid stays rectangular and valid CSV every time.
Output follows RFC-4180: any field containing a comma, double quote, or newline is wrapped in quotes with internal quotes doubled, so it opens cleanly in Excel, Sheets, or any parser.
Everything runs as client-side JavaScript. Your pasted text is never sent to a server, logged, or stored, which matters for internal data, logs, and anything sensitive.