How do I make a CSV file for import from Excel? :: Shifts123.com Help


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



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.


back to help