Try the tool

CSV delimiter converter: change separators without splitting values

Convert a delimited table while preserving quoted commas, embedded quotes and cell boundaries.

A separator is part of a delimited file's structure. Replacing every comma with a semicolon can damage a number such as 1,234.56 or a description containing punctuation, because those commas may belong inside a cell.

Use a parser that recognises quoted fields, then write the selected output delimiter. This local web tool changes table separators; it does not turn a PDF or photograph into a spreadsheet.

Try the tool

Everything in this tool runs in this browser. Your entries are not uploaded. Reloading clears the result unless you download it.

Identify the structure before converting

A comma-separated row with the cells Item and Amount might be followed by Notebook and 1,234.56. The amount field needs appropriate quoting when its comma could be confused with the delimiter. A quoted description can also contain a line break.

RFC 4180 describes a common comma-separated format, including double-quoted fields and doubled internal quotes. Semicolon-delimited exports are a common related dialect; the delimiter choice should match the application receiving the file.

Keep number interpretation separate

Changing a delimiter does not decide whether 1.234 means one point two three four or one thousand two hundred and thirty-four. It also does not establish whether a date written 03/04 means March 4 or April 3.

Choose the source delimiter deliberately and preview the column count. If the preview shows one very long column or several broken amount columns, correct the input settings before exporting.

Inspect a small result before importing everything

Check a row containing punctuation, a blank cell and an identifier with leading zeros. Confirm that the receiving spreadsheet imports those values with the intended data types. A CSV file stores text fields; the spreadsheet may apply its own date and number interpretation.

For a photographed or PDF table, Tablora handles the earlier extraction step on iPhone. Its free workflow reads, previews and edits cells; Pro is required for XLSX/CSV export and multi-page merging. This browser converter does not share a table with the app automatically.

  • Keep an unchanged copy of the original file.
  • Check headers and row count.
  • Confirm numbers after import, not only in the CSV preview.

Questions, answered

Why not use find and replace?

A separator character can also occur inside a quoted field. A parser can preserve those boundaries while a blind replacement cannot.

Does changing the delimiter convert decimal conventions?

No. Delimiter conversion and numeric interpretation are separate operations. Review the resulting values in the target application.

Sources & method

Reviewed:

Keep going in Tablora

Read PDF, photo and camera-scan tables on iPhone without uploading documents · Preview and edit cells free, with uncertain readings marked beside the source · Pro exports XLSX/CSV and merges multi-page tables or multiple tables into a workbook

Get the iPhone app

Keep exploring

Inspect the structure before changing the data

Paste the original table text and select a delimiter, or use detection as a starting point. The preview shows the interpreted rows and the maximum column count. The mismatch count compares later rows with the first row’s column count. Quoted fields can contain delimiters and line breaks; changing punctuation without parsing those boundaries can damage a table.

A width mismatch identifies a place to inspect. It does not prove which row is correct. Compare the preview with the source file, particularly when the data contains quoted notes, embedded line breaks or trailing empty cells.

Keep identifiers as text

This inspection leaves cell text intact. A leading zero in an account code is meaningful even when the rest of the code looks numeric. Use the number normalizer only for a column that you explicitly intend to treat as numbers.

Preview parsed rows, maximum column width and row-width mismatches before exporting CSV or TSV.

Inputs

Entered content stays in this tab. No upload is needed.

Results