What is a CSV file and how do I save my spreadsheet as one?

Follow

Applies to: Starter, Pro, Plus, & Enterprise Plans

A CSV is a comma separated values file which allows data to be saved in a table structured format. CSVs look like a garden-variety spreadsheet but with a .csv extension. Traditionally they take the form of a text file containing information separated by commas, hence the name.

CSV files can be used with any spreadsheet program, such as MS Excel, Open Office Calc, or Google Spreadsheets. They differ from other spreadsheet file types in that you can only have a single sheet in a file, they can not save cell, column, or row styling, and can not save formulas.

 

Saving Your Spreadsheet as a CSV

Note: These instructions are for MS Excel 2016, but any spreadsheet software will follow a similar process.

  1. Open your file in MS Excel
  2. Click on File
    1.png
  3. Choose Save As
    save_as.png
  4. In the drop-down menu, select CSV (Comma delimited) (*.csv)
    Please note:
    If you intend on using your file in the User Import tool found in Absorb's Admin UI, you will want to select CSV UTF-8 (Comma delimited) (*.csv)
    csv-format.png
  5. If you see a message that the selected file type, "does not support workbooks that contain multiple sheets", it is simply warning you that any formatting you have will be lost (ie. colors, bold text, formulas, sheets aside from the active one). Click OK to continue. 
    warning.png

Important Notes:

  • Do not change the file extension to CSV by using the Rename function in Windows File Explorer. This will only cause the file to be unusable, and in some cases, corrupted.
  • Do not change the file extension to CSV in the Name & Extension area when viewing a file through the Get Info window in Finder for Max OS X. This will only cause the file to be unusable, and in some cases, corrupted.
  • Adding CSV to the file name will not update the file. 
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.