IMPORT CSV INTO MS EXCEL GUIDE

User Manual:

Open the PDF directly: View PDF .
Page Count: 4

IMPORT CSV INTO MS EXCEL GUIDE

STEP 1: Open MS Excel

STEP 2: Click on ‘DATA’ -> ‘From text’

STEP 3: In opened file browser window select CSV file

STEP 4: In opened ‘Text Import Wizard - Step 1’ specify following settings:

● Original data type - Delimited

● File origin - Unicode (UTF-8)

STEP 5: In ‘Text Import Wizard - Step 2’ specify:

● Delimiters - Tab, Semicolon, Comma

● Text qualifier - double quotes symbol

STEP 6: In ‘Text Import Wizard - Step 3’ specify:

● Column data format - General

STEP 7: In final ‘Import Data’ popup window select ‘New worksheet’