German Amazon character issue

tducret / amazon-scraper-python

Non-official client to get some info about products sold on Amazon

MIT License

871 stars 159 forks source link

Closed carloswear closed 5 years ago

carloswear commented 5 years ago

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

tducret commented 5 years ago

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