Etsy Listing CSV Formatter
Copy your product rows from a spreadsheet, paste them below, and get a clean, validated CSV — ready to drop straight into Etsy's bulk listing upload tool. Every title, tag, and price is checked against Etsy's published limits before you download.
Expected column headers (copy this into your spreadsheet row 1):
TITLE PRICE QUANTITY SKU TAGS DESCRIPTION SKU and DESCRIPTION are optional. TAGS = comma-separated keywords (max 13, each max 20 chars). One product per row.
What this tool validates
These are the rules Etsy enforces on every listing — the formatter catches them before you upload so you don't hit errors inside Etsy's interface:
| Rule | Etsy limit | What happens if you exceed it |
|---|---|---|
| Title length | 140 characters max | Etsy truncates the title silently — your SEO keywords at the end disappear |
| Tags per listing | 13 tags max | Extra tags are ignored; the formatter drops them from the CSV automatically |
| Characters per tag | 20 characters max | Etsy rejects the tag on upload; the listing saves but the tag is lost |
| Minimum price | $0.20 USD | Upload fails with an error for that listing row |
| Quantity | 1–999 per listing | Upload fails or quantity is capped to 999 |
Validation examples
Sample rows run through this exact validator — showing what passes and what gets flagged:
| Sample listing | Result |
|---|---|
| Autumn mug — 5 tags, $24.99 | ✓ Passes |
| Title 141 chars (over the 140-char Etsy limit) | ⚠ TITLE: Title is 141 chars — Etsy limit is 140. |
| Price $0.10 (below Etsy $0.20 minimum) | ⚠ PRICE: Price must be at least $0.20. |
| 14 tags (over the 13-tag Etsy limit) | ⚠ TAGS: 14 tags — Etsy allows max 13. Last 1 will be dropped. |
| Tag "handmade ceramics" is 18 chars — fine | ✓ Passes |
How to use this with Google Sheets
- Open a new Google Sheet and type the column headers in row 1: TITLE, PRICE, QUANTITY, SKU, TAGS, DESCRIPTION
- Enter your product data — one product per row. For TAGS, separate each keyword with a comma inside the cell (e.g. fall decor,wall art,autumn print)
- Select all your rows (Ctrl+A), copy (Ctrl+C), and paste into the box above
- Click Format & Validate — fix any warnings shown, then download your CSV
- In Etsy: go to Shop Manager → Listings → Import listings and upload the file
Need to check your margins before listing? Use the Etsy Pricing Calculator to find the right price for each product, or the Etsy Fee Calculator to see the exact fees on any sale.
Frequently asked questions
What columns does Etsy's bulk listing CSV require?
Etsy's bulk upload CSV uses these columns: TITLE (required, max 140 chars), PRICE (required, min $0.20), QUANTITY (required, 1–999), SKU (optional), TAGS (optional, max 13 tags each max 20 chars), and DESCRIPTION (optional). This tool outputs exactly those columns in the right order with proper quoting.
How do I get my product data into the right format to paste?
Set up a Google Sheet or Excel spreadsheet with these column headers in the first row: TITLE, PRICE, QUANTITY, SKU, TAGS, DESCRIPTION. Enter one product per row. Then select all cells (Ctrl+A), copy (Ctrl+C), and paste directly into the box above. The tool auto-detects tab-separated format from spreadsheets.
Why are my tags being truncated or flagged?
Etsy enforces two tag limits: a maximum of 13 tags per listing, and a maximum of 20 characters per tag. If you paste more than 13 tags, the tool will silently drop the extras from the CSV. If any individual tag is over 20 chars, you'll see a warning — you'll need to shorten those tags manually before uploading. The validation table shows you exactly which row and which tags are over-length.
What happens to tags with commas in them?
Tags should be comma-separated in your spreadsheet (e.g. "fall decor,wall art,autumn"). The formatter treats each comma-separated item as one tag. Make sure individual tag phrases don't contain commas themselves — Etsy treats commas as tag separators, so "red, white" becomes two tags: "red" and " white".
Can I include a description with commas or quotes?
Yes — the formatter properly wraps every cell in double quotes and doubles any internal double quotes (the standard CSV escaping rule). So a description like: Fits a 5"x7" frame, perfect for any room — comes through the CSV cleanly and Etsy's uploader will read it correctly.
Is my data sent anywhere?
No. Everything runs in your browser — your product data never leaves your device. There is no server, no upload, no account. The CSV is generated locally and downloaded directly to your computer.
More free tools
Etsy Tags Bulk Validator
Paste your Etsy listing tags — flag any over 20 chars or duplicates, then copy a clean, Etsy-ready set of up to 13 tags.
POD Shipping & Free-Shipping Margin Calculator
Check if your package triggers USPS dimensional weight, then see exactly what free shipping does to your Etsy profit margin.
Etsy Break-Even Units Calculator
Enter your sale price, product cost, and monthly revenue or profit goal — see exactly how many units you must sell after all Etsy fees.