How do I save my Excel files to CSVs?
This is a quick video on how to save your finished data files in Excel to CSVs.
If you've yet to create your data files, go back and review these articles:
Step 1:
Navigate to the Excel tab you wish to turn into a CSV file. Click File and choose the Save As... option.
Step 2:
By default, the file format selected will be an Excel format. Click on the file format drop-down menu and select Comma Separated Values (.csv).
Step 3:
Make sure the title of your file reflects the content of the CSV. For example, have the word "Teachers" in the name of the Teacher CSV file. Click Save.
Note: You may get a warning that you will not be able to take advantage of some of the features of Excel. This is to be expected when creating a CSV from an existing Excel sheet. Click Save Active Sheet and then Continue.
Step 4:
Repeat Steps 1-3 for all sheets of your Excel file to create the remaining CSV files.