This article assumes that you have:
- A Tidepool account — you can create one for free at tidepool.org/signup.
- Some diabetes data uploaded to your account.
Tidepool has an Export Data feature, which lets you download an Excel (XLSX) or JSON file of diabetes data.
1. Exporting diabetes data from Tidepool
- Log in to your account at app.tidepool.org
- Click on Export Data from the blue navigation bar at the right side.
Note: If you are a Clinician user, you must first select the person with diabetes from your patient list before this button will be visible. - From the options that appear, select the date range you would like to export, or use the calendar to select up to 90 days manually.
- Select the units you would like the data to be exported in (mg/dL or mmol/L).
- Select the file type you would like to export (Excel or JSON).
- Choose Excel (XLSX) to export a spreadsheet that can be opened by Microsoft Excel, Google Sheets, or Apple Numbers (this is what we recommend for most people).
- Choose JSON if you are intending to take your data into another application or tool that can accept a JSON file.
- Click the Export button.
- A file named TidepoolExport.xlsx or TidepoolExport.json will be downloaded to your computer.
- You will find the file located in your browser's Downloads folder.
2. Understanding your data export (Excel)
You may see some or all of the following sheets in the workbook. It depends on what data has been uploaded from diabetes devices to the account.
- Upload - Lists all the upload events from devices including the device type, maker, and serial number.
- Basal Schedules - Lists insulin pump's basal schedules as inputted into your insulin pump.
- BG Targets - Lists insulin pump's BG Targets.
- Carb Ratios - Lists insulin pump's insulin to carbohydrate ratios (I:C).
- Insulin Sensitivities - Lists insulin pump's insulin sensitivity factor (ISF) settings.
- Basal - Lists a record of the insulin pump's basal rates including both scheduled and temporary basal rates.
- Device Event - Lists device events from an insulin pump or CGM such as time changes or pump reservoir changes or primes.
- Bolus - Lists bolus events from an insulin pump.
- Bolus Calculator- Lists the inputs from using a bolus calculator on an insulin pump.
- SMBG - Lists self-monitored blood glucose readings. These are also known as fingerstick readings or blood glucose monitor readings.
- CGM - Lists CGM readings from a Continuous Glucose Monitor receiver or smartphone app.
- Physical Activity - Lists physical activity events.
Click the following link to download an example XLSX from James Jellyfish, a person with diabetes, using an insulin pump and CGM - TidepoolExport_JamesJellyfish.xlsx (on Google Drive).
3. Troubleshooting
I need 90 days of blood glucose readings to submit to insurance. How do I do that?
Follow the instructions above and select Last 90 days to download the last 90 days' worth of data. You can also use the date picker to select a 90-day period to export. Choose Excel for the file type. After opening the Excel file look at the SMBG tab to find all blood glucose readings for the selected date range.
Why am I seeing an EXPORT ERROR sheet in my Excel export?
If you see the first sheet of your Excel export labeled as EXPORT ERROR this means that we were unable to download the amount of data you requested before our export service timed out. Please reduce the time range for the data you are trying to export using the date pickers. We are working on making it so this feature is more reliable.
What is the JSON file that was downloaded to my computer? How do I open it?
JSON is a file format that can be used if you plan on taking your exported data into another application or service that can read the file.
What is Zulu Time?
Zulu time (UTC or Coordinated Universal Time) is the primary time standard by which the world regulates clocks and time. Look for the Local or Device time column to see the timestamp in your device's uploaded time.
Have other questions?
Please send an email to support@tidepool.org.
SUP-204