Make a CSV file from text

Convert Text into CSV File

Create a real CSV file from text. Paste a list or upload text, pick how it splits into columns, and download a ready-made .csv file you can open in Excel, Google Sheets or any database tool.

FreeNo sign-upRuns in your browserExcel-friendly
Convert Text into CSV File
Paste or upload text to convert.
Input — paste or upload
Drag a file here, or browse (.txt, .csv, .tsv, .json)
Output
Input is
Input delimiter
Column widths
Output as
Custom delimiter
Plain text style
Quoting
Line ending

A live table preview of your data appears here.

Turn any text into a downloadable .csv file — output defaults to CSV.

Advertisement
What it does

How to make a CSV file from text

If your goal is specifically to create a CSV file from text — not just see a result, but get a proper .csv you can save and share — this tool walks it through end to end: paste or upload, set the columns, and download the file.

It handles the parts people get stuck on: choosing a delimiter, keeping a header row, and protecting values that contain commas or quotes so the file opens cleanly in Excel and other tools. Everything runs locally, so the file is built on your device.

Already have a file to upload? Use TXT to CSV. Want the online, browser-first framing? See text to CSV file online.

Step by step

Steps to convert text into a CSV file

Add your text

Paste a list or rows, or upload a text file. The tool reads it locally and shows a preview.

Set columns and header

Confirm the delimiter so the data splits into the right columns, and tick header if the first row has names.

Download the .csv

Keep the output on CSV, enable Excel-safe numbers if you have IDs or zip codes, and click Download.

Example

Input and output example

A plain list is turned into a downloadable CSV file in a couple of clicks.

Input
Ada Lovelace, London
Lin Tan, Singapore
Output
"Ada Lovelace","London"
"Lin Tan","Singapore"
Details

Getting a file that opens cleanly

A proper CSV file is more than commas — these settings make it reliable.

Choosing how text becomes columns

Decide what separates your fields. If each line already uses commas, tabs or pipes, Auto-detect handles it; for a plain list, each line becomes a one-column row until you add a delimiter within the lines.

Headers and data types

Tick First row is header to keep column names. Enable Excel-safe numbers so IDs like 007 and long codes are not mangled into 7 or scientific notation when the file opens in Excel.

Encoding for international text

Turn on the UTF-8 BOM if the file will be opened in Excel and contains accented or non-Latin characters, so they display correctly.

Saving and sharing

The download is a standard .csv, so it opens in Excel, Google Sheets, Numbers and database import tools, and can be emailed or uploaded like any other file.

Good to know

Getting it right the first time

The difference between a CSV that just works and one that frustrates the next person usually comes down to three choices made before you click download: the delimiter that splits your text into the intended columns, whether the first line is a header, and whether numeric-looking values need protecting from Excel. Decide those up front and the resulting file opens cleanly the first time, in any tool. Because everything is built locally, you can iterate quickly — tweak a setting, watch the preview update, and export only when the table looks exactly right.

FAQ

Convert Text into CSV File — FAQ

How do I create a CSV file from text?

Paste or upload your text, set the delimiter and header, keep the output on CSV, and click Download to save a .csv file.

How do I choose the columns?

The delimiter determines the columns. Use Auto-detect, or set it manually under Input is → Delimited.

Will it open in Excel correctly?

Yes. Use UTF-8 BOM for encoding and Excel-safe numbers to protect zeros and long IDs.

Is the file built locally?

Yes, entirely in your browser; nothing is uploaded.