TXT 转 CSV 转换器
上传 .txt 文件并下载整洁的结构化 CSV。转换器自动检测文本的分隔方式，显示表格预览，并允许你在导出前修正分隔符、表头和编码。
此处将实时预览数据表格。
Drop a .txt file above or paste its contents — output is set to CSV by default.
Turn a text file into a CSV file
If you have a .txt file — a Notepad export, a log, an exported list or a copied table — this tool converts it to CSV without installing anything. It is the quickest way to convert a text file to CSV, whether the rows are separated by commas, tabs, spaces or pipes.
Upload the file (or drag it onto the box), and the converter reads it locally in your browser. It guesses the delimiter, splits the text into columns, and shows a live preview so you can confirm the result before downloading. Because nothing is uploaded to a server, it is safe for private or work data.
Need the reverse direction? Use CSV 转文本. Working with many files at once? The batch TXT to CSV converter handles up to 50 in one go.
How to convert a TXT file to CSV
Upload your .txt
Click browse or drag the text file onto the input box. You can also paste the contents directly.
Confirm the columns
The tool auto-detects the separator and shows a table. If columns look wrong, set 输入类型 to Delimited and pick the delimiter, or use Fixed width.
下载 CSV
Keep the output on CSV (tick UTF-8 BOM for Excel) and click Download. Your file is ready.
Input and output example
A tab-separated text file becomes comma-separated CSV, ready for Excel.
name email age
Ada [email protected] 31
Lin [email protected] 27name,email,age
Ada,[email protected],31
Lin,[email protected],27Getting a clean CSV from messy text
几个设置可处理通常导致文本转 CSV 出错的情况。
When the .txt has commas inside fields
If a value already contains a comma (for example Doe, John), a naive split would break the row. This converter follows standard CSV rules: any field containing a comma, quote or line break is wrapped in double quotes on export, so the CSV stays valid and re-imports correctly.
When rows use tabs, spaces or pipes
Tab-separated and pipe-separated text are common in exports. Leave the input on 自动检测 and the tool measures column consistency to pick the right separator. If your file is space-aligned into columns, switch 输入类型 to 固定宽度 and the columns are detected by their positions.
Keeping a header row
If the first line of your text file lists column names, tick 首行为表头. The preview marks it as a header and, if you later export to JSON, those names become the object keys.
Encoding, leading zeros and Excel
To open the CSV in Excel with accents or CJK characters intact, enable UTF-8 BOM. To stop Excel turning IDs like 007 or long numbers into 7 or scientific notation, enable Excel 安全数字. For a deeper walkthrough see fix CSV Excel formatting issues.
Tips and edge cases
- There is no hard file-size limit, but large files use your device’s memory since everything runs locally — see large text file to CSV.
- To convert several text files together, use the batch converter and download them all at once.
- Prefer code? See Python, PowerShell or Linux guides.
TXT to CSV Converter — FAQ
How do I convert a .txt file to .csv?
Upload the .txt above, confirm the column split in the preview, keep the output on CSV and click Download. The whole conversion happens in your browser.
My TXT has commas inside the text — will it break?
No. Fields containing commas, quotes or line breaks are automatically quoted on export, following standard CSV rules, so the file stays valid.
How do I keep the first row as headers?
Tick 首行为表头. It is highlighted in the preview and used as keys if you export to JSON.
Can I convert TXT to CSV without uploading my data?
Yes. All parsing runs locally in your browser; your text never leaves your device.