OPEN FORMATS. CLEAR HANDOFFS.THE OPENING COLLECTION / 2026

Handoff method

Name the field that must survive a round trip

Before you export a table, name the field that has to come back unchanged, then check that field after the file returns.

Useful Horizons · Published by Awesome Patel · Published · AI-assisted draftingUpdated

A CSV or JSON file can look complete and still change the one field a later step needs. This guide makes that field explicit and checks it after a round trip.

Pick the field before you export

Write the field name and why it must survive. A fictional review export must keep check_id as 07, not 7 and not check-07, because another tool joins on that exact text.

One field is enough for this check. A file can still lose other columns. Say which field this note covers.

Sources: RFC 4180: Common Format for CSV Files

Compare the value after the file comes back

Export, then open the file in the tool that will consume it. Copy the returned value next to the original value. Do not compare the files only by size.

A spreadsheet may change a leading zero, a long number, or a date. If check_id comes back as 7, the round trip failed even when every row is still present.

Sources: RFC 4180: Common Format for CSV Files

Write the failure next to the field name

The note says the field, the original value, the returned value, and the program that opened the file. That is the defect.

If you have not opened the file in the destination tool, the round trip is not checked. Keep that status. A successful save to disk is not the same test.

Related guides

Primary references