Match Format To Purpose
Use CSV for spreadsheet exchange and lightweight bulk movement. Use JSON when structure, null semantics, or nested fields matter more than human editing.
Validate Encoding And Nulls
Before import, verify character encoding, delimiter assumptions, headers, and how null values are represented.
Export For Reuse
When the export is meant to become a reproducible artifact, document the query, filter, and timestamp that produced it.