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

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Doesn't Need an Answer
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Archived

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.
Photo of Drew N

Drew N, Community Manager

  • 251,604 Points 100k badge 2x thumb

Posted 5 years ago

  • 0
  • 1

There are no replies.

This conversation is no longer open for comments or replies.