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.
A live table preview of your data appears here.
Turn any text into a downloadable .csv file — output defaults to CSV.
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.
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.
Input and output example
A plain list is turned into a downloadable CSV file in a couple of clicks.
Ada Lovelace, London
Lin Tan, Singapore"Ada Lovelace","London"
"Lin Tan","Singapore"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.
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.
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.
Related converters and guides
What makes a proper CSV file
Not every text export is a true CSV. Here is what this tool produces and why it matters.
A real .csv file, not just renamed text
A genuine CSV file follows RFC 4180: fields are comma-separated, fields containing commas or quotes are wrapped in double quotes, and line endings are consistent. Many tools that "export CSV" skip these rules and break when the data contains commas. This converter applies them correctly so the file opens cleanly in Excel, Google Sheets, databases and any import tool.
How to create a CSV file from text
Paste your text above — a list, a table copied from a browser or document, or an export from another tool. The converter auto-detects the delimiter (comma, tab, pipe or semicolon) and shows you a live column preview. If the columns look right, click Download result and a .csv file lands in your downloads folder immediately. Change the Output as setting to TSV, pipe or fixed-width if your target system needs a different format.
Make a CSV file from a plain list
If your input is a single-column list (one item per line), paste it in and enable First row is header if the first line is a column name. You get a one-column CSV with a proper header — ready to import as a lookup table or reference list.
Encoding: when to use UTF-8 BOM
By default the file is UTF-8, which handles accented characters, Chinese, Arabic and other scripts correctly. If you plan to open the file directly in Microsoft Excel, tick UTF-8 BOM before downloading. Excel uses the BOM (byte order mark) to recognise the encoding; without it, non-ASCII characters may appear garbled.