How to Export Amazon Listings to Excel: The All Listings Report Walkthrough
To export your Amazon listing catalog to Excel, go to Reports → Inventory Reports in Seller Central, pick the All Listings report (or the Active Listings report if you only want live offers), click Request Report, wait 15 to 45 minutes, then download the file — Amazon delivers it as a tab-delimited .txt, not as a spreadsheet. Two things trip people up: picking a report from the wrong menu, and opening that .txt by double-clicking instead of running Excel’s import wizard, which silently mangles UPCs and ISBNs. This guide covers both, plus every column in the file. Data checked 2026-09-05 against Amazon’s Seller Central help pages.
The two report menus people confuse
Seller Central has two report families that both use the word “inventory,” and searches for “export Amazon listings” route people into the wrong one constantly. Different menus, different files, different questions.
| Catalog reports | FBA / stock-movement reports | |
|---|---|---|
| Menu path | Reports → Inventory Reports | Reports → Fulfillment |
| Help page | “Download an inventory report” | “Amazon Fulfillment reports” |
| One row is | One listing (SKU + offer) | One stock event or FBA stock position |
| Typical reports | All Listings, Active Listings, Open Listings | Inventory Ledger, Manage FBA Inventory, Inventory Health |
| File format | Text, tab delimited (*.txt) | .csv or .txt |
| Answers | What am I selling, at what price, under which SKU? | How many units moved, and where are they? |
If you want a spreadsheet of your catalog — every SKU, its title, its price, its ASIN — you want the Inventory Reports menu. If you want to reconcile units in Amazon’s warehouses, you want Fulfillment, where Amazon describes the Inventory Ledger report as “like a bank statement for your inventory,” covering “starting inventory balance, received inventory, customer orders, customer returns, adjustments, removals, and ending balance” across 18 months.
One report sits in both worlds and causes half the confusion: the Amazon Fulfilled Inventory report appears in the Inventory Reports drop-down, but Amazon describes it as “a near real-time snapshot of your inventory in Amazon’s fulfillment centers” — a stock report wearing a catalog report’s badge. If you were told to “pull the inventory report” and got FNSKUs and warehouse quantities instead of titles and prices, this is the one you pulled.
A third family is neither: Seller Central’s Business Reports cover sessions, Buy Box percentage and conversion, and never contain a full SKU list.
Which listing report to request
The Inventory Reports drop-down carries several report types. Amazon’s own descriptions, condensed:
| Report | What it contains | Use it when |
|---|---|---|
| All Listings report | “A snapshot of all products for a specific seller… includes listings that are active, inactive, and incomplete” | You want the complete catalog — the default for migrations and audits |
| Active Listings report | Everything currently listed, “including those with zero (0) quantity,” plus matched product title and identifier | You want the live catalog only, up to 50,000 listings |
| Inactive Listings report | Same columns, inactive half only: zero quantity, blocked, suppressed, not yet opened, past sale end date | You are cleaning up dead SKUs |
| Open Listings report | Seller-fulfilled open listings; “Amazon-fulfilled listings are not included in this report” | You run FBM and want a fast price/quantity file |
| Open Listings Lite / Liter | Lite = seller-SKU, quantity, price, product ID. Liter = seller-SKU, quantity | You only push price and quantity updates |
| Inventory report | SKU, price, quantity and ASIN per current offer | You have more than 50,000 open listings |
| Canceled Listings report | Listings Amazon canceled in the past 30 days | You are chasing disappearing SKUs |
Two limits decide the choice. Amazon states you can use the Active Listings report “if you have up to 50,000 listings. If you have more than 50,000 listings, you must use the Inventory Report.” And there is a throttle: “do not request more than four Inventory Reports per day,” dropping to one per day above 500,000 listings.
One more gate: the page notes that “this feature is only available to sellers with a Professional selling plan.” Individual sellers get no catalog export at all — a quiet reason to compare the Individual and Professional plans before committing.
The five-step export
Amazon’s help page “Download an inventory report” gives the sequence:
- Go to Reports and select Inventory Reports. This is the catalog menu, not the Fulfillment menu.
- Select the report type from the drop-down menu, using the table above.
- Click Request Report. Nothing downloads yet; Amazon queues the job.
- Wait. Amazon’s stated window: “Reports generally take 15 to 45 minutes to generate. You can return to this page later to pick up your completed report.” Large catalogs sit at the long end.
- Download it. “Under Check Report Status & Download, when the report status is ‘Ready’, click the Download.” Amazon then says to “save the file to your local computer in text (tab delimited, *.txt) format” and “open the report in a spreadsheet or database program, such as Microsoft Excel or Microsoft Access.”
Two details worth calendaring. Reports expire: “the most recently requested reports are available for 30 days, after which they are removed from your seller account.” And the file is a photograph, not a feed — because customers can buy at any time, “the quantities in an inventory report are at best a spot check of your saleable inventory. It may be out of date almost as soon you request it.”
Opening the .txt in Excel without wrecking your IDs
This is where most exports go wrong, and the damage is silent: the spreadsheet looks fine and is quietly wrong.
Do not rename .txt to .csv or .xlsx. The columns are separated by tab characters; renaming to .csv tells Excel to split on commas instead, so every row lands in one column — and any item name containing a comma breaks the split you improvise.
Do not just double-click it either. Amazon’s own field documentation flags the failure mode: “If you open the report in Microsoft Excel, the leading zeroes for ISBNs in the product ID column will be dropped by Excel. You can prevent this by using the import wizard and forcing the product-id column to be imported as text.” The same applies to any zero-padded UPC, EAN or numeric SKU.
The safe import, in Excel:
- Open Excel first with a blank workbook — do not open the file from Finder or Explorer.
- Use Data → Get Data → From Text/CSV (or the legacy From Text import wizard).
- Choose the downloaded
.txt, set the delimiter to Tab, and set encoding to UTF-8 so accented item names survive. - Before finishing, set the data type for
product-id,seller-skuandlisting-idto Text. This is the step that preserves leading zeros. - Save as
.xlsxonly as a working copy — keep the original.txtuntouched as your source of truth.
In Google Sheets: File → Import → Upload, separator type Tab, and switch off the option that converts text to numbers and dates.
Amazon confirms the same hazard from the other menu: fulfillment reports come as .csv or .txt, but “using .csv format will let you open reports in a spreadsheet, however, the leading zeros from MSKUs, ASINs, and FNSKUs will be dropped. If you require the leading zeros, you can download the file in .txt format.”
What the columns mean
The Active Listings, Inactive Listings and All Listings reports share one column set, documented by Amazon on “To read an Active Listings Report”. The fields that carry real information:
| Field | What it is |
|---|---|
item-name | “The title of the item listed. This will be populated with Amazon catalog data” |
seller-sku | Your own SKU — “assigned by you as the seller” |
listing-id | Amazon’s listing identifier: “4 digits, a capital letter, and 6 more digits” |
price | “The price you are asking for the product” |
quantity | “The quantity of the product available for purchase” |
product-id | “ASIN, ISBN, UPC, or EAN for the item” |
product-id-type | Which of those it is: 1 = ASIN, 2 = ISBN, 3 = UPC, 4 = EAN |
item-condition | Numeric condition code, 11 = New, 10 = Refurbished, 1–4 used tiers, 5–8 collectible tiers |
item-note | “Your description of the listing” — the condition note buyers see |
pending-quantity | “The quantity of the item that is pending purchase at the time of the report” |
fulfillment-channel | “Will indicate for FBA sellers if the listing is set for seller fulfilment or fulfilment by Amazon” |
The rest — item-description, zshop-category1, zshop-browse-path, zshop-boldface, asin2, asin3, bid-for-featured-placement — are marked in Amazon’s own documentation as “used for backwards compatibility only,” and Amazon’s guidance is blunt: “If you do not need any of these fields, you may delete the columns from your downloaded report.” One landmine: asin1 is documented as “not used. The field is populated with the product-id,” so do not build an ASIN join on it without checking product-id-type first.
What the export is actually for
Three jobs justify the 45-minute wait:
ERP or listing-tool migration. Any system that will manage your catalog needs a seed file with SKU, ASIN, price and fulfillment channel — exactly the All Listings column set. Exporting first also surfaces the SKUs your team forgot existed, which is cheaper to discover before onboarding than after. If you are choosing the destination system, the shortlist starts with Amazon inventory management software.
Agency and VA reconciliation. When someone else runs your account, the All Listings report is the only artifact showing the whole catalog on one date, incomplete and inactive SKUs included. Two exports a month apart, diffed in Excel, expose every price change and every SKU that appeared without a ticket.
A baseline snapshot before bulk changes. Export immediately before any bulk price change, flat-file upload, or new repricing rule goes live. If the change misfires, that file is your rollback source — it holds the previous price for every SKU. Capture it before, not after, configuring an Amazon repricer.
What the export will not give you
Read the gaps before you build a process on the file:
- No image URLs, bullet points or A+ content. These reports carry offer data, not listing copy — pulling creative assets is a separate job, see downloading Amazon product images in bulk.
- No warehouse-level FBA detail.
quantityandfulfillment-channelare as far as it goes. Units held back as reserved inventory will not reconcile against this file; that is the Inventory Ledger’s job. - No reason codes for inactive SKUs. The Inactive Listings report says a listing is inactive, not why — diagnosing that is a separate workflow, see suppressed listings.
- Not a live feed. Amazon calls the quantities “at best a spot check,” and the file expires after 30 days.
- No sales or traffic data. No sessions, units ordered, or Buy Box percentage.
Common mistakes
- Requesting from Reports → Fulfillment when you wanted the catalog, then concluding Amazon has no listing export.
- Double-clicking the
.txtand losing leading zeros inproduct-id— the single most common silent corruption. - Renaming
.txtto.csvto make Excel cooperate, which splits on the wrong character. - Using the Active Listings report above 50,000 listings, where Amazon requires the Inventory report instead.
- Requesting the same heavy report repeatedly while waiting, against Amazon’s four-per-day guidance.
- Treating the
quantitycolumn as a live stock figure for reordering decisions. - Letting the download age past 30 days and expecting to re-download the same file.
Frequently Asked Questions
Can I export Amazon listings to Excel on an Individual plan?
No. Amazon’s Inventory Reports help page states the feature “is only available to sellers with a Professional selling plan,” and repeats that “sellers with Professional selling accounts can download inventory reports” (checked 2026-09-05).
Why does Amazon give me a .txt file instead of a spreadsheet?
Because the reports are delivered as tab-delimited text. Amazon’s documentation describes the Active Listings Report as “a tab-delimited file that you can open in any spreadsheet or database program, such as Microsoft Access or Microsoft Excel.” Import it with the tab delimiter rather than converting the file extension.
Which report includes SKUs with zero quantity?
The Active Listings report does — Amazon states it “includes all of your product listings, including those with zero (0) quantity.” The Open Listings report does not: Amazon’s “Additional Inventory Report Formats” page documents that it “does not show listings with a quantity of zero (0).”
Does the listing export show how much FBA stock I have in each warehouse?
No. For fulfillment-center-level movement you need the Fulfillment menu — the Inventory Ledger report, which Amazon documents as showing inventory events “by SKU and disposition” with detailed transactions “tracked for the trailing 18 months.”
Can I edit the file and upload it back to change my listings?
Yes, with one reshaping step first. Amazon states that listing data and columns “can then be modified within the spreadsheet, and uploaded at any time using the Inventory Loader or Listing Loader,” but its “Use reports to update inventory” page adds the step in between: from an Active Listings report, delete listing-id, open-date and pending-quantity, then rename seller-sku to sku. Keep the original download as an untouched backup before you edit anything.
The bottom line
Exporting your Amazon listings to Excel is a five-minute task wrapped around a 45-minute wait, and only two decisions matter: which menu you start from, and how you open the file. Start at Reports → Inventory Reports for a catalog snapshot; start at Reports → Fulfillment only when you are chasing units, not SKUs. Then import the tab-delimited .txt through Excel’s import wizard with product-id forced to text — because a catalog export with the leading zeros stripped out looks perfectly healthy right up to the moment you try to match it against anything.
Paths, report names, formats and field definitions checked 2026-09-05 against Amazon Seller Central help pages G561, G200385890, G200388930, G200388940, G201104750 and G4FKT5KQWFFJ7LDN.