IMPORT CSV INTO MS EXCEL GUIDE

User Manual:

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

DownloadIMPORT CSV INTO MS EXCEL GUIDE
Open PDF In BrowserView PDF
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’



Source Exif Data:
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.5
Linearized                      : Yes
Producer                        : Skia/PDF m74
Page Count                      : 4
EXIF Metadata provided by EXIF.tools

Navigation menu