Your CSV contains item 0047 and some empty wait times. An import can turn the ID into 47 or treat an empty cell as zero. A short data dictionary tells the next reader which conversions would change the data.

Write the type and the missing-value rule

In a Markdown renderer that supports tables, use a small entry like this:

| Field | Type | Meaning | Missing value | Example |
| --- | --- | --- | --- | --- |
| item_id | Text | Four-character item code | Review blank IDs | 0047 |
| wait_minutes | Number | Recorded wait in minutes | Blank means unrecorded | 12 |

The dictionary records item_id as four-character text and wait_minutes as a numeric measurement.

Illustrated dictionary excerpt. Include an example value and a rule for blanks.

Check the first import against edge values

Import the ID column as text and confirm 0047 retains its leading zeroes. Find one blank wait and one recorded 0. The blank remains unrecorded, and zero means the measured wait was zero minutes.

The import check shows 0047 with leading zeroes, a missing wait and a recorded zero-minute wait.

Illustrated edge check. Each source value keeps its intended meaning.

Keep the dictionary beside the CSV. Update it when a name, unit, allowed value or missing-value convention changes. GitHub Flavored Markdown table syntax.