Loading...
Loading...
Swap commas for semicolons, tabs, pipes, or anything else — right in your browser. The file never leaves your computer.
Drop your file here, or browse
.csv, .tsv, .txt — processed entirely in your browser
Auto-detects the current delimiter, previews before/after, and downloads the result — no software, no upload, works on any device.
Data > From Text/CSV lets you pick the delimiter in a preview. Avoid double-clicking the file — that applies regional defaults and can mangle leading zeros or dates. See the full walkthrough in our change-delimiter guide.
One line for repeatable conversions:
pd.read_csv("in.csv", sep=";").to_csv("out.csv", sep=",", index=False)Files from Germany, France, Spain, and Italy often use a semicolon because the comma is already the decimal mark (e.g. 3,50). Blindly replacing semicolons with commas turns one number into two columns. Convert decimal commas to dots first, or use a wizard that understands the original format.
A field like "Paris, Texas" needs quoting once commas become the separator. This tool quotes fields automatically unless you turn quoting off — turn it off only if you know your data has none of the target character.
The extension doesn't change the content — a tab-separated export saved as .csv still needs a tab-aware parser. See our TSV to CSV guide for the difference.
That means Excel assumed the wrong delimiter, not that the file is broken. Re-import through Data > From Text/CSV and select the real separator, or convert it to comma first with this tool.
Customer lists, payroll exports, invoices — the files people need to reformat are usually the ones that shouldn't leave their laptop. This tool reads the file with the browser's FileReader API, converts it in memory, and offers the result as a download. Nothing is sent to a server, so there's nothing to log, cache, or leak.
| This tool | Typical online converter | |
|---|---|---|
| File leaves your device? | No | Yes — uploaded to their server |
| Works offline once loaded? | Yes | No |
| Signup required? | No | Sometimes, for larger files |
| Delimiter | Typical use | Regions | Watch out for |
|---|---|---|---|
| Comma ( , ) | Default CSV separator (RFC 4180) | US, UK, most of the English-speaking world | Breaks if a value contains an unquoted comma |
| Semicolon ( ; ) | Regional CSV default from Excel | Germany, France, Spain, Italy, much of Europe/South America | Usually paired with comma as the decimal mark (3,50) |
| Tab | TSV — values rarely contain a literal tab | No strong regional pattern; common in exports and scripting | File often keeps a .csv extension despite being tab-separated |
| Pipe ( | ) | Chosen when data already contains commas and semicolons | Common in logs, legacy exports, some EDI formats | Rare in consumer tools — not every importer auto-detects it |
| Space | Fixed-width or simple log exports | Scripting and legacy systems, not spreadsheet exports | Ambiguous whenever a value itself contains spaces |
Open the file in a delimiter converter, let it detect the current separator (often a semicolon or tab), set the target to comma, and download. This tool does that entirely in your browser — upload the file above, pick Comma as the target, and click Convert & Download.
Don't double-click the file — that applies Excel's regional default and can misread it. Instead use Data > From Text/CSV, which lets you pick the real delimiter in a preview before loading. Alternatively, convert the delimiter first with a tool like this one so the file opens correctly no matter whose Excel opens it next.
Comma is the default defined by RFC 4180 and what most tools expect. Use semicolon if your data or region uses comma as a decimal separator, and tab (TSV) if your values themselves contain commas — it avoids the need for quoting altogether.
That's a different operation from changing a file's delimiter — it means joining values from one column into a single line, like "a, b, c". Paste the column into a spreadsheet, use a formula like TEXTJOIN(", ", TRUE, range), or use Python's ",".join(list). This tool converts whole files, not single columns.