Use JSON to CSV
- You need text output to copy or version.
- A pipeline expects CSV.
- You want to inspect flattened keys before exporting.
Tool comparison
CSV is simpler and easier to inspect. XLSX is better when the recipient expects an Excel-compatible file.
Decision
Avoid
Flatten and validate nested JSON before treating it as a final spreadsheet.
Tools