How do I load CSV files in Excel?

Loading CSV files in Excel

To collect all the information in a way that can easily be matched with other excerpts and registers, the export format from Voyado is in .csv. CSV is a fairly common format that is often used for exports from systems.

In short, all columns are "defined" with semicolon (;) in each row. The idea is exactly the same as Excel. Here are some examples:

The following in a CSV file:

Area;Id;FirstName;LastName
Contact;38cf885d-e26d-497c-97d7-a8ce008f5ac7;Apu;Hashim

is the equivalent of this in an Excel file:

Area ID FirstName LastName
Contact 38cf885d-e26d-497c-97d7-a8ce008f5ac7 Apu Hashim 


In most cases, it is possible to double-click the CSV file and it is correctly loaded in Excel. However, there are cases where this does not work. Therefore, we recommend that you always do the following:

MacOS

Go to File> Open> in Excel and then go to the folder you have downloaded the file to. Open the file in Excel.

csv_1.png

Then - select how the file should be loaded with the formatting into the CSV file. "File Source" should always be Unicode (UTF-8).

csv_2.png

csv_3.png

csv_4.png

Done!

Windows

The principle is exactly the same as MacOS but in Windows, Excel is often, by default, set to look only for * .xls - / * .xlsx files. In order for Excel to find a file with a different extension, you only have to choose that Excel should display all files.

Go to File> Open> in Excel and then go to the folder you have downloaded the file to. In order to open the CSV file, you may need to search All Files.

csv_6.png

Open the CSV file by clicking on it. Then follow the same steps as for MacOS!

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.