Skip to content

How can we help you?

Overview

Open an exported CSV file from Xena with Excel

In many places in Xena, you can extract data to a CSV file. Follow this guide to bring the data into Excel without it being automatically formatted.

It is important that you follow this guide if you want to open a CSV file from Xena with Excel.

If you don't follow this, you risk Excel automatically formatting your data when the file is opened, and thus, the values from the CSV file may be presented incorrectly.

 

  1. Open a blank worksheet in Excel
  2. At the top of the toolbar, choose Data > From Text/CSV

Importer csv fil fra Xena i Excel

 

 

  1. Select the file you downloaded from Xena
  2. Press the 'Import' button
  3. In the 'Data Type Detection' field, choose the option 'Do not detect data types'
  4. Press the 'Load' button

Hent data fra Xena ind i Excel regneark, step 2

 

 

You now have all the data loaded from Xena, with their original values.

If you have columns with numbers, you can select them and choose the 'Number' formatting. You can also choose to align the numbers to the right for easier reading.

Hent data fra Xena ind i Excel regneark, step 3

Updated