Understanding the WhatNot CSV Format: Every Column Explained

A complete guide to every column in the WhatNot CSV format -- what each field does, which ones are required, and how to avoid upload errors.

---

You have heard that you can bulk upload listings to WhatNot using a CSV file. Maybe you have even tried it and gotten a cryptic error message that told you nothing useful. You are not alone. The WhatNot CSV format trips up even experienced sellers, and understanding exactly what goes in each column is the difference between a clean upload and a frustrating hour of troubleshooting.

This guide breaks down every column in the WhatNot CSV format, explains what is required versus optional, and covers the formatting mistakes that cause most upload failures.

What Is a CSV and Why Does WhatNot Use It?

CSV stands for Comma-Separated Values. It is a plain text file where each line is a listing and each piece of data is separated by a comma. Think of it as a spreadsheet without the formatting — just raw data in rows and columns.

WhatNot uses CSVs because they are universal. You can create them in Excel, Google Sheets, or any tool that exports structured data. They are also easy for WhatNot’s system to parse and turn into listings automatically. For sellers with 50, 100, or 500+ items, uploading a CSV is dramatically faster than creating listings one at a time in the app.

The Columns: What Goes Where

Here is every column in the WhatNot CSV format, what it does, and what you need to know about it.

title (Required)

The listing title that buyers see. Keep it clear and searchable. Include the comic name, issue number, publisher, and any key details like “first appearance” or “variant cover.”

Good: Amazing Spider-Man #300 – First Venom – Marvel 1988

Bad: ASM 300 venom!!!

Avoid special characters that might break the CSV parsing. Commas inside your title are fine as long as the entire title field is wrapped in quotes (most export tools handle this automatically). Stay away from curly quotes, em dashes, and other non-standard characters.

category (Required)

The top-level WhatNot category. For comic sellers, this is typically “Comics.” The value must match WhatNot’s exact category names — not your interpretation of them. “Comic Books” will fail. “Comics” will work. Capitalization matters on some imports.

subcategory (Required)

The specific subcategory within your main category. For comics, common subcategories include “Single Issues,” “Graded Comics,” “Trade Paperbacks,” and “Lots.” Again, these must match WhatNot’s exact naming. Check their current subcategory list before your first upload because they update it periodically.

description (Recommended)

A text description of the listing. This is technically optional but practically mandatory. Listings without descriptions look lazy and convert worse. Include condition details, any notable defects, and context that makes the book desirable.

Keep it concise. Buyers skim. Two to three sentences is the sweet spot. Do not paste in your entire life story or a wall of hashtags.

starting_price (Required)

The opening bid price for auction-style listings. This must be a number only — no dollar signs, no commas, no currency symbols. Just the digits and optionally a decimal point.

Correct: 5.00

Wrong: $5.00

Also wrong: 5,00

This is the single most common formatting error in WhatNot CSV uploads. Your spreadsheet might display prices with dollar signs, but the exported value must be clean. If you are using LiveSeller Pro, the export handles this automatically — no dollar signs, no formatting artifacts.

buy_now_price (Optional)

A fixed price that lets a buyer skip the auction and purchase immediately. Same formatting rules as starting_price — numbers only, no symbols. If you leave this blank, the listing is auction-only. If you set it, make sure it is higher than your starting price (obviously) and reflects a fair “skip the wait” premium.

quantity (Required)

How many of this exact item you have. For single comics, this is almost always 1. For lots or supplies, it might be higher. Must be a whole number — no decimals, no text.

condition (Recommended)

The condition of the item. WhatNot has specific condition values they accept. For comics, common values include “Near Mint,” “Very Fine,” “Fine,” “Very Good,” “Good,” and “Fair.” Graded books should reference the grade (e.g., “CGC 9.8”). Check WhatNot’s accepted condition values for your category — using a non-standard value may cause the field to be ignored or the upload to fail.

shipping_profile (Required)

The name of the shipping profile you have set up in your WhatNot seller settings. This is not a price — it is a reference to a pre-configured shipping option. You must create shipping profiles in your WhatNot account first, then use the exact profile name in your CSV.

Common mistake: putting a shipping price like “4.99” in this field. WhatNot expects a profile name like “Standard Comic Shipping” — whatever you named it in your settings.

Common Formatting Errors That Kill Uploads

Most CSV upload failures come down to a handful of preventable mistakes:

1. Dollar signs in price fields: The number one offender. Strip all currency symbols before uploading.
2. Wrong category or subcategory names: These must be exact matches. Copy them from WhatNot’s documentation, do not type them from memory.
3. Special characters in titles: Curly quotes, trademark symbols, and non-ASCII characters can break CSV parsing. Stick to standard keyboard characters.
4. Empty required fields: If title, category, subcategory, starting_price, quantity, or shipping_profile is blank on any row, that row fails.
5. Extra commas: If your description contains commas and the field is not properly quoted, the parser thinks each comma starts a new column. Everything shifts and the entire row is garbage.
6. Wrong file encoding: Save as UTF-8 CSV. Some versions of Excel default to other encodings that introduce invisible characters at the start of the file.

How LiveSeller Pro Handles All of This

You can absolutely build your CSV manually in Google Sheets or Excel. Plenty of sellers do. But if you are managing more than a few dozen listings, the manual approach gets tedious and error-prone fast.

LiveSeller Pro generates WhatNot-ready CSV files directly from your inventory. It handles all the formatting rules automatically — correct column names, clean price values, properly quoted text fields, and valid category mappings. You focus on your inventory and pricing; the tool handles the technical formatting.

If you want to learn more about the full export workflow, check out our HeroHunter key issue identification guide to see how inventory data flows from identification through export.

Why This Matters for Your Business

Understanding your CSV is not just a technical exercise. It is about control. When you know what each column does, you can troubleshoot problems faster, customize your listings more effectively, and move from uploading 20 books to uploading 200 without the process breaking down.

The sellers who treat their data seriously are the ones who scale. They spend less time fighting with spreadsheets and more time running shows and growing their audience. That is the goal.