Prepare data for a CSV import
Flatten structured data, then review quoting and delimiters.
Use your own inputs and keep periods, units and cost assumptions consistent. The steps provide an order to work through; results do not transfer automatically between tools.
Flatten nested JSON when needed
Use a small sanitized sample first. Choose whether arrays remain JSON or become joined text; keep large identifiers as strings. CSV input can skip this step.
Open JSON to CSV ↗Choose the destination delimiter
Check the source separator and quoting, then export the delimiter your destination expects. Import identifiers as text and verify a few rows before processing the complete dataset.
Open CSV repair ↗Map the destination columns
Select and rename source columns, arrange the receiving schema and inspect missing required values. Keep identifiers as strings and test the actual import.
Open CSV column mapper ↗Attach a unique lookup when needed
Use an exact key to enrich records from a lookup with unique keys. Choose left or inner join deliberately and review unmatched downloads.
Open CSV key join ↗