drew_n's profile

1.4K Messages


262.9K Points

Tue, Oct 1, 2013 11:29 AM

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

CSV stands for "Comma Seperated Values." It is a file format that is used to store data in a structured table of lists. It is the only file format you can use when you wish to update your Products or Customers in BigCommerce.

Many spreadsheet programs, like Microsoft Excel, allow you to save your file in a CSV format.

In the latest versions of Microsoft Excel you can make a CSV file by selecting the Microsoft Office icon (Earlier versions of Excel will require you to select File instead of seeing a icon), then select Save As. Make sure to click on top of Save As so you see a window similar to this one:

Next to the drop down called Save as type you can select CSV (Comma Delimited). Name your file, and select save.

You will usually get a warning screen from Excelt telling you that a CSV file does not support multiple files types. You can ignore this and simply select Ok.

This conversation is no longer open for comments or replies and is no longer visible to community members.


No Responses!