This article will share the necessary steps to get your client's Dexcom data imported from a CSV file.
Note: The Heads Up team must turn this feature on. If you expect to see the Client Data Import feature and it's not available, please contact support at firstname.lastname@example.org, and we will be happy to help.
If at any point you have questions, please reach out to our support team by email or by using the little blue circle with the white smiling message icon in the lower right corner of the app.
This article was updated on June 24, 2021. If you see any discrepancies or anything that needs to be updated, edited, or if you just want to leave us some feedback, let us know.
Notes Before We Begin
It's important to note that all manually imported Dexcom values will be listed as Manual entries and not as Dexcom entries.
The Dexcom distinction is specific to the Dexcom integration and should not be confused with the manual CSV import.
First Things First
You must set the Timezone and Unit Preferences before the import is executed.
Failing to complete this step will cause the data to be imported incorrectly and will take manual intervention to correct. Therefore, to save you and our team time, please ensure this step is complete before moving forward.
Step 1: Head over to your client's dashboard by clicking View on the Clients table just to the right of their name.
Step 2: Click the Welcome dropdown in the left-hand menu, and click Settings.
Ensure the Glucose setting is set to the expected unit.
To know which setting is the correct one to choose, preview the Dexcom CLARITY export.
You can find the expected unit of measure just to the right of the column title Glucose Value in column H.
If necessary, make the change and click Update.
For more info on customizing units, click here.
Step 3: From the left-hand Welcome menu dropdown, click Account > Profile.
Ensure the Timezone setting is set to the expected timezone.
If necessary, make the change and click Save Changes.
For more info on changing profile settings, click here.
Getting the CSV File
Either you or your client can export the Dexcom CLARITY data in its raw form to a CSV file.
If your client has shared their data with you via the Dexcom CLARITY app you can export it directly and begin.
For more on how to export data, please check out this Dexcom CLARITY PDF.
Preparing the CSV File
You may have noticed that the Dexcom CLARITY file comes with many fields:
The good news is, the only fields we need to import Dexcom data are the Timestamp and the Glucose Value.
When we're done, your file should look like this:
Let's clean this file up in a few quick steps.
Step 1: Open your Dexcom CLARITY file in your spreadsheet software of choice.
We will use Google Sheets in the examples below, but Microsoft Excel and Mac Numbers will also work.
Step 2: All the data we want to keep is in columns B and H.
Click the A in column A and delete the column. Repeat this process for every column except B and H.
Your file should now look something like this with only two columns remaining:
Step 3: Select cells A2 to B14 and delete. We are going to keep row one for step 4.
You can click A2 and drag the pointer to row B14, like so:
Step 4: Removing Values that show as low.
The Dexcom import feature can only handle numerical values.
In some instances, the Dexcom CGM device may record values as low and list them in the Glucose Value column:
Unless removed, these strings of text will cause the import to fail.
We recommend that these rows are removed or adjusted to a comparable numerical value. For more on why this happens, please review this article on common Dexcom errors.
You can easily search the file for the word low by hitting command + f on Mac or Control + f on Windows. Type low into the search field and use the arrow to locate all rows that list low. Google Sheets example:
Step 5: Add the word timestamp in cell A1 and the word value in cell B1, like so:
Step 6: Save your file as a CSV, and everything should be good to go.
Importing the CSV File
From the Clients table, click the icon just to the left of the client's name you'd like to import Dexcom data for. This will activate the Select an action dropdown.
From the dropdown, select Import Data:
From the Select Item to Import popup, choose Dexcom CSV File and click Import:
Click Browse to choose the file you'd like to upload from your computer and click Upload:
When everything goes as planned, you will see a message of "Success!".
Review the Data on the Clients Dashboard
Now that the import is complete, let's jump over to the client's dashboard and review the data.
Again, click View to the right of the client's name on the Clients table to open their dashboard.
Note: the source of the imported Dexcom Glucose data is Manual, not Dexcom.
Find the Glucose tile and make sure the data was imported as expected:
Reviewing the Data on the Client's Reports Page
Once again, click View to the right of the client's name on the Clients table to open their dashboard.
Find the Glucose tile, click the ellipses (three dots) in the top right of the tile and click Graph Data:
In the first example below, we will show what glucose data looks like graphed for a single day and compared to the previous day:
In the second example below, we show how glucose data is graphed over a month and compared to the previous month:
For more on the reports page, please check out the content below.
If you have questions or things didn’t work out as planned, please reach out to us at email@example.com or use the little blue circle with the white smiling message icon in the lower right corner of the app, and we will be more than happy to help.