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.
If you would like a copy of the data you have uploaded to Tidepool Web, you can create an export of some or all your data using our Export My Data section of your Tidepool Web Profile
1. Exporting your Tidepool Data
- Log in to your Tidepool Web account.
- Click on your name or the cogwheel icon at the top of Tidepool Web.
- Scroll down the page until you see Export My Data.
- Select the date range you would like to export by clicking on one of the options (Last 14 Days, Last 30 Days, Last 90 Days) or use the date pickers to create a custom range.
- Alternatively, if you would like a copy of all your data from your Tidepool Web account, select All Data (see note below about issues downloading All Data).
- 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)
Depending on what diabetes devices you are uploading to your Tidepool Web account will result in different sheets showing up in the Excel workbook. Click through the different tabs to see the different values from your Tidepool Web account
- Upload - Lists all the upload events from your devices including the device type, maker, and serial number.
- Basal Schedules - Lists your insulin pump's basal schedules as inputted into your insulin pump.
- BG Targets - Lists your insulin pump's BG Targets.
- Carb Ratios - Lists your insulin pump's insulin to carbohydrate ratios (I:C).
- Insulin Sensitivities - Lists your insulin pump's insulin sensitivity factor (ISF) settings.
- Basal - Lists a record of your 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. You may see this when you select All Data for your export. 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?
Send us a message to support@tidepool.org and we'll do our best to try and help.