CSV Separator & TSV Converter
Change CSV separators and convert CSV to TSV online. Supports comma, semicolon, tab, pipe. Quote-aware parsing, auto-detect delimiter, quote all cells option. Browser-based processing.
How do I change the CSV separator?
Paste your CSV data, select the current separator as input, choose the desired output separator, and the conversion happens instantly. Quoted fields with embedded separators are handled correctly.
What is the "Quote all cells" option?
When enabled, every output cell is wrapped in double quotes regardless of content. This ensures maximum compatibility with software that expects fully quoted CSV.
How does CSV to TSV conversion work?
Your CSV is parsed using the selected (or auto-detected) delimiter, then re-joined with tab characters. Auto-detect analyzes the first line to determine the most likely delimiter.
What is the difference between CSV and TSV?
CSV (Comma-Separated Values) uses commas as field separators, while TSV (Tab-Separated Values) uses tab characters. TSV is often preferred for data with many commas in the content, as tabs are less likely to appear in text.
Can this tool handle large CSV files?
Yes, the tool processes files directly in your browser with no size limits. Performance depends on your device's memory and processing power. For very large files (100MB+), processing may take a few seconds.
Is my data secure when using this tool?
Absolutely. All processing happens locally in your browser. No data is uploaded to any server, ensuring complete privacy and security for your sensitive information.
What delimiters are supported?
The tool supports comma (,), semicolon (;), tab (\t), and pipe (|) as delimiters. You can also use the auto-detect feature to automatically identify the delimiter in your input file.
How does quote-aware parsing work?
The parser recognizes that fields enclosed in double quotes may contain the delimiter character. For example, "Smith, John" is treated as a single field even though it contains a comma. This ensures accurate parsing of complex data.
Can I convert TSV back to CSV?
Yes, simply paste your TSV data, select tab as the input separator, and choose comma (or any other delimiter) as the output. The tool works bidirectionally.
Why do different regions use different CSV delimiters?
In regions where comma is used as a decimal separator (like many European countries), semicolon is typically used as the CSV delimiter to avoid confusion. This tool helps you convert between these formats seamlessly.
What happens if I select the wrong input delimiter?
If you select the wrong delimiter, your data may be parsed incorrectly, resulting in misaligned columns. Use the auto-detect feature or check a preview of your data to ensure correct parsing.
Can I use this tool offline?
Once the page is loaded, the tool works completely offline since all processing happens in your browser. You don't need an internet connection after the initial page load.