Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Importing CSV files in Excel

How do I import CSV files correctly in Excel?

When you export data from CleanManager (customer data, employee data, time summaries, etc.), the data is always exported as a CSV file. CSV files are plain text formats that do not contain any other kind of formatting. For example, in Excel, tables can be displayed in colours, and text can appear in bold or italics. This is not possible in a CSV file.

If you open CSV files directly in Excel, for instance by double-clicking on the downloaded file, the format shifts, making it at times hard to get a proper overview of the data. In case your data includes symbols like æ or ö, they might also be shown as √¶ or √∂. To prevent this, it is necessary to import CSV files correctly in Excel.

In this user guide, we will show you the proper way to import CSV files in Excel.

 

In this article, you will learn how to correctly open CSV files in Excel:

 

 

 

How to correctly import CSV files in Excel on a Windows computer

number_1.png

Open Excel, go to Data and click on From Text/CSV

1.1.png

number_2.png
Select the file you wish to import

1.2.png

number_3.png

Then, click on Import

1.3.png

number_4.png
At File origin, click on the dropdown menu and select 65001: Unicode (UTF-8)

1.4.png

number_5.png

At Delimiter, click on the dropdown menu and select Semicolon

1.5.png
number_6.png
At Data Type Detection, click on the dropdown menu and select Based on entire dataset
1.6.png
number_7.png
Finish the process by clicking on Load
1.7.png
number_8.png
The file has now been correctly imported in Excel
1.8.png

 

 

 

 

How to correctly import CSV files in Excel on a MacBook

number_1.png

Open Excel, go to Data and click on Get Data (Power Query)

2.1.png

number_2.png
Click on Text/CSV

2.2.png

number_3.png

Select the file you wish to import by clicking on Browse

2.3.png

number_4.png
Then, click on Next

2.4.png

number_5.png

At File origin, click on the dropdown menu and select 65001: Unicode (UTF-8)

2.5.png
number_6.png
At Delimiter, click on the dropdown menu and select Semicolon
2.6.png
number_7.png
At Data type detection, click on the dropdown menu and select Based on entire data set
2.7.png
number_8.png
Finish the process by clicking on Load
2.8.png
number_9.png

The file has now been correctly imported in Excel

2.9.png