I am trying to import a csv file to a collection with some columns in Hebrew. During the import the fields get ? signs. When importing all the fields without Hebrew, it works fine. What can be done?
Hi Shimon,
When you have a CSV file that contains non-latin characters, it must be saved as a UTF-8 encoded file. This ensures that all systems can read the special character set(s) you are using (Hebrew in this case). Depending on what program you are using, this can usually be found in the “save as…” options box (such as Excel 2016 Mac below).
MS Excel 2010 for Windows doesn’t “saves as” the CSV/UTF-8 in a good readable format for WIX. Still shows ??? instead of Hebrew letters.
I had to add an extra step and open the CSV file created by EXCEL with NOTEPAD and thans save as CSV/UTF-8. Now it works fine.
Is there a shorter way to export from EXCEL to a readable CSV/UTF-8 for wix?
I would recommend uploading (or copy / pasting) the info into a Google spreedsheet and downloading it (file > save as ). This will be a lot quicker and allow you to make sure the info you are converting is still in the correct format, layout, schema etc…