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.