Excel - how to open .csv file

From Kommunicera Wiki
Jump to: navigation, search

How to open termbase in .csv format as table in Excel

Open Excel, with an empty work sheet.

Go to the tab Data.

Data tab.jpg

Click From Text and browse to the .csv file you want to open.

From text.jpg

Settings as below:

Text wizard 1.jpg

Text wizard 2.jpg

Check if the text looks OK in the preview. If not, test to change from Comma to Tab as delimiter.

Text wizard 3.jpg

Click Finish and OK in the following dialogue.