What file format does AMZTool generate?

AMZTool generates .xlsx (Excel) files that match Amazon's official Sponsored Products bulk sheet template. You can upload them directly to Amazon Ads without any reformatting.

Which Amazon marketplaces are supported?

The generated bulk sheets use Amazon's standard English-format column headers, which are accepted across all Amazon marketplaces worldwide including US, UK, DE, JP, and more.

Is there a free plan available?

Yes. Free accounts can generate up to 12 bulk sheets per month with full access to all targeting types including keyword, ASIN, and auto targeting. No credit card required.

Do I need an Amazon Ads API account?

No. AMZTool generates downloadable Excel files. You upload them manually through Amazon's Bulk Operations page in Seller Central or Amazon Ads console — no API credentials needed.

How do I upload the generated file to Amazon?

Go to Amazon Ads console, navigate to Bulk Operations under Campaign Manager, click Upload file, and select your generated .xlsx file. Amazon will validate and process your campaigns automatically.

Is my campaign data secure?

Yes. All data is encrypted, stored per-user with Row Level Security, and never shared with third parties. AMZTool does not have access to your Amazon Ads account.

AMZTool/Blog/Portfolio ID Guide

Tutorial

How to Find Your Amazon Portfolio ID

Portfolio IDs let you group Amazon ad campaigns together for budget management and reporting. Here's how to get them in 2 simple steps.

Also available in: 中文版

William

2 min read·Published: April 7, 2026

Download Brand Assets Data

Open Amazon Ads — go to ads.amazon.com or Seller Central → Advertising → Campaign Manager.
In the left navigation, click Bulk Operations.
Under "Include", check the Brand assets data checkbox (see screenshot below).
Click Create spreadsheet for download. Wait for the file to be generated and download it.

Check "Brand assets data" in Amazon Ads Bulk Operations page

Find Portfolio ID in the Spreadsheet

Open the downloaded .xlsx file in Excel or Google Sheets.
Look for rows where the Entity column says Portfolio.
The Portfolio ID column contains the numeric ID you need. The Portfolio Name column shows the name you gave it.
Copy the Portfolio ID and save it in AMZTool's Dictionary (Dict tab → Portfolio section).

Bulk sheet spreadsheet showing Portfolio ID and Portfolio Name columns

Portfolio rows in the downloaded spreadsheet — copy the Portfolio ID value

💡

Tip: Save your Portfolio IDs in AMZTool's Dictionary with friendly names (e.g., "US Main Brand"). They'll appear as a dropdown menu in the campaign settings, so you never need to look them up again.

Ready to Build Your Campaigns?

Start generating Amazon bulk sheets for free.

Or read: Bulk Sheet Guide · Upload Tutorial

Get Started Free

William

Amazon PPC practitioner turned indie developer. I built AMZTool because I got tired of spending hours on repetitive campaign setup. When I'm not coding, I'm probably staring at ACOS numbers.

Published in:TutorialPortfolio