Health CSV Importer

Summary

This guide explains how to format CSVs for use with Health CSV Importer.

If you just want to skip straight to examples, click here, otherwise, read on.

Example CSVs

Here are several CSVs you can review to understand how to prepare your data.

Headers

The CSVs you import must contain headers. The header row must contain a start date header, and a data type header (with units in parenthesis).

See the “Data Types” section below for more information on supported column names and recommended units.

For example, if you would like to import a weight of 150 lbs on April 16, 2020, and 145 lbs on April 17, 2020, your CSV file might look like this:

Date,Weight (lbs)
2020-04-16,150
2020-04-17,145

Data Types

Health CSV Importer supports the following HealthKit data types:

Quantities
Workouts
Categories
Correlations (blood pressure only)

For more details on all supported data types, consult this spreadsheet.

Note on Units

Health CSV Importer will only import data using units that are supported by HealthKit. See Apple’s documentation here for more details on what units are supported.

Date Formats

The date column can either represent a date or a datetime value. If you’re importing a datetime value, ensure that your file contains one of each of the below date and time formats.

Important: If you don’t specify a time zone, the app will import your datetimes in the UTC / GMT timezone. If your datetime values are in a local time, either convert the values to GMT or specify the timezone by appending the offset (e.g., 2018-09-24 5:55:44 AM -05:00). Please email us at [email protected] if you have questions about this.

Dates

MM-dd-yyyy (e.g. 04-16-2020)
dd-MM-yyyy (e.g. 16-04-2020)
yyyy-MM-dd (e.g. 2020-04-16)
yyyy-dd-MM (e.g. 2020-16-04)
yyyyMMddHHmmssZ
MMMM d, yyyy (e.g. April 16, 2020)

Times

HH:mm
hh:mm a
HH:mm:ss
hh:mm:ss a
HH:mm:ss Z
hh:mm:ss a Z
HH:mm:ssZ
HH:mm:ss.SSSZ

Here is an example of a correctly formatted datetime: 04-16-2020 08:07

You may also import fully-formatted ISO 8869-1 datetimes, e.g., 2020-04-16T08:07:00-07:00 (note the T separating the date and time components).

Other Notes

You can only import blood pressure data together, i.e. both diastolic and systolic values have to be present in the file you are importing. Hence, you will not be able to import only diastolic values or only systolic values separately.

As always, if you have any questions, please email us at [email protected].

A product of Lionheart Software.