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!