CODEWITHSUNDEEP
pythonweb-scrapingscrapycharacter-encoding
Haris Jameel
Haris Jameel

Reputation: 47

Encoding Issue while scr

I just want to scrape chinese language data.Everything is going good I have got and encoding issue while I run the program its print properly on terminal but I save into csv then I will get some wierd symbols. Is there any way to get rid of?

Here is terminal result: {'Name': ' 『受注生産』KREX コラボフーディー'}

In Csv:

『å—注生産ã€KREX コラボフーディー

We get that type of wierd symbol

Upvotes: 0

Views: 65

Answers (1)

Tarun Lalwani
Tarun Lalwani

Reputation: 146630

The issue is not with the CSV but Microsoft Excel itself. I have faced similar issue, if you open the file in a text editor, you will notice the characters are in correct encoding. But opening the CSV directly in Excel will not work.

To overcome the issue, you should open a new spreadsheet, go to data tab and click on From Text

Data Open

Then select File Origin as UTF-8

File Origin

And then select Comma option

Delimiter

Once done, you will see the correct data in Excel with proper encoding

Upvotes: 1

Related Questions