Need Help? Talk to a specialist: 1-630-543-3747

DicksonOne | Export Data From a Single Device into Excel

Export data   sort 787

Export Data from a Single Device into Excel

The data that is collected by each individual logger can be exported to a CSV file so you can view it, store it, or distribute it via an Excel file (see the bottom of this article for a note on CSV files and audit compliance).

To export data to Excel:

1) Filter the data to the precise range you would like to export. You can do that in one of three ways:
  • use the preset date range toggles at the bottom of the graph (previous hour, 24 hr, 7 days, 1 month, 3 months, or 6 months).
  • Click the box with date and time to select a specific beginning and ending date; you can also use the sliding bars to adjust the start/end time as well.
  • Click a point on the graph to use as either a beginning or ending time. Hold down the mouse button, and drag across the graph to appropriate start/stop time
  • The graph will adjust and zoom down to the range you just "drew" on the screen
Export data 788

2) Click the "Export" button on the bottom right corner of the graph.
  • You can also adjust the date range again from the Export pop-up
Export data   file 789

3) Confirm by clicking the "Export" button at the bottom right corner of the pop-up module
  • Within a few seconds you should receive an email from noreply@dicksonone.com with a .zip file attached. Inside the zip file will be the data you exported, in CSV format.
If you do not receive the file, add noreply@dicksonone.com to your approved senders list and export the file again.

4) To export a file again, go to the "Manage" tab, and select "Device Exports
Export list 790

This will take you to a list of all your past data exports. Scan the list and find the name of the file you want to export again. Click the "Download" button to resend the link to the file.

*** A note on utilizing CSV or Excel files in highly-regulated environments: Data that is exported to Excel is generally not considered auditor-friendly, because anybody can effectively alter the data that is contained in that file. Because of this, your auditor will always consider the digitally-stored data (in this case, the data within DicksonOne) as your "system of record," because the data stored on DicksonOne's servers is unable to be altered by anyone. However, CSV/Excel exports are a convenient way of quickly accessing large amounts of data for analyzing and distributing among users, particularly those who may not have access to the DicksonOne system.




You May Also Want:
Export the Graph as an Image File
Export Data from All your Devices to Excel