This article is outdated. We now support "UTF-8 with BOM" format. This article will be removed soon.

In this article, we'll show you how to check and change the CSV encoding for import files.

Fixing "File Not Found" When Importing 

For best results, CSV files should only use UTF-8 encoding. 

While importing if you encounter this message, it is caused by using "UTF-8 with BOM" file format for your CSV.

CSV Error: File not found.
1 error has occurred, please review and fix in your CSV file.

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!