How do I make a CSV file for import from Excel?
Sample Employees CSV File
Sample Positions CSV File
Sample Shifts CSV File
CSV, or comma-separated-values, files are native Excel file formats. That
is, Excel can open and read them without any special converters. To create a
CSV file, change the Save as type box in the Save As dialog box.
Take a spreadsheet like this
back to help
From the File menu, choose Save As and change the type to CSV.
Excel will give you a warning message that some features cannot be saved. Since
CSV is a text-only format, you don't get anything fancy when you save under
this method, just the raw data. Here's what the file looks like in Notepad after
it's been saved.
When you try to close the newly saved CSV file from Excel, it will warn you
that the workbook hasn't been saved even though you know you just did it.