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.