How to use the JSON to CSV Converter.
Converting between records and a table requires explicit nesting, type and missing-value rules. Keep reverse conversion as an option on the same utility.
Make the workflow fit your task.
Choose the columns and explicit rules for nested objects, arrays and missing values. Convert records with correct quoting and preserve identifiers as needed, then inspect a round-trip or known row for lost distinctions.
- What you provide
- JSON records and flattening rules.
- What you get
- Tabular CSV with nested-field decisions made explicit.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Convert [{"id":1,"name":"Ada"},{"id":2,"name":"Lee, Jo"}] to comma-separated CSV with a header and double-quote escaping.Completed example
id,name 1,Ada 2,"Lee, Jo"
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Can every JSON structure be flattened into CSV without a rule?
No. Nested arrays and objects require a representation choice. State whether to expand rows, flatten keys or preserve serialized values.
Why do imported identifiers lose leading zeros?
The receiving spreadsheet may infer numbers. Preserve identifiers as text and check the import settings as well as the generated CSV.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑