Create a CSV file in Microsoft Excel

If you have an Excel file that you want to import, first save the file as a .CSV file. Here is how.

In Microsoft Excel, select File, then Save As.

Choose the option CSV (Comma delimited) (*.csv).

There are other types of CSV files listed farther down this list, but "CSV (Comma delimited) (*.csv)" is the proper format for importing into the database.