Import Error: invalid char

This error can occur if there are invalid characters in your Microsoft Excel file. These characters may not be visible and can be difficult to determine which information is causing the import error

The easiest way to correct the issue is to save the Microsoft Excel file in a .csv (comma separated value) file format. To do this, open the file in Microsoft Excel, select Save As and save the file as a .csv file. Delete any spaces before and after commas in the file. Save and close the .csv file

Open the file in Microsoft NotePad or another text editor program. NotePad will show odd characters that were not previously visible. Edit and delete all the odd characters from the data and the column headers and sheet labels. Save and close the file