File must be in a csv format.
Column headers must be included in file.
All rows and columns not being used should be clear of data. It is not uncommon for files exported from third party systems to include hidden characters. If you notice options for mapping of data during import yet there are no values shown, this is most likely the cause. It is recommended that you copy and paste the data you wish to upload into a new file.