Importing CSV Does Not Recognize the First Column

Bug Reports
1

In order to successfully import the CSV I have to put a dummy column first. Otherwise it doesn’t recognize the field match.

These two images show how it fails…

Import Fail 1
Import Fail 11375×657 50.1 KB

Import Fail 2
Import Fail 2960×786 68.6 KB

These two images show that it works if I put a dummy field into the first column of the CSV…

Import Fail 3
Import Fail 31421×612 50 KB

Import Fail 4
Import Fail 4299×745 15 KB

2

That pattern, where the columns only line up after a throwaway first field, is usually a byte-order mark that Excel writes at the start of a UTF-8 CSV. The importer treats those hidden bytes as part of the first header, so the name never matches the field and every later column shifts. Open the file in a plain text editor and save it as UTF-8 with no BOM, then import again. Until then the dummy column is fine as long as you leave it unmapped.