Text to CSV Helper

Turn delimited text into CSV.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

About this tool

Paste text with one entry per line and press Run. Each line becomes one CSV row, wrapped in double quotes when it contains a comma or a quote so that it stays in a single cell.

How to use

1
Step 1
Paste your lines into the input box.
2
Step 2
Press Run.
3
Step 3
Copy the CSV and paste it into a spreadsheet.

How it works

Lines are not split into columns. A line that contains a comma or a double quote is wrapped in double quotes, and any double quotes inside are doubled, which is the standard CSV escape. Other lines are written unchanged. The result is a single-column CSV.

Worked example

Three lines, two needing quotes

Input
apple red, ripe say "hi"
Output
apple "red, ripe" "say ""hi"""
Walkthrough
The first line is written as is. The second contains a comma and the third a quote, so each is wrapped in quotes and internal quotes are doubled.

Limitations

  • Always a single column; no column splitting.
  • Comma is the only delimiter used when checking for quoting.
  • No header row is added.

Questions

How do I convert a list to CSV?
Paste one item per line and press Run. You get a single-column CSV.
Can it split each line into columns?
No. Each line is one cell.
Why were some lines put in quotes?
Lines containing a comma or a quote must be quoted so spreadsheets keep them in one cell.

Features

  • CSV quoting handled
  • One row per line
  • Runs in your browser

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • Learn Regular Expressions - Crash Course

    freeCodeCamp.org

    Regex powers many find/replace and clean-text workflows.

    Watch on YouTube
  • Learn JSON - Full Crash Course

    freeCodeCamp.org

    Structured text formats often sit next to plain-text tools.

    Watch on YouTube