Practical guide

CSV Excel JSON Converter

Prepared by: Gsetsoft · Updated:

Moving bank transactions into accounting software hits format walls. This converter switches between CSV, TSV, XLSX and JSON in your browser. Check UTF-8 and delimiter choice first, headers on row one. Formulas do not transfer, only raw values.

User converting a bank transactions table on screen.
User converting a bank transactions table on screen.

Step by step

  1. Check the bank CSV is UTF-8, note the delimiter.
  2. Load the file, confirm headers.
  3. Pick target: XLSX for review, JSON for import.
  4. Convert and download.
  5. Verify characters and columns.

Example scenario

A 500-row bank export with semicolons drops in; select the delimiter. Target JSON turns each row into one record. Open the first five records to verify dates and amounts.

Check your result

Check aligned columns and date order. Compare row counts with the source. Rebuild totals manually. On delimiter errors try the other option.

Frequently asked questions

Broken characters?

Source was not UTF-8; re-save and retry.

Comma or semicolon?

Bank exports often use semicolons.

Formulas transfer?

No, values only.

Uploaded?

No, browser-local.

Open the tool: CSV Excel JSON converter →

Keep an original copy before processing your file. Examples are illustrative; results depend on your document.

Your privacy choice

Essential cookies keep tools working securely. With your permission, we collect approximate country and usage statistics to improve the site. Cookie Policy