Guide families Format Comparisons Best Format Guides Best Format for Convert Guides
Use-case recommendation

Best Format for Spreadsheet Data Export

CSV is a pragmatic default for tabular spreadsheet exports.

Open Samples Open Manifest
Test this recommendation CSV samples 22 files Manifest Compare JSON
Recommendation

Recommendation

CSV

CSV is universally importable by BI tools, spreadsheets, and ETL jobs.

text/csv

Open Samples Open Hub

JSON

Use JSON where nested structure or schema metadata is required.

Files: 22

Samples Hub

TSV

Use TSV when comma collisions are frequent in raw values.

Files: 9

Samples Hub
Related decisions

Related Decisions

CSV vs JSON Best Data Format for APIs How to Convert ACCESSLOG to JSON
FAQ

FAQ

What is the default format recommendation for this use case?

CSV is the recommended default format here.

How should teams validate this recommendation?

Use sample files and manifest endpoints to test compatibility and behavior before rollout.