How to save a xlsx as a csv with multi-language support?

[Shijune]

Hello everyone,,

We just adopted an online service that gives us sales data but the file they provide is an xlsx with multiple languages. We need to import this into our system but it must be as a csv. When I convert it over to a CSV all of the foreign characters and symbols are lost. I need to keep them, since it's important for our global company. I followed this guide here, but when I finish the steps my file still has foreign characters as "??????? https://snaptube.cam/ https://9apps.cam/".

https://www.webtoffee.com/how-to-save-csv-excel-file-as-utf-8-encoded/

Thanks for the help.

Edited August 6, 2021 by Shijune (see edit history)

[Mikeey]

in Excel you should just use Save As, and chose "CSV UTF-8 (.csv)"

Works for me and I'm using Å Ä Ö

Trying to convert or chose normal .csv will not do the trick..