About
Paste rows separated by commas, tabs, pipes or semicolons and read them as columns instead of a wall of text. Copy the result back out in whichever format the next thing expects.
How to use
Paste the text and leave the delimiter on automatic, or set it yourself when the guess is wrong. The table appears below, and the copy buttons give you CSV or TSV.
When the automatic guess is wrong
Detection works by trying the usual delimiters and keeping the one that gives every row the same number of columns. Text with commas inside the values breaks that logic, and so does a file where the first row has a different shape from the rest. Setting the delimiter by hand takes a second and is more reliable than arguing with the guess.
Where simple splitting gives up
Real CSV allows a field to be wrapped in quotes so it can contain the delimiter, a line break, or a quote of its own. Splitting on the delimiter alone ignores that and shifts every column after the offending cell. If your data comes from an export that quotes fields, treat this page as a viewer and let a spreadsheet or a CSV library do the import.
Getting it somewhere useful
Copy as TSV when the destination is a spreadsheet, because pasting tab separated text drops straight into cells. Copy as CSV when it is going into a file or a tool that reads one. The round trip is the point: text arrives in whatever shape someone sent it, and leaves in the shape the next tool expects.
FAQ
How does it guess the delimiter?
By looking at which candidate produces a consistent column count. It gets confused when the data itself is full of commas, which is when you should set it manually.
A cell contains a comma and my columns shifted.
That is the limit of simple splitting. Properly quoted CSV needs a real parser, so use a spreadsheet import for files where quoted fields are common.
Can I paste straight from Excel?
Yes. A copied spreadsheet range arrives as tab separated text, which this reads without any configuration.
Is the data uploaded?
No. Splitting and rendering happen in the page.
Related tools
- Developer and text tools
- JSON Formatter
Format, minify and check JSON in the browser.
- URL Encoder and Decoder
Percent encode or decode text, locally.
- Unix Timestamp Converter
Convert between epoch timestamps and dates.
- User Agent Parser
Break a UA string into browser, OS and device.
- List Text Cleaner
Deduplicate, sort and tidy a pasted list.
- Online Notepad
A scratch note kept in your own browser.