CSV Format Reference
Only the Country column is required. AtlasDays finds supported columns by header name, so their order does not matter.
Recommended headers
Country,State,Start Date,End Date,Purpose,Notes
- Country: English country name, ISO two-letter code, or a recognized common alias.
- State: optional US state name, postal abbreviation, or ISO subdivision code such as
US-CA. - Start Date / End Date: exact date, year, or empty according to the rules below.
- Purpose: Tourism, Business, Medical, Transit, or Personal; multiple non-Transit purposes may be comma-separated.
- Notes: optional text.
Date formats
Exact Dates
Use yyyy-mm-dd in both date columns. Leave End Date empty only for an ongoing trip.
Year
Use a four-digit year in Start Date. End Date can contain a year or remain empty for the same year. A multi-year range can be expanded by AtlasDays into year records.
Unknown
Leave both date cells empty. The country is preserved as a visit without numeric days.
US state rows
Use State only for a United States trip. If one US visit covered several states and you need state-level records, use one row per state. A plain US row is valid for country-level tracking.
Transit
Put Transit in Purpose when you did not enter the country. Transit is exclusive: do not combine it with Tourism, Business, or another purpose.
Example
Country,State,Start Date,End Date,Purpose,Notes
France,,2026-03-01,2026-03-05,Tourism,
United States,CA,2026-04-10,2026-04-15,Business,Conference
Japan,,2024,,Tourism,Dates not known
United Arab Emirates,,2026-05-01,2026-05-01,Transit,Airport connectionDelimiter and quoting
AtlasDays recognizes comma, semicolon, and tab-delimited files from the header row. Quote fields that contain the delimiter or a line break according to normal CSV rules.
If a value is not recognized
Use an ISO country code, an unambiguous English country name, ISO dates, and a standard US state name or code. Keep the original row number so it is easy to compare with the import preview.
Last updated August 2, 2026