If you'd like to add or edit multiple books at a time, consider using spreadsheets. You can download a spreadsheet that's pre-filled with all the information you've already entered in the Partner Centre, adjust the settings and bibliographic information for your titles on your own computer, then upload your edited spreadsheet to apply those changes.
Download a spreadsheet
When viewing your Book Catalogue, click the Export books button. Tick the box labelled Show metadata columns to include bibliographic information and basic settings for your books. By default, your spreadsheet will contain information for all the books in your catalogue. If you want to generate a spreadsheet of a subset of your books, first run a search in your Book Catalogue. The downloaded spreadsheet will only include the search results.
If your books can be sold on Google Play, you can download prices along with the rest of your book data. To do so, tick the box labelled Show price columns.
You can also add prices. For example, you may wish to provide list prices in a new currency. Click the box labelled Add new prices to these books and specify the price type for the new price.
The price type is everything about the price except for the list price itself:
- Fixed: Is the price used in a country where you are subject to fixed price law?
- Includes tax: Does the price include tax?
If you want to add multiple new prices, click Add another price.
View and edit a spreadsheet
Open the file you downloaded in a spreadsheet programme (e.g. Microsoft Excel, OpenOffice Calc or LibreOffice Calc). If the spreadsheet looks strange, be sure to specify that you're opening a tab-delimited file using UTF-16 encoding.
You can edit the spreadsheet by adding or replacing values according to Google's formatting guidelines below. New books can be added by providing information in new rows.
You can also delete any columns that you won't be working on, and any data in those columns will be unchanged when you upload the spreadsheet. (Exceptions include the Identifier column, which is always required, and the Title column, which is required for new books being added via the spreadsheet.) Some columns only apply to books which can be sold on Google Play.Columns in the spreadsheet (click to expand/collapse)
- Restricted values (such as when a list of acceptable values is provided) must be provided in English.
- Values are case-sensitive.
- If the column name includes additional information inside square brackets, format your data the same way, with the specified details in square brackets.
|Identifier||The primary ISBN or other identifier for the book. Required. Changing the value in this column will make any information in the row apply to a different book (and may create a new book record); the book with the old identifier will not be deleted from your account.|
|Status (Do Not Modify)||Whether the book is available for preview and for sale and whether any actions are needed. This column is for information only. Any changes made in this column will be ignored when you upload the spreadsheet.|
|Label (Do Not Modify)||The label for the book, if any. Note that any changes made in this column will not be reflected in your account when you upload the spreadsheet. There is no way to change labels for an existing book.|
|Enable for Sale?||
Whether the book will be sold on Google Play. (Note that additional information, such as prices, is also required before a book becomes available for sale.)
|Title||The title of the book. Required if this book is being added to your account.|
|Subtitle||The subtitle of the book, if any.|
The format of the book. Acceptable values:
|Related Identifier [Format, Relationship], Semicolon-Separated||
The ISBN or identifier of other books related to this one. For example, if the electronic and print editions of a title have different ISBNs, you can specify the other edition in this column. Include the format of the related book, a comma, then its relationship to the current book, all within square brackets after the identifier. Separate multiple related identifiers with semi-colons. Examples:
|Contributor [Role], Semi-colon-separated||
Contributors to the book, such as the author, editor or illustrator. You must specify the role of each contributor in square brackets after the name. List multiple contributors by separating them with semi-colons. Example:
Acceptable values for the role:
|Biographical Note||Biographical details about the contributors. Basic HTML is acceptable (but no hyperlinks).|
The primary language of the book. Use three-letter ISO 639-2/B codes. For example, enter
|Subject Code [Schema], Semi-colon-Separated||
The subject of the book. This should either be a code specified by one of our accepted subject schemas, or the exact text description as described by the schema. The schema should be specified after each subject in square brackets. Subject codes may be provided for multiple schemas, separated by semi-colons. Example:
|Age Group, Comma-Separated||
The age group of the audience for which this book is intended. List multiple age groups with commas. To specify adult audiences, enter 18+. Example:
|Description||A description of the book, such as might be found on the back cover copy. Basic HTML is acceptable (but no hyperlinks).|
The date of publication for the book in
Some spreadsheet programmes will reformat dates. Please make sure that when you upload your spreadsheet, any information in this column follows the correct format.
|Page Count||The number of pages in the book.|
|Series Name||The name of the series to which the book belongs, if any.|
|Volume in Series||If the book belongs to a series, the volume number of the book.|
|Preview Type||How much of the book can be previewed on Google Books. (This is different from the amount previewed in the Google Play Store.) A minimum of 20% should be set, with acceptable values incrementing by 10% (e.g. 30%, 40%, etc.).|
The countries where this book can be previewed on Google Books as comma-separated two-letter ISO 3166-1 codes. This list should include any countries where this book is enabled for sale.
If you have worldwide rights, enter
To indicate all territories except the U.S. and Canada:
To indicate Germany, Spain, France and Italy:
|Buy Link Text||The text of the link that points to your specified purchase page for this book. Usually this will be your company name or website name, such as "Example Publishing" or "Example Publisher Online."||Buy Link||The URL of the specified purchase page for this book on your ecommerce site. Note that Google Books automatically links to popular book retailer sites; this link is to encourage visitors to your own page for this book. If you provided "Example Publisher Online" as the Buy Link Text above, and a Buy Link of http://www.examplepublishing.com/book/12345.html for this book, then a user clicking "Example Publisher Online" would land on that particular web page.|
|Publisher Name||The name you want displayed as the person, imprint or publisher who submitted this book to Google Books.|
|Publisher Website||The URL of your website, which viewers can reach by clicking on your publisher name.|
|Show Photos in Preview?||
Whether to display photographs or illustrations in the preview of your book. Disable this option if you don't have the appropriate rights. If a book contains a significant number of images, we can sell it only if you indicate that we can show photos, or if we receive an ePub file. Acceptable values:
|PDF Download Allowed?||
Whether to allow Google Books users to download a full copy of your book as a PDF file. Acceptable values:
|On Sale Date||
The date that the book should become available for sale in
Some spreadsheet programmes will reformat dates. Please make sure that when you upload your spreadsheet any information in this column follows the correct format.
Whether to apply Digital Rights Management (DRM) software to the book when it's sold on Google Play. Acceptable values:
|Show Photos in eBook?||
Whether to display photographs or illustrations in the book when it's sold on Google Play. Disable this option if you don't have the appropriate rights. If a book contains a significant number of images, we can sell it only if this option is enabled, or if we receive an ePub file. Acceptable values:
|Include Original Pages?||
Whether to allow people who purchase the book on Google Play to view the PDF version, which includes the original layout. Acceptable values:
|Copy-Paste Percentage||How much of the book a buyer can copy and paste. Enter a number from 0 to 100 in increments of 10, or 5 (e.g. 0, 5, 10, 20, 30, etc.).|
Edit prices in a spreadsheet
If your books can be sold on Google Play, you can change, add or remove prices for your books in bulk using spreadsheets. To make sure that you're only supplying prices for books on Google Play (instead of preview-only books), filter your spreadsheet by checking for a value of
+) in the Enabled for Sale? column before modifying prices.
If you've enabled currency conversion, you can configure which books and prices you'd like to convert in order to sell in other countries. In the spreadsheet you'll see two columns for each price: the first column contains the price as a numeric value and the second column lists the countries where that price will be applied. If any of the listed countries use a different currency from the currency specified for the price, the currency conversion tool will allow you to automatically convert your provided price into the target country's currency. See the section on changing the countries where a price applies for detailed instructions.
Add a price
To add a price that your books don't currently have, you will first need to download that price type in the spreadsheet so that you have the right price header to work with. After selecting Export books, tick the box labelled Add a price and specify the details of the price type you want to add.
Download and open the spreadsheet, fill in the values for that new price and then return to upload the spreadsheet.
Delete a price
Download the prices you want to delete following the instructions for downloading prices and open the spreadsheet. Wherever you see a value for the price, replace that value with two asterisks (
**). The prices that have
** will be deleted when you upload the spreadsheet. Books without prices for a given territory cannot be sold there.
Change a price
To change a price, simply edit the numerical value in the appropriate column for the book.
Change the countries where a price applies
You may want to change the countries where your price applies for various reasons. You might have experienced a change in the rights for the book, or you might want to use an existing price for all worldwide sales once you've enabled currency conversion, as the below example illustrates. To change the countries where a price applies, follow these steps:
Download the price you want to change following the instructions for downloading prices and open the spreadsheet. There'll be two columns for each list price: the price, then the countries where that price applies.
Identifier ... USD [Recommended Retail Price, Excluding Tax] Price Countries for USD [Recommended Retail Price, Excluding Tax] Price 012345678 ... 9.99 US
Explanation of column headers in the example:
- Identifier - the identifier
- USD (Recommended Retail Price, Excluding Tax) Price - the recommended retail price, tax-exclusive, in USD
- Countries for USD (Recommended Retail Price, Excluding Tax) Price - the countries where the recommended retail price, tax-exclusive, in USD should be applied
Edit the list of countries using our formatting guidelines.
Identifier ... USD (Recommended Retail Price, Excluding Tax) Price Countries for USD (Recommended Retail Price, Excluding Tax) Price 012345678 ... 9.99 WORLD
Save the spreadsheet, then return to the Partner Centre to submit it according to our uploading instructions.
Add books using a spreadsheet
You can add additional books to your account by entering their information in blank rows. (If you're not making any edits to existing books, you can delete those rows entirely.) Although we recommend that you provide as much information as possible, the minimum required columns include:
- Identifier (at this time, books without ISBNs cannot be added to your Book Catalogue using a spreadsheet).
When you upload your spreadsheet, these books will be added using the settings for your default template. You'll need to upload the book cover and content files separately. Learn more.
Upload a spreadsheet
Once you've finished making changes to your spreadsheet, save it in one of our accepted formats:
|Accepted formats||Accepted encodings*||Accepted filename extentions|
Return to the Partner Centre. While viewing your Book Catalogue, select Add books > Add/Edit Books with CSV > Upload CSV.
Click the Choose file button and select your edited spreadsheet file from your computer and click Upload.
After the file has been uploaded, your changes may take some time before they're reflected in your account. You won't be directly notified of any errors in your spreadsheet. To determine whether your spreadsheet submission was successful, check your spreadsheet upload history.
View spreadsheet upload history
To check the status of your spreadsheet submission, visit your Book Catalogue and select Add books > Add/Edit Books with CSV > View Upload History. You'll see a list of your past uploads with timestamps and the number of rows processed for each file. If no rows were successfully processed, the status for that file will be Invalid. Otherwise, the status will be Completed. (Errors may still be present in completed uploads.)
To view details on any errors, click the number of rows with errors. You'll be prompted to download a spreadsheet which will contain the specific error messages for your upload. The first column will contain the identifier of the row with the error, and the second column will contain the specific value that caused the error, along with an error message. Use this information to make corrections to your spreadsheet and upload it again.