How to bulk update title Metadata via CSV
info
Why use bulk updates?
If you manage hundreds of titles, manually updating metadata can take hours. Common issues include:
- Amazon KDP often assigns incorrect publication dates
- Series order may be wrong and needs correction
- Book aliases need to be assigned across multiple titles
- Author names require updating or grouping
Bulk updates let you fix all these issues in minutes instead of hours!
warning
Important: Changes are permanent once applied. Always review your CSV file carefully before uploading.
Steps
1. Download your book metadata
- Navigate to the Bookshelf & BSRs page
- Click the Download/Update titles in bulk button
2. Edit the downloaded CSV file
The downloaded .csv file contains all your books. Each column represents specific metadata you can modify:
| Column Name | Description and Usage |
|---|---|
| Modified | Update to "Yes" only if you have modified the row and want to apply the changes |
| Unique ID | Do not modify. This is your book's unique identifier in the system |
| Source | The platform/distributor for your book. Options: "ACX", "Amazon", "Apple Books", "Barnes & Noble Press", "BookMundo", "BookBub Ads", "Draft2Digital", "Facebook", "Google Books", "IngramSpark", "Kobo Writing Life", "PublishDrive", "Shopify", "Spotify for Authors", "Voices by INaudio", "WooCommerce", "Other". Select only one |
| Title | Leave as is. Your book's title from the source platform |
| Title Alias | Optional. Use to group books under a common name or override the display title |
| Format | Book format. Options: "Paperback", "Hardcover", "EBook", "KENP Reads", "Other", "Audiobook" |
| Author | Leave as is. The author name from the source platform |
| Author Alias | Optional. Use to group books under a pen name or override the author display name |
| Publication Date | The book's publication date on the source platform. Must be in YYYY-MM-DD format with quotes, e.g., "2026-01-12" |
| KENPC v3.0 | Amazon's Kindle Edition Normalized Page Count value (learn more). Enter as a positive integer or leave blank |
| Series Name | Assign your book to a series. New series names will be created automatically |
| Number In Series | Your book's position in the series (e.g., 1, 2, 3). Must be a positive integer. Leave blank if not part of a series |
| Archived | Set to "Yes" if you want to archive the row/book and hide any data related to this row across the whole platform. Set to "No" to restore the row/book |
Tips for editing:
- Use Excel, Google Sheets, or any spreadsheet software
- Keep the Unique ID column unchanged
- Make sure dates are formatted correctly with quotes: "2026-01-12"
- Use consistent series names to group books together
3. Upload your updated file
- Return to the Bookshelf & BSRs page
- Click the upload button and select your modified CSV file
- If there are any errors, they'll appear below the upload button
- Fix any errors and re-upload until successful
4. Done!
Your title metadata is now updated! All changes will be reflected immediately across your bookshelf.
Need help? If you encounter any issues, check that your CSV follows the format requirements above, especially:
- Modified: Change to Yes if you want your changes to be applied
- Date format: "YYYY-MM-DD" with quotes
- Source and Format values match the exact options listed
- KENPC and Number In Series are positive integers (or blank)