Importing Data From CSV

Note: CSV file imports are only supported on our iOS app currently.

Importing the .csv file

1. Go to Settings > Import/Export
2. Tap Import CSV (.csv)
3. Locate your .csv file in your phone’s local storage
4. Tap the .csv file

You should see a success message saying how many entries have been imported.

CSV file format

We have created an example file for you to use to help make sure your file is properly formatted for import. Here are the requirements for the import to be successful:

• The date and text are required headers for the CSV import. The others you see in the example file are not required.
• Important: The required headers (date and text) must be written in lowercase. Headers in uppercase (e.g., DATE, TEXT) will cause an import error.
• Dates must be in ISO 8601 format
• The file needs to have the .csv file extension, like myJournalImport.csv
• The file will need to be stored on local storage on iOS in the Files app.

Other optional fields

date and text are the only required fields for CSV import, but there are many other fields that can optionally be used if needed:

date,text,uuid,duration,starred,isPinned,editingTime,modifiedDate,creationDevice,timeZoneIdentifier,authorName,conditionsDescription,moonPhase,moonPhaseCode,pressureMB,relativeHumidity,sunriseDate,sunsetDate,temperatureCelsius,visibilityKM,weatherCode,weatherServiceName,windBearing,windChillCelsius,windSpeedKPH,address,administrativeArea,altitude,country,floorLevel,foursquareID,heading,latitude,localityName,longitude,placeName,speed,locationTimeZoneName,locationUserLabel,locationUserType,regionCenterLatitude,regionCenterLongitude,regionRadius,activityName,ignoreStepCount,stepCount,mediaMD5s

The easiest way to check the format needed for these optional fields is to create an entry containing the relevant data (e.g., set a location) and then export the entry to a CSV file and check that to see how the data needs to be formatted.

Other import options

For other import options, please check out our full guide to data imports in Day One.