How to convert json to csv for quickbooks / xero import
- Step 1Pull the transaction JSON — Export from the source API as a JSON array or NDJSON file.
- Step 2Convert to CSV — Drop the file here. Pick the delimiter your accounting tool expects.
- Step 3Rename headers to platform fields — Use the CSV Header Rename tool to map dot-notation columns to QuickBooks or Xero's expected names.
- Step 4Upload to the accounting platform — Use the platform's Import Transactions or Bank Statements feature.
Frequently asked questions
What columns does QuickBooks expect?+
Typically Date, Description, Amount, and optionally Category and Memo. Map the flattened JSON columns onto these via the Header Rename tool before upload.
Why use semicolon delimiter?+
Many European accounting tools (DATEV, German Excel locales) expect semicolon-separated values because comma is the decimal separator.
Can I round-trip back to JSON?+
Yes — the CSV to JSON tool reverses the flatten with type inference. Note that dot-notation columns become flat keys, not the original nested objects.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.