How do I convert my Etsy listings export?

Listings exported from Etsy come in a slightly different format than we use to import them and require some modifications before they can be imported. This guide will walk you through that process.

This video will walk you through the process, and written instructions can be found below.

Step One: Download your Etsy listings

To export your listings from Etsy go to your dashboard, then click on “Settings” and then “Download Data”.

If you are comfortable working with spreadsheets, you can relatively easily make the conversions needed to make your file compatible for import.

Many of the columns in the Etsy export file are used with some minor modifications. Any unused columns should be deleted.

Step Two: Grab a copy of the Stockabl template

We recommend transferring the data from your Etsy export file to the official Stockabl template. Not only will you know for sure you have all the information you need, but we have included helpful dropdown menus and info notices to help you make sure it’s done correctly.

Step Three: Match the columns

Etsy Column Name	Stockabl Column Name
Title	Name
Description	Description
Price	Retail Price
Currency Code	not used (remove from file)
Quantity	Stock (optional)
Tags	Tags
Custom Attribute	Attribute Name Attribute Value(s)
Image 1… Image 10	Images
Variation # Type	Attribute Name
Variation # Values	Attribute Value(s)

Step Four: Edit the columns

Once you’ve moved or renamed everything, it’s time to clean up the information in the columns a little bit to prepare it for importing.

Correcting Etsy Tag Exports

Etsy exports tags with underscores ( _ ) instead of spaces. Use the “Find & Replace” function to replace _ with spaces. Replace all and you’re good to go.

Check out the video tutorial (at 8:18) above to see an example of how to do this.

Combining Images

Etsy lists each image link in its own column, while Stockabl imports them in the same column but separated by a comma.

If you are comfortable with using formulas in a spreadsheet the appropriate formula is:
=CellID &","& CellID &","& CellID &","& CellID

Check out the video tutorial (at 10:03) above to see an example of how to do this.

CellID represents the cell each URL lives in (ex. A3). In the video walkthrough the formula we used was:
=A2 &","& B2 &","& C2 because there were only three columns with image links in them. If you have all ten images in use you will have a longer formula!

We recommend copying and pasting the entire column to a new tab, adding your formula in a new column, and then copying and pasting (values only!) back to the original spreadsheet and deleting the old columns. (See the tutorial video for a visual explanation)

---

---

Variations, Custom Attributes, and Attributes…. oh my

Etsy categorizes attributes and variations separately in their system. However, we use attributes to create variations and to filter products in our system.

Attributes are optional for simple products.

Custom attributes

Custom attributes that you created on Etsy are exported as individual columns. For example, if you used the attribute “MATERIALS” you would find a column for “MATERIALS” and each row would list the materials in the product separated with commas. It is up to you if you want to use these on your Stockabl listings or not.

To use these custom attributes, the column title “Materials” becomes the attribute name listed under Attribute Name and the materials listed become the values under “Attribute Value(s).

Check out the video tutorial (at 12:20) above to see an example of how to do this.

Variations

Variations look a little more like attributes do on our system. Variation type becomes “Attribute Name” while Variation Value becomes “Attribute Value(s).

Adding attributes alone does not create a variable product though, so if you are interested in learning how to do this see our article on variable products.

Step Five: Fill in the columns Etsy doesn’t include

There are few columns missing from the Etsy export file that you will need in the import file to have a complete listing. For a list and explanation of each column on the file please see our CSV import guidelines article.

• Type (simple, variable, variation – simple is most common)
• Wholesale Price
• Published
• Short Description
• Weight (lbs) OR Length (in), Width (in), and Height (in) – only if you need these for calculating shipping rates

---

---

Ready to Submit

Once your file is ready to be imported, submit it via our import request form and a member of our staff will import your file for you within a few days. You will receive an email confirming your submission and another letting you know when the process is complete.