How to Import CSV file into MS Excel

Linked Helper
Linked Helper
Published in
3 min readMar 9, 2017

This article is for Linked Helper 1.

Linked Helper 1 is outdated and was replaced by Linked Helper 2. You can find it here https://www.linkedhelper.com/

Linked Helper 2 knowledge base is available here https://linkedhelper.zendesk.com/hc/en-us

Unfortunately, MS Excel doesn’t support CSV files in the same way as .xslx files. But I still able to open any CSV file with MS Excel.

  1. Open MS Excel and create new Blank Workbook

2. Choose “File” -> “Import”

For some versions of MS Excel you should go to Data -> Get External Data -> From Text

3. Choose CSV file

4. Choose your file

5. Set “Delimited” & “Unicode (UTF-8)” as File origin

6. Choose correct delimiter. If you exported file for MS excel, it should be Semicolon. For Google Sheet it will be Comma

7. Choose General for Column data format

8. Just click Ok button

9. Done:

--

--