Take the 2-minute tour ×  I have an Excel file that has some
Spanish characters (tildes, etc.) that I need to convert to a
CSV file to use as an import file. However, when I do Save As
CSV it mangles the "special" Spanish characters that aren't
ASCII characters. It also seems to do this with the left and
right quotes and long dashes that appear to be coming from the
original user creating the Excel file in Mac.  Since CSV is just
a text file I'm sure it can handle a UTF8 encoding, so I'm
guessing it is an Excel limitation, but I'm looking for a way to
get from Excel to CSV and keep the non-Ascii characters in tact.
share|improve this question stackoverflow.com/questions/155097/…
/// –  belisarius Nov 19 '10 at 1:26 I saw that question before
I posted but it is about already having a UTF8 CSV and opening
it in Excel not the other way around. –  Jeff Treuting Nov 19
'10 at 6:36 The answers below seem to work, but they're just
workarounds. Does anyone know how to make Excel do this? – 
NielW Jan 27 at 21:43  24