2

I have a script (that I run on a Mac) that writes degree C (unit for temperature in celsius) to a CSV file. I want this file to be viewed in Excel and Numbers. The problem is that it opens fine on Numbers, but shows weird characters on Excel(Windows, I haven't tested Excel on Mac). I tried both ℃ (the unicode character) and °C (a degree character followed by a C). On Excel I get this:

enter image description here

I'm pretty sure the csv file is UTF-8 encoded, so I don't know what causes the issue.

Here's something else I noticed, if I save as .txt instead of .csv and open it in excel, then an import wizard shows up. If I just leave anything as default and choose 'Finish' then the symbol does show up correctly. But it's not ideal because my users won't be able to double click on the file to open it.

What is the best way to have the special character display in both programs using the same file?

Chrismas007
  • 6,085
  • 4
  • 24
  • 47
Peng Wei
  • 81
  • 4
  • This might be off-topic as it relates to a "software" question. Typically, Excel questions must pertain to a [tag:excel-formula] or [tag:excel-vba] question. – Chrismas007 Jan 11 '16 at 20:37

1 Answers1

0

An answer in this post resolved my issue. Is it possible to force Excel recognize UTF-8 CSV files automatically?

I have to add \uFEFF to the very beginning of my CSV file.

Community
  • 1
  • 1
Peng Wei
  • 81
  • 4