文本转 CSV 转换器
粘贴多行、列表或复制的行，即时转换为 CSV。非常适合剪贴板数据：工具自动检测分隔符，预览表格，并导出可直接粘贴到 Excel 或 Sheets 的 CSV。
此处将实时预览数据表格。
Paste into the box above — perfect for lists, copied table rows and clipboard data.
Convert pasted text into CSV
This is the fastest way to turn text into CSV when your data is already on the clipboard. Paste names, emails, addresses, a keyword list or rows copied from a page, and the converter splits them into columns and builds a valid CSV — no upload, no sign-up.
It doubles as a quick CSV maker: type or paste values, choose a delimiter, and download a ready-to-use file. The live preview shows exactly how many rows and columns you will get, and flags any line that has a different number of columns so you can fix it before exporting.
If you would rather upload a file, use TXT 转 CSV; to reverse the process, see CSV 转文本.
How to use it
粘贴或上传
Add your text or drop a file — it is read locally in your browser, never uploaded.
Preview & adjust
Check the live table and the row / column counts, then tweak the delimiter or options if a column looks off.
Copy or download
Grab the result with Copy or Download. You can reopen recent conversions from this device too.
Input and output example
Space-separated rows pasted from the clipboard are detected and exported as CSV.
Ada [email protected] NY
Sam [email protected] LAAda,[email protected],NY
Sam,[email protected],LAFrom a pasted list to a real table
不同类型的粘贴文本需要略有不同的处理方式 — 以下是方法。
One value per line
If you paste a simple list (one item per line), each line becomes a single-column row. Switch the output to Plain text → one cell per line if you instead want a flat list, or add a delimiter to your lines to create multiple columns.
Rows with multiple columns
When each line already contains comma-, tab- or pipe-separated values, leave the input on 自动检测. The tool checks that every line splits into the same number of columns and chooses the most consistent separator. You can override it under Input is → Delimited.
Handling quotes and special characters
Values that contain the delimiter or a quotation mark are quoted automatically on export. If a strict importer needs every field quoted, set 引号处理 to 全部加引号; for the simplest possible output, choose 不加引号.
Choosing the output format
CSV is the default and most compatible. You can also export TSV, pipe, semicolon, a custom delimiter, fixed-width, an HTML 表格 or JSON — useful when the destination expects something other than commas.
Tips and edge cases
- Use 示例 to load example data and see how the columns and preview behave.
- Copied from a spreadsheet? That is usually tab-separated — Auto-detect handles it; the output still defaults to comma CSV.
- Need Excel-safe IDs? Enable Excel 安全数字 to protect leading zeros and long numbers.
Text to CSV Converter — FAQ
Can it auto-detect commas, tabs, pipes and spaces?
Yes. Leave the input on Auto-detect and it picks the separator by checking which one splits every line into a consistent number of columns.
Can I copy the result instead of downloading?
Yes. Use the Copy button next to the output to put the CSV on your clipboard.
Does pasted text stay private?
Yes. Everything is processed in your browser; the text you paste is never sent anywhere.
How do I make a CSV from a plain list?
Paste the list, keep CSV as the output, and download. Each line becomes a row; add a delimiter within lines to create more columns.