How to bulk list on Etsy: prepare 20 listings in an afternoon
The bottleneck in bulk listing isn't uploading to Etsy — it's the 100+ images and 40-60 print files you need before you can touch the spreadsheet.
Etsy does have a bulk listing tool: a CSV import that lets you create dozens of listings at once. It works reasonably well. The problem is that you can't fill out that CSV until you have all your assets ready — and getting 20 listings worth of mockup images and print files prepared is where sellers lose their entire afternoon.
This guide covers the full workflow: batching your assets with Ratio Ready, filling Etsy's CSV, and importing it so your listings go live without the usual per-listing grind.
Why bulk listing on Etsy is slow
Most sellers assume the slow part of bulk listing is navigating Etsy's interface. It isn't. The interface, once you know it, takes a few minutes. The slow part is everything that has to exist before you open Etsy:
- Mockup images: Etsy recommends 5–10 photos per listing. For 20 listings, that's up to 200 images to create, resize, and export.
- Print-ready files: A typical wall art listing needs multiple sizes (8×10, 11×14, 16×20, etc.). 20 listings × 3 sizes = 60 files to generate, validate, and name correctly.
- File naming and organization: Etsy's CSV references image filenames. If your files are scattered or inconsistently named, the import fails and you're debugging row by row.
Sellers who try to "bulk list" by working listing-by-listing in Etsy's interface aren't really bulk listing — they're just doing 20 individual listings in one session. True bulk listing means batching everything: assets first, upload second.
Related guides: Etsy mockup generator, wall art converter, pricing.
Using Etsy's bulk listing CSV tool
Etsy's CSV import is available under Shop Manager → Listings → Add a listing → Import listings. You download Etsy's template, fill it out, and upload it to create all your listings at once (as drafts, which you review and publish).
What the CSV accepts
- Title — up to 140 characters
- Description — full listing description
- Price — numeric, in your shop currency
- Quantity — set high (e.g. 999) for digital downloads
- Tags — up to 13, comma-separated
- Category — Etsy taxonomy ID or path
- Images — filenames of photos you upload separately
- Digital files — referenced by filename for digital listings
Practical tips for the spreadsheet
- Do one listing manually first and export it — Etsy shows you the exact column format your shop expects.
- Write titles and descriptions in a Google Sheet or Notion table, then paste into the CSV. Editing directly in a CSV editor (Numbers, Excel) makes description formatting messy.
- Tags can be copied across similar listings and tweaked. Don't start from scratch for each row.
- Images are uploaded separately through Etsy's image uploader — the CSV only references the filename. Upload all images before importing the CSV.
- Digital file uploads (your actual print files) are added after import, per listing. The CSV doesn't handle digital file attachment directly — you'll do that during the draft review step.
Etsy's CSV tool is genuinely useful once your assets are staged. The import itself takes a few minutes for 20 listings. The draft review step — checking each listing looks right before publishing — takes another 15–20 minutes. That's manageable. The 3 hours before that, creating assets, is where the time goes.
Batch prepare your listing assets with Ratio Ready
Ratio Ready is built specifically for this step. Upload 1–50 designs at once, select your print sizes, and get back a ZIP with organized print-ready files and mockup images for every design.
What Ratio Ready generates per design
- Print files: Each design exported at every selected size (e.g. 2400×3000px for 8×10, 3300×4200px for 11×14, 4800×6000px for 16×20), with 300 DPI metadata stamped, color profile set to sRGB.
- Mockup images: Lifestyle and frame mockups for each design, properly sized for Etsy's 2000px minimum requirement.
- Organized ZIP: Files named by design + size + type so you can upload to Etsy without renaming anything.
Time comparison
Manually creating files for 20 designs × 3 sizes = 60 print files + mockups typically takes 2–4 hours (export, resize, validate, rename, repeat). With Ratio Ready: upload 20 designs, select sizes, download ZIP — about 10–15 minutes including the processing time.
That's the afternoon you get back. The rest of the bulk listing workflow — filling the CSV, importing to Etsy — takes under an hour from that point.
Start with 75 free credits — enough to process a full 20-listing batch.
The end-to-end bulk listing workflow
Here's the full sequence, start to finish, for a 20-listing batch:
- Finalize your 20 designs. Make sure they're the correct base resolution for your largest print size. For wall art going up to 16×20, you want source files at least 4800×6000px or designed at 300 DPI at that size.
- Batch process in Ratio Ready. Upload all 20 designs. Select your print sizes (e.g. 5×7, 8×10, 11×14, 16×20). Let Ratio Ready generate print files + mockups for every design. Download the ZIP.
- Organize your ZIP contents. Unzip into a folder structure: one folder per listing, containing that listing's mockups and print files. Consistent naming matters here — the image filenames you use will go into the Etsy CSV.
- Fill the Etsy CSV. Open Etsy's template. One row per listing. Fill in titles, descriptions, tags, price, quantity. In the image columns, enter the filenames of your mockup images for each listing.
- Upload all images to Etsy first. Before importing the CSV, go to your Etsy image library and upload all your mockup images. Etsy needs them present before the CSV references them.
- Import the CSV. Shop Manager → Listings → Import listings → Upload your CSV. Etsy creates all listings as drafts.
- Review and attach digital files. Go through each draft. Confirm title, description, and photos look right. For digital listings, attach your print files (the ZIP contents from step 2) to each listing.
- Publish. Select all drafts, publish. Done.
With assets prepped in batch, steps 4–8 realistically take 45–90 minutes for 20 listings. Steps 1–3 with Ratio Ready take 15–30 minutes. Total: under 2 hours for a 20-listing batch, versus a full day doing it listing-by-listing.
Tips for efficient bulk listing
File naming conventions
Use a consistent pattern like design-slug_size_type.jpg — for example, blue-botanical_8x10_mockup1.jpg. This makes it obvious which file is which when you're filling the CSV, and prevents the most common import error (Etsy can't find a referenced image because the filename has a typo or extra space).
Write descriptions in batches
Don't write listing descriptions one at a time in Etsy. Write all 20 in a Google Doc or Notion table first. Group similar designs (same theme, same size range) and write a base description you clone and tweak. Then paste them into the CSV column. Much faster, and you get consistency across related listings.
Reuse and rotate tags
For a themed batch (e.g. botanical prints), create a master tag list of 20–25 relevant tags and rotate 13 per listing. Don't overthink per-listing variation — slight rotation across similar listings is fine. Build your tag list once, paste it into the CSV, then make small adjustments.
Use Ratio Ready's listing PDF
Ratio Ready generates a listing PDF per design with the pixel dimensions and size labels for each file. Copy this into your listing description — buyers want to know exactly what they're downloading. Having this pre-written for every design saves you from writing "Includes: 5×7 (1500×2100px), 8×10 (2400×3000px)…" twenty times by hand.
Do a test import with one row
Before importing all 20 rows, do a test import with a single listing. Verify the draft looks correct — images attached, title right, category correct. Fix any column mapping issues on one row before multiplying them across twenty.
Frequently asked questions
Related guides
Batch your asset prep
Upload up to 50 designs, get print files and mockups for all of them, download a ZIP. 75 free credits on signup.