Amazon Ads Bulksheets for Authors: A Plain-English Guide
Updated 2026-07-15
Bulksheets — Amazon Ads' bulk operations spreadsheets — let you create or edit campaigns, ad groups, keywords, and bids in a spreadsheet instead of clicking through the campaign manager. For authors managing more than a couple of campaigns, they turn hours of clicking into minutes of copy-paste.
When bulksheets are worth it
- Adding 50+ keywords to a campaign (the UI makes this painfully slow)
- Launching the same campaign structure for a new book in a series
- Adjusting bids across many keywords at once
- Adding a batch of negative keywords to several campaigns
How the workflow looks
In the Amazon Ads console, go to Bulk operations, download a bulksheet template (or a spreadsheet of your existing campaigns), edit it in Excel or Google Sheets, and upload it back. Amazon validates every row and reports errors per line.
The columns that matter for keywords
For adding keywords to an existing Sponsored Products campaign, the rows you add reference your existing Campaign ID and Ad Group ID (both are in the downloaded sheet), plus the keyword fields:
- Keyword Text — the keyword itself
- Match Type — broad, phrase, or exact (negative exact / negative phrase for negatives)
- Bid — your max cost-per-click for that keyword
- State — enabled
Common upload errors to avoid
- Wrong or missing Campaign/Ad Group IDs — always start from a downloaded sheet
- Invalid match type values — use Amazon's exact wording
- Duplicate keyword + match type combinations in the same ad group
- Keywords over Amazon's length limit (10 words / 80 characters for most types)
Generate the keyword rows automatically
The tedious part is producing hundreds of keyword rows with match-type variants in the right format. Our free tool exports exactly those columns — Keyword Text, Match Type, Bid, State — as CSV, so you paste them into your downloaded bulksheet, fill in the IDs, and upload.