Code & data · Practical guide
From a spreadsheet to API-ready JSON
Clean up CSV, inspect the JSON, and encode it only when the next system needs it.
1. Start with a clean CSV header
Use one unique name per column. Convert CSV to JSON and inspect quoted commas, embedded line breaks and empty cells. Values stay strings so leading zeros in account-like identifiers are not lost.
Open CSV ↔ JSON ↗2. Inspect the structure
Format the JSON for review. Keep numeric identifiers as strings if your downstream system cannot preserve large integers. Formatting alone cannot establish whether your data matches an API schema.
Open JSON formatter ↗3. Encode only when required
Use UTF-8 Base64 only when the receiving API explicitly requires it. Base64 adds size and provides no confidentiality. For an in-memory handoff, run these steps in the private workbench.
Open Base64 encoder / decoder ↗Tool links open a fresh workspace. Inputs are not transferred between pages. For supported text operations, the private workbench offers explicit transfers in memory.