Business Dashboard: CSV Export

Efficiently Open a CSV File with Separated Columns in Excel

Carl Van Hoorde avatar
Written by Carl Van Hoorde
Updated over a week ago

Opening the CSV in Excel

The CSV files you can download from the Airthings Dashboard are semicolon-separated files. If you open them in Excel, it could be that you see all the data in one column. Below you will find some guidelines that will avoid manual work to split the data into separate columns.

  1. Change the delimiter symbol in Windows settings:

    • Open the Control Panel in Windows.

    • Click on "Region" or "Region and Language" depending on your version of Windows.

    • Click on the "Additional settings" button.

    • In the "List separator" field, change the list separator to a semicolon symbol:

    • Click "OK" to save the changes.

    • Now open the CSV in Excel, and you can work with the data as you would in any other Excel spreadsheet.

  2. Import the CSV in Excel from a text file:

    • Open Excel and go to the "Data" tab.

    • Click on "From Text/CSV" button.

    • Navigate to the folder where your CSV file is located.

    • Select the file and click "Import".

    • Click "Load" to import the data into Excel.

    • You can now work with the data as you would in any other Excel spreadsheet.

Both of the above methods will allow you to open and work with a CSV file delimited in Excel. You can choose the method that best suits your needs.

Changing the time to local time

The time in the CSV is Coordinated Universal Time (UTC). If you want you can change the time to your local time with a simple formula. Below you find an example:

  • Column A is UTC time.

  • We added an empty column in B

  • The formula is: B2=A2+(1/24)

  • The formula above applies if there is 1 hour difference between UTC and local time. You need to find the time difference between UTC-time and your local time. For Pacific Standard Time you need to do: B2=A2-(8/24) as there is 8 hours difference between UTC and PST.

Did this answer your question?