What is the file format for uploading historical data?

You can download a sample upload file here:

https://s3-us-west-1.amazonaws.com/clovi-production/samples/sample_participant_data_import.xlsx

CloviFlow requires a .csv or .xls file format. Each row must correspond to a participant. While we intelligently parse many different column names, we *prefer* the following convention. Column names marked with * are required:

lab_test_date*

First name*

Last name*

Birthdate*

Gender*

Email*

Race

Address

city

state

zip_code

Employee ID

Wellness Vendor ID

Phone Number

cholesterol

non_hdl_cholesterol

hdl

ldl

hba1c_dcct

hba1c_iffc

systolic

diastolic

weight

triglycerides

weight

height_in_inches (you can use height_feet and height_inches columns instead)

waist_inches

heart_rate

Fasting Glucose

Nonfasting Glucose