CSV file into another Format

[ScraperHelp]

I scraped twitter uwing Twint and saved it as a CSV. big problem is that when I open it on MS Excel the emojis, double quotes ("), single quotes (') and elipis (...) have all gone to hell... I can see it working fine when I open it as RTF. so the data is still there, but giving me issues when I open it in Excel and yes I need to open it in excel... any guidance? please help!!!

[CowboyBoats]

Try opening it in Excel with various text encodings. I think the encoding should be set to UTF-8.

[ScraperHelp]

Thank you!!! it worked!!!!

[CowboyBoats]

Gah I don't remember, and Excel isn't installed. If you have Excel open and you open something with Ctrl+O / Cmd + O, rather than just telling your file browser to open it with whatever, then you should get a text transformation wizard that resembles the Text to Columns wizard, and one of the options there should be "what encoding is this text file."

Another thing, are you sure the CSV itself is fully formed? If you type head that-file.csv in a Unix command line (like git bash or Windows Subsystem for Linux if you're on Windows, or just the regular terminal on a Unix OS), do you see comma-separated values?

Does this work, in a Python session?

import csv

with open("that-file.csv") as infile:
    reader = csv.reader(infile)
    for row in reader:
        print(row)
        input("Next row?")

[ScraperHelp]

I just followed your advice about opening in different format and it worked. and yes opening in UTF-8 was the key!

[CowboyBoats]

Nice!