Need to be able to read certain characters in excel

Heya, just looking to see if this is an excel issue.

I can open a csv in notepad and read the symbols no problem, but when I open excel it get's a little funky.

Ω -> Ω
± -> ±
µF -> µF


Any idea how I can fix this?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Uploaded. Open in excel has the funky symbols, open in notepad has normal symbols.

I don't see any problem

csv.jpg

I am very jealous of your excel right now.

So somewhere our settings are different...???


Some additional info - I can copy the symbol from notepad and paste it in excel and it looks fine. And I opened your file you uploaded and it showed the symbols fine. But when I open up my source file in excel right away, it doesn't read them correctly.

Ah! I just found out about importing csvs today. I was missing the file origin. I needed to open it in UTF-8. Problem solved!

Do you always open csvs by doing import and origin in UTF-8??? A bit more work then just double clicking the file

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.

CSV is a text file (Comma Separated Values) not Excel file.
it will be the same if you change extension from csv to txt.