Import of CSV files into Excel

[Rob]

I am using Excel version 11.2.3 for Macintosh. My problem is that I
need to import CSV files that are generated by a Windows system in
UTF-8. The file contains Eastern European characters, in this special
case Czech characters.

When I use the function external data > import text file, the text
assistant offers me only three format options: Macintosh, Windows ANSI
and DOS (PC-8). If I select any of those options all special characters
will not be displayed correctly. I know that on the current version of
MS Excel for Windows it is also possible to select UTF-8 as an origin.
There everything works correctly.

Now I need to find a way of importing such a CSV file correctly with
Excel 2004 for MacOS X. Is there any add-in, AppleScript or VBScript
that can be used? Right now this constitutes a major limitation of
Excel for MacOS X, which requires time-consuming workarounds.

Any help would be greatly appreciated!
Robert

 

[CyberTaz]

Have you tried just using File>Open?

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[little_creature]

Greetings from Czech,
I've got this idea, but haven' tried:
Open the csv file in Word, where you check the "confirm conversion at open"
in Preferences, re-save the document and try to import it in Excel.

 

[Rob]

Thanks,

unfortunately this doesn't work either. I can select Unicode as an
import option, but then it brings up Chinese characters. The other
options don't work either :-(

Rgds, Robert

 

[little_creature]

Did a quick search on google...
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm the CSV & Unicode
chapter and then the links there, I haven't read it, but you can try it

 

[Rob]

Thanks for the link. It's interesting information, however, it doesn't
really help me with the Excel problem...

Robert