Text to CSV Converter

Convert structured text, lists, or log files into clean CSV format with preview

📊 Data Grid 📎 Excel Ready 📋 Header Support

Delimiter

Header Row (Optional)

Options Quote all values Trim whitespace

Structure loose lines of text as CSV

Lists copied from web pages, chat logs, notes and simple exports often have one record per line with values separated by commas, tabs, pipes or semicolons. This tool reads such text, splits each line into cells, and writes a tidy CSV you can open in a spreadsheet. A live preview table under the result shows how the columns line up. Everything is computed by JavaScript in your browser.

Using the tool

Paste your lines into Raw Text Input. Use Sample to load five people with name, age, position and city, or Paste for clipboard content.
Choose the Delimiter you want in the finished CSV: comma, semicolon, tab or pipe.
Type a Header Row (Optional), such as Name, Age, City. Separate header names with commas.
Decide on Quote all values and Trim whitespace; both start ticked.
Press Generate CSV, check the Data Preview table, then Copy or download the .csv file.

How lines are split

An important detail: the Delimiter menu controls the output separator, while input lines are split on any of four characters at once: comma, semicolon, tab or pipe. That means a mixed file works without setup, but it also means a line like Smith; John, 25 becomes three cells. Headers you type are split on commas only, even when the output delimiter is different.

Quoting and trimming

With Quote all values ticked, every cell is wrapped in double quotes, and any quote inside a value is doubled. Untick it and quotes are added only where a cell contains the output delimiter, a quote or a line break. Trim whitespace removes spaces around each cell, which matters for lists formatted as Name, Age, City with spaces after commas.

Typical uses

Cleaning a pasted list of names and phone numbers before importing it into a mailing tool.
Turning pipe-separated log lines into rows for spreadsheet filtering.
Converting a semicolon-formatted export to comma or tab format.
Adding a header line to headerless data.

Watch for

Sentences containing commas will be divided at each comma, so this is best for genuinely tabular text. Blank lines are skipped. The tool does not read files; paste text in the box.

Related Tools

Related Tools

Frequently Asked Questions

Does the Delimiter setting affect how my input is split?

No. It sets the separator used in the finished CSV. Each input line is split on any comma, semicolon, tab or pipe found in it, so mixed-separator text is handled, but text containing those characters inside a value will be split there too.

How do I add column names?

Type them in the Header Row field separated by commas, for example Name, Age, City. They are placed as the first line of the CSV, using your chosen output delimiter and the same quoting and trimming options as the data.

What does Quote all values do?

When ticked, every cell is enclosed in double quotes, with any internal quotes doubled. When unticked, quotes are applied only to cells that contain the output delimiter, a quote character or a line break, which produces lighter output.

Why did one line turn into more columns than the others?

Some values likely contain a comma, semicolon, tab or pipe, and the tool treats each of those as a cell boundary. Remove or replace the extra separator characters in the source text, then generate again.

Can I check the result before downloading?

Yes. After pressing Generate CSV, a Data Preview table beneath the raw output displays the first row as headings and the rest as cells, so you can spot misaligned columns before copying or downloading the .csv file.