Disclaimer: We recently redesigned our Admin Area. Your store may look different than the one shown in this video, but most click paths were not affected.
There are numerous reasons why you may want to export store data to a spreadsheet. For example, if you'd like to add many new products quickly, or if you'd like to update values on many different products at once, it’s a good idea to use an export file as a formatting guide for the new data you'd like to import.
You can export store data from your Admin Area at Inventory > Import/Export > Standard Export. Here, the Export From dropdown allows you to choose any of your store’s exportable sections. For example, Categories corresponds to all the data found at Inventory > Categories > View List, and the number in parentheses matches the number of entries. In this demonstration, we'll choose Products, which corresponds to the data found at Inventory > Products.
The next step is to choose the information you'd like to export from the values in the section you selected. Each check box on this page represents a data field or value on the product edit page. If you check it, the export tool will create a column for it on your spreadsheet. The names correspond roughly to the field names as they appear on that page. The text next to each column name explains the type of data in that column. For more information, click Get Help.
The column with an asterisk is the unique identifier, meaning that every item in this section must have a value in this field, and no other value can duplicate each other exactly. We strongly recommend selecting this value every time you export, especially if you intend to import the data again later.
The virtual columns don’t actually exist as values associated with that item, but when you select them, the export tool assembles them by querying two or more Admin Area sections. These values usually cannot be imported because they don’t have corresponding fields. For the purposes of this demonstration, we'll select all columns. However, if you only wanted to edit one value, like Stock Status, you would only need to select that column and the unique identifier.
Next, choose the type of file you'd like to create. The first three options are text files that merely use different characters to separate the data values. CSV files use comma characters as separators, Tab uses tab stops, and Pipe uses pipe characters. XML is a special document-encoding language. A spreadsheet program like Microsoft Excel can read the first two by default, and the latter two after you set some basic formatting parameters. If you’re using Excel, we recommend the CSV file type. If you’re using a simple text editor, we only recommend XML for users with thorough knowledge of the language.
We'll choose CSV, and click Export. Once the process finishes, look for the Download button. Save the file to your local hard drive. You can now access the file locally at your convenience.