All Collections
Products
Edit products in Excel or Google Docs
Edit products in Excel or Google Docs

Learn how to export products, edit them in Excel or Google Docs and re-import back

Updated over a week ago

You can export all or some of your products, including selected fields, and even product variants. The benefit of this would be that you can edit products very quickly, and use the “Replace-all” or “Find” option in Excel (Google Spreadsheets, OpenOffice, etc.), then import them back into Catalog Machine.

To export your products into a CSV file for edit, follow the steps below.

1. Click on products on the left of the page, then click on export. Read more about export.

2. You can also choose what specific products you want to be exported and the fields separately. So for example you can only export products with only their description, or their prices.

3. Once you click Export there should be an automatic download started that is automatically named “export-(categoryname).csv”. 

4. Once you open the CSV file you will see product fields (e.g. Code, Name, Description) on the first line including variants. The description and other rich text fields will have a <div> at the start and a </div> at the end (html format). Images will not be displayed in the CSV file, only the image path will be (/folder/image.jpg).

5. If you have product variants, and they are selected to be exported, the CSV file will repeat the product for every variant.

This is how a CSV file would look like once you open it in Excel. Read about CSV file format and requirements.

6. You can re-import products after you change product fields in Excel or other spreadsheet application. Images with web addresses will be automatically downloaded from the Internet.

Did this answer your question?