File Encoding

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

image3.png 

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.

image4.png

Step 4: Save!

Press next and save your CSV-file. Now you are ready to import your CSV to Custom Fields!

image5.png 

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.

image7.png

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

image6.png

Step 4: Change The Encoding

Click the "Web Options…" button and in the pop-up window choose "Encoding".
 image1.png

In the drop-down menu choose "Unicode (UTF-8)" and press OK.

image2.png

Step 5: Save!

Finally, save your file.

Now you are ready to import your CSV to Custom Fields!