Import CSV - file origin missing a UTF8 entry

Question

Excel 2008 for OSX seems to be missing a UTF8 import

No matter which I choose I get garbage for diacritics

the file is showing fine in TextWrangler which reports it is in UTF-8

enter image description here

score 2 · Accepted Answer · answered Jan 03 '12 at 10:54

2

Imported to Google Docs, exported as Excel. Job done.

Sigh....

answered Jan 03 '12 at 10:54

mplungjan

427

score 0 · Answer 2 · answered Jun 17 '15 at 22:13

0

Open the CSV in a text editor, such as Sublime or Text Wrangler. (Text Edit won't work.) Save the file with encoding Western (Mac Roman) or some other encoding Mac Excel uses. Import and choose the same encoding.

answered Jun 17 '15 at 22:13

motorbaby

101

score 0 · Answer 3 · edited Aug 11 '15 at 07:05

EASY solution for Mac Excel 2008: I struggled with this many times, but here was my easy fix:

Open the .csv file in Textwrangler which should open your UTF-8 chars correctly.

Now in the bottom status bar change the file format from "Unicode (UTF-8)" to "Western (ISO Latin 1)" and save the file.

Now go to your Mac Excel 2008 and select File > Import > Select csv > Find your file > in File origin select "Windows (ANSI)" and voila the UTF-8 chars are showing correctly.

Import CSV - file origin missing a UTF8 entry

3 Answers3