Follow the steps outlined below to use
Microsoft Excel 2007
to open a .csv file that uses UTF-8 character encoding.
Open
Microsoft Excel 2007
.
Click on the
Data
menu bar option.
Click on the
From Text
icon.
Navigate to the location of the file that you want to import. Click on the filename and then click on the
Import
button. The
Text Import Wizard - Step 1 or 3
window will now appear on the screen.
Choose the file type that best describes your data -
Delimited
or
Fixed Width
.
Choose
65001: Unicode (UTF-8)
from the drop-down list that appears next to
File origin
.
Click on the
Next
button to display the
Text Import Wizard - Step 2 or 3
window.
Place a checkmark next to the delimiter that was used in the file you wish to import into
Microsoft Excel 2007
. The
Data preview
window will show you how your data will appear based on the delimiter that you chose.
Click on the
Next
button to display the
Text Import Wizard - Step 3 of 3
.
Choose the appropriate data format for each column of data that you want to import. You also have the option to not import one or more columns of data if you want.
Click on the
Finish
button to finish importing your data into
Microsoft Excel 2007
.
