Text to CSV converter

How to convert text to CSV

Paste your delimited text into the input panel and choose the character that separates your columns — Tab is the most common (Excel and Google Sheets copy data as tab-separated by default). The CSV output appears instantly in the right panel with fields properly quoted wherever needed. Click Copy or Download CSV to use the result in your spreadsheet, database, or wherever CSV is expected.

Converting tab-separated text to CSV

Tab-separated values (TSV) are what you get when you copy a range of cells from Excel or Google Sheets and paste into a text editor. The columns are separated by tab characters that are invisible but present. Select Tab as the input delimiter and Comma as the output separator to produce standard CSV. If any cell contained a comma the tool will automatically wrap it in double quotes so the column structure is preserved correctly.

Pipe and semicolon delimited data

Many data exports from databases, ERP systems, and legacy applications use pipe (|) or semicolon (;) as the delimiter instead of a tab or comma — often because the data itself contains commas. Select Pipe or Semicolon as the input delimiter to split on that character. If none of the presets match your file you can type any custom delimiter character into the Custom field.

How CSV quoting works

The CSV standard (RFC 4180) requires that a field be wrapped in double quotes if it contains the output separator, a double quote character, or a newline. This tool applies those rules automatically. If a field contains double quotes they are escaped by doubling them — " becomes "" inside a quoted field. Enable Quote all fields to wrap every field in double quotes regardless, which some legacy systems require.

Frequently asked questions