THE EXPORT JOURNAL / TOPIC

Data formats guides.

Keep the receiving tool in the conversation.

Choosing a data format is easier when the receiving action is explicit. A person editing a workbook needs different affordances from a service parsing nested records. A report intended for reading has a different purpose from a table intended for another analysis. This tag gathers the guides that connect those practical differences to the wider export contract and to the details of reliable CSV generation.

Compare the four supported sample formats using the same values so that changes in structure and presentation are easy to see. For your own records, pay particular attention to identifiers, dates, amounts, missing values, and text that contains punctuation or line breaks. Agree on how those values should be represented before writing the serializer. Then test the finished artifact with the actual receiving application. The most useful choice preserves both the data and the recipient’s ability to interpret it, with enough context to avoid depending on the screen or system that originally produced it.

CSV, DONE RIGHT. — CSV export best practices for real-world data

CSV export best practices for real-world data

CSV becomes difficult when real data contains commas, missing values, identifiers, and spreadsheet formulas. Establish a predictable export contract, preserve meaning through serialization, and test the complete journey from source records to the receiving tool.

DATA → DELIVERED. — What is a data export API? A practical guide

What is a data export API? A practical guide

A useful export starts with a clear agreement about which records leave an application and how recipients will use them. Learn the decisions behind a dependable export API, from dataset boundaries to delivery and verification.

FOUR FORMATS. ONE DECISION. — CSV vs JSON vs XLSX vs PDF: choose the right export

CSV vs JSON vs XLSX vs PDF: choose the right export

File formats carry different promises about structure, editing, and presentation. Compare four common export choices using a realistic order-reporting workflow, then choose the output that preserves the information your recipient actually needs to use.

A good place to start

Make your first export.

Four real sample files. One fictional dataset. A clear next step for your project.

Explore sample files