> For the complete documentation index, see [llms.txt](https://sensorbeeab.gitbook.io/sensorbeeab-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sensorbeeab.gitbook.io/sensorbeeab-docs/readme/sensorbee-cloud-services/calibration/upload-reference-data.md). # Upload Reference Data This page allows user to easily import sensor data from reference station / device that will be used for calibrating a sensor. The user can import a file in .csv, .xlsx or .xls and must contain the necessary columns to properly map data to our database. This document will explain the process of how to import data correctly to our system. #### Importing Reference Data Step 1: Go to “Calibration” page and select the “Reference Data” tab.
Figure 1 - Reference Data tab

Figure 1 - Reference Data tab

Step 2: You have the option to enter a remarks or description as additional reference to the set of data that you are about to upload. You can leave the field blank if you opted not to provide any remarks or description.Step 3: Click the “Browse File” button. Then, a modal will appear.
Figure 2 - Browse File Modal

Figure 2 - Browse File Modal

Step 4: Browse / look for the file that you want to upload, or you can simply drag it into the screen.Step 5: Once found, the modal will show the file preview and will ask you to select a “Header Row”. * Header row means, the row where the column header names are found. Please take note that this depends on how the content of your file is arranged or formatted. In this example the file has extra 2 rows (*row 1 and 2*) before the column header row. * Once done, click “Next”.
Figure 3 - Select Header Row

Figure 3 - Select Header Row

Step 6: In this step you will be asked to map the file columns to our database columns. Please take note of the required fields: * Date & Time - Must follow the format YYYY-MM-DD hh:mm * Sensor Name - Please follow the proper sensor naming below: * NO2 * CO2 * O3 * SO2 * PM10 * PM2.5 * Sensor Values - The numeric value of the sensor reading. * Station - The reference station name or reference device name. * Unit - The unit of measurement. The system accepts the following: * ppb * ppm * µg/m3
Figure 4 - Map Columns

Figure 4 - Map Columns

Step 7: In this step you will be asked to verify the data before uploading to the server. If any of the columns does not follow the proper or required format, an error message will be shown in the screen. If there’s none, then you are good to go. Click “Submit” once you’re done verifying.
Figure 5 - Verify Data

Figure 5 - Verify Data

Figure 6 - Processing Data

Figure 6 - Processing Data

Step 8: Wait for the process to finish and the “Success” message.
Figure 7 - Successful Upload

Figure 7 - Successful Upload

Step 9: You should be able to see a list of uploaded data per reference station / device on the “Available Reference Stations / Devices” grid below.
Figure 8 - Available Reference Stations / Devices

Figure 8 - Available Reference Stations / Devices

Step 10: You can now use the reference data in the calibration steps.