Create a CSV file in Microsoft Excel

This lesson will walk you through saving a spreadsheet of data as a CSV file. This is the format we will use for importing your data.

In Microsoft Excel, select "File", then "Save As"

In Microsoft Excel, select "File", then "Save As"

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

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.