tducret/amazon-scraper-python

German Amazon character issue

Closed this issue · 1 comments

Thank you very much, this app is very easy to use and powerful.

I have a small question, why do the German Amazon information I grabed have a lot of "?" garbled.

How can I solve this? @tducret

Carlos
del

Hi @carloswear
What kind of spreadsheet editor are you using?

I have the same problem with Mac Excel 2011, since it apparently doesn't support UTF-8 (https://rothmanshore.com/2013/10/29/solved-editing-a-csv-with-utf-8-encoding-on-a-mac/)

As a workaround, you may open it with Google spreadsheet, and then export it to xlsx.

Here is a snapshot with the same kind of data.
snapshot_mac_excel_after_export_google_spreadsheet