In this article, we'll show you how to check and change the CSV encoding for import files. We recommend using UTF-8 for all imports.
Using Numbers For Apple/Mac
Step 1: Open
Open the file with Apple Numbers.
Step 2: Export to CSV
Then, navigate to File -> Export To -> CSV… as in the screenshot below
Step 3: Change the Encoding
When you click on "CSV…", a small window with "Advanced Settings" will pop up. Choose "Unicode (UTF-8)" as in the screenshot below.
Step 4: Save!
Press next and save your CSV-file. Now you are ready to import your CSV to Custom Fields!
Using Excel for Windows
Step 1: Open File In Excel
Open the file in Microsoft Excel.
Step 2: Change The Options
Click on File -> Options as in the screenshot below.
Step 3: Open the Advanced Options
In the pop-up window choose "Advanced" Options and scroll to the "General" section as in the screenshot below
Step 4: Change The Encoding
Click the "Web Options…" button and in the pop-up window choose "Encoding".
In the drop-down menu choose "Unicode (UTF-8)" and press OK.
Step 5: Save!
Finally, save your file.
Now you are ready to import your CSV to Custom Fields!