Amazon bulksheets let you create and edit Sponsored Products, Brands and Display campaigns in a spreadsheet. Download a custom file from Bulk operations, change only the rows you need, set the Operation column to Create, Update or Archive, upload, then fix whatever the error report flags. Use bulksheets for hundreds of rows, the console for one-off edits, and an AI assistant when the change needs analysis first.
- The first three columns are always Product, Entity and Operation.
- Rows with a blank Operation are ignored, so you can leave context rows in the file.
- New campaigns use a text "temporary ID"; updates need the numeric ID from a bulksheet download, not the console.
- Archive is permanent. Pause instead when unsure.
Bulk, console or assistant: which one?
Pick the tool for the job
| Console | Bulksheet | Claude via MCP | |
|---|---|---|---|
| Change 5 bids | Best | Overkill | Fine |
| Change 2,000 bids by formula | No | Best | Good if the rule needs analysis first |
| Add 300 negatives from search terms | Slow | Good | Best: it can pick them from the report too |
| Build 20 campaigns from a plan | Slow | Best for large builds | Good, with a preview of each |
| Rename to a new naming convention | Slow | Best | Good |
| Pause everything for an out-of-stock product | Slow | Good | Best: find and pause in one request |
| First new Sponsored Brands ad | Required (assets) | Needs asset IDs first | Needs assets uploaded first |
Bulksheets cover all sponsored ads campaign types (Amazon’s bulksheets FAQ). The legacy template was deprecated on 28 September 2023, so any file or macro older than that needs rebuilding (bulksheets overview).
The bulksheets workflow
Edit Amazon campaigns with bulksheets
The download, edit, upload and fix loop an agency team uses.
⏱ About 30 minutes
- 01
Open Bulk operations
In the Amazon Ads console go to Sponsored ads > Bulk operations. Sellers can also reach it from Seller Central under the campaigns view.
- 02
Create a custom spreadsheet
Pick a date range (up to 60 days) and tick what you need: campaign items with zero impressions for keyword clean-ups, placement data, Sponsored Products search term data, brand assets data for Sponsored Brands builds.
- 03
Keep an untouched copy
Save the download as your rollback file before editing anything.
- 04
Filter and edit
Filter the Entity column to what you are changing (Keyword, Product targeting, Campaign). Edit values and set Operation to Update, Create or Archive only on rows that change.
- 05
Follow the format rules
Dates as YYYYMMDD, percentages as whole numbers (Sponsored Brands placement multipliers take the % sign), no currency symbols or thousands separators, bids to two decimals.
- 06
Upload and read the result
Upload on the same page. If the history shows "Finished with errors", download the error report, fix the rows in that file and upload it again.
- 07
Check in the console
Spot-check a few campaigns and keep the edited file with the date in your change log.
Column cheat sheet
Sponsored Products bulksheet columns that matter
| What it does | Gotcha | |
|---|---|---|
| Product | Sponsored Products, Sponsored Brands or Sponsored Display | One tab per ad product |
| Entity | Campaign, Ad group, Product ad, Keyword, Negative keyword, Product targeting, Bidding adjustment | One row per entity |
| Operation | Create, Update or Archive | Blank = row ignored |
| Campaign ID / Ad Group ID | Links child rows to parents | New: any text, same in every child row. Existing: numeric bulksheet ID, not the console ID |
| Campaign Name | The name shown in the console | Rename with Operation = Update |
| State | enabled or paused | Pause instead of Archive |
| Daily Budget | Campaign budget | No symbols or commas |
| Bid / Ad Group Default Bid | Keyword or target bid; ad group default | Two decimals |
| Keyword Text / Match Type | The keyword and broad, phrase, exact or negative match | Watch special characters |
| Bidding Strategy | Dynamic bids - down only, Dynamic bids - up and down, Fixed bid | Exact wording |
| Placement / Percentage | On a Bidding adjustment row: top of search, rest of search or product page | Whole numbers |
| Product Targeting Expression | ASIN, category or auto group (close-match, loose-match, substitutes, complements) | Auto groups appear as rows you can bid on |
| Eligibility status | Whether each product ad can serve, with the reason | Read-only, but the fastest eligibility audit |
Three recipes
Bulk bid changes by formula
Download keywords and product targets with 30 to 60 days of data. A common formula is new bid = (sales ÷ clicks) × target ACOS: what a click earns, times the share you can spend. Cap changes to a set percentage per round (starting point: 20 to 30%), skip rows with too few clicks, set Operation to Update on changed rows only.
Negatives from search terms
Tick Sponsored Products search term data in the download. The tab carries campaign and ad group IDs, so you can turn chosen terms into Negative keyword rows with Operation = Create. Remember the tab’s fixed 7-day lookback (Amazon); use the console report for longer windows.
A new campaign from a template
Write a Campaign row with a text ID such as "AE_SP_GEN_EXACT_Knives", then Ad group, Product ad, Keyword and Bidding adjustment rows using the same text IDs (create a Sponsored Products campaign). The start date can’t be in the past, so a file prepared on Monday and uploaded on Tuesday fails if it says Monday.
Where this goes wrong
- Console IDs in an update. Amazon says bulksheet IDs differ from console IDs (FAQ). Always update from a fresh download.
- Editing a stale file. A colleague or a rule changed bids since your download, and your upload overwrites them. Download again just before you upload.
- Archiving to "clean up". Archived entities "cannot be changed in any way" (error reports). Pause.
- Spreadsheet software reformatting IDs. Long numeric IDs can turn into scientific notation or lose digits. Format ID columns as text before saving.
- Sponsored Brands without assets. Logos and videos must already be in your creative assets library before a bulksheet can use them.
- One huge file. Split by ad product or portfolio so one error doesn’t block everything and the error report stays readable.
Do it faster with Whathead
Whathead doesn’t read or write bulksheet files. Instead, Claude or ChatGPT makes batch changes through the Amazon Ads MCP: adding keywords and negatives, changing bids and budgets, pausing product ads, across Sponsored Products, Brands and Display. Use it when the change needs analysis first; for thousands of plain edits you already have in a sheet, the bulksheet is still the right tool. Whathead is our product.
- “Find every enabled product ad for these three ASINs across all campaigns in the UAE profile and pause them. Show me the list and the preview.”
- “For keywords with 20+ clicks in the last 30 days, set bid = sales per click × my target ACOS of [Y]%, capped at ±[Z]% from today. Preview the changes as a table with old and new bids.”
Each batch comes back as a dry-run preview of the exact change before anything is sent, and destructive actions such as deletes need an extra confirmation. For the same safety habits on any platform, see bulk editing ads safely.
Related: the weekly search term harvest, campaign structure and naming, and the bulk upload guides for Facebook Ads and creatives across platforms.
Amazon bulksheets: common questions
Why did my Amazon bulk upload fail?
Download the error report from the Bulk operations history. The most common causes are console IDs instead of bulksheet IDs, a child row whose temporary ID doesn’t match its parent, a start date in the past, and formatting such as currency symbols or commas.
Can I create new campaigns with bulksheets?
Yes, for Sponsored Products, Sponsored Brands and Sponsored Display. Use text temporary IDs for new campaigns and ad groups. Sponsored Brands also needs brand assets already in your creative assets library.
What changed in Bulksheets 2.0?
The template now starts with Product, Entity and Operation columns, and the legacy template stopped working on 28 September 2023. Old files and macros need rebuilding.
Can I fix errors without starting again?
Yes. Amazon lets you edit the rows in the error report file and upload that file again. Rows that failed only because a parent failed are fixed once the parent row is fixed.
Do bulksheets show whether a product is eligible to advertise?
Yes. A custom download includes Eligibility status and Reason for ineligibility next to product ads, which makes it the quickest catalogue-wide eligibility check.
Sources
- Amazon Ads advanced tools center: bulksheets overview, get started, FAQs, error reports, create a Sponsored Products campaign, search term report in bulksheets
- Whathead: Amazon Ads MCP, Amazon Ads connection setup
Written by Ahmed Shahin, founder of Whathead. Last reviewed 19 November 2026.
Batch Amazon changes with a preview
Ask Claude for the change, check the dry-run table of old and new values, then confirm.



