When using the Import Mapping Utility in collections MAX Administrator you might see this error when trying to map a file. It is caused by apostrophes in the data. The software will give you a row# or a line# to tell you which row in your Excel spreadsheet you need to check and remove any apostrophes.
So for an example say the software gives an error on row#23
Open your excel file and look at row#23 (the numbers on the left side)
In one of the columns (like this example the Employer column) in row#23 you might see in a piece of data like
Remove the apostrophe in McDonald's so it is like
After you remove all the apostrophes in Excel simply save it, convert to csv and remap.