To add or edit multiple books at a time, you can use spreadsheets. You can download a spreadsheet that's pre-filled with the information you've already entered in the Partner Center, adjust the settings and bibliographic information, then upload your edited spreadsheet to apply the changes.
Download a spreadsheet
- Visit the “Book Catalog” in your Partner Center account .
- Click Advanced options.
- Download book list.
- Check the box labeled “Show metadata columns” to include bibliographic information and basic settings for your books.
Tip:By default, your spreadsheet contains information for all the books in your catalog. If you want to generate a spreadsheet of a subset of your books, you should first filter your catalog . The downloaded spreadsheet only includes the search results.
Download prices
If your books can be sold on Google Play, you can download prices along with the rest of your book data. To do so, check the box labeled Show price columns.
You can also add prices. For example, you may wish to provide list prices in a new currency. Click the box labeled Add new prices to these booksand specify the price type for the new price.
The price type is information about the price except for the list price:
- Currency
- Price type
- Fixed:Check this box for countries or regions where you have specified that you are subject to fixed price laws.
- Includes tax:Check this box if this price includes applicable tax.
To add multiple new prices, click Add another price to these books.
View and edit a spreadsheet
Open the file you downloaded in a spreadsheet program (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 Identifiercolumn, which is always required, and the Titlecolumn, 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)- Some columns accept only a set of specific values. Check below to see the list of acceptable values for each column.
- If the column name includes additional information inside square brackets, format your data the same way, with the specified details in square brackets.
- Column headers and acceptable values may change. (For example, our system used to require headers and some values to be in English. They should now be provided in the local language.) We recommend using a newly downloaded version of your spreadsheet to ensure compatibility.
Acceptable values:
- Enabled for sale:
Yes,Y, or+ - Not enabled for sale:
No,N, or-
-
Digital(Ebooks) -
Hardback(Hardcover format) -
Paperback -
Audiobook(Available if your account is enabled to sell audiobooks. At this time, only select partners can sell audiobooks on Play)
-
If the ISBN in the first column is for the electronic edition, then you can provide the print ISBN equivalent as follows. This allows readers to search for the book on Google Play using either ISBN.
9781234567890 [Paperback, Epublication based on] -
If the ISBN in the first column is for a print edition, then you can provide the EISBN equivalent as follows. This helps Google display a link for buying your book on Google Play from the preview page on Google Books when appropriate.
9781234567891 [Digital, Electronic version available as] -
If the ISBN in the first column is related to multiple other ISBNs, use a semicolon between the bracketed items.
9781234567890 [Digital, Electronic version available as]; 9781234567891 [Paperback, Is other-language version of]
-
Digital(digital format) -
Hardback(hardcover format) -
Paperback(paperback format)
-
Is part of(the book is also available as part of the related book) -
Includes(the book includes the related book) -
Alternative format(the book is available in an alternative format as the related book) -
Is other-language version of(the book is a version of the related book in another language) -
Epublication based on(the book is an epublication based on the printed related book) -
Electronic version available as(the book is a printed product with an electronic version as the related book) -
Replaces(the book replaces, or is a new edition of, the related book) -
Replaced by(the book is replaced by, or is an old edition of, the related book)
John Smith [Author]; Mary Jones [Editor]
Acceptable values for the role:
-
Author -
Editor -
Created by -
Photographer -
Photo text -
Translator -
Compiler -
Illustrator -
Other -
Potential writer -
Additional writer -
Ghost writer -
Foreword writer -
Introduction writer -
Preface writer -
Afterword writer -
Notes writer -
Prologue writer -
Commentary writer -
Original writer -
Series editor -
Volume editor -
Chief editor -
Consultant editor -
Adaptor editor -
Printer -
Publisher -
Prior owner
eng
for English. Gardening / Flowers / General [BISAC]; Gardening: flowers [BIC]
Alternatively:
GAR004000 [BISAC]; WMPC [BIC]
Acceptable schemas:
13-17, 18+
13-17
" as "13 minus 17"). To prevent this, you can include a comma at the end (" 13-17,
"). D:
YYYY-MM-DD
format, with YYYY-MM-DD
representing the date. (The D:
prefix is optional.) If you have worldwide rights, enter
WORLD
. You can exclude countries by listing them after WORLD
, separated by commas and individually preceded by a minus sign (-). Examples:To indicate all territories except the U.S. and Canada:
WORLD,-CA,-US
To indicate Germany, Spain, France, and Italy:
DE,ES,FR,IT
- Show photos:
Yes,Y, or+ - Don't show photos:
No,N, or-
- Allow downloading:
Yes,Y, or+ - Don't allow downloading:
No,N, or-
D:
YYYY-MM-DD
format, with YYYY-MM-DD
representing the date. (The D:
prefix is optional.) If this is a future date and your book is enabled for sale, it will not be available for sale before this date. - Enable DRM:
Yes,Y, or+ - Don't enable DRM:
No,N, or-
- Show photos:
Yes,Y, or+ - Don't show photos:
No,N, or-
- Include scanned pages:
Yes,Y, or+ - Don't include scanned pages:
No,N, or-
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 Yes
(or Y
or +
) in the Enable for Sale?column before modifying prices.
Decimal marks for prices should follow convention for the language that the spreadsheet headers are in. For example, if the header is in German, our system will expect comma decimal marks (e.g., 3,00
), while we'll expect period decimal marks for spreadsheets with English headers (e.g., 3.00
).
Currency conversion
If currency conversion is enabled, 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 uses 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, first you need to download that price type in the spreadsheet so that you have the right price header to work with. After selecting Export books, check the box labeled Add a priceand 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 U.S. dollars.
- Countries for USD [Recommended Retail Price, Excluding Tax] Price:The countries where the aforementioned price should be applied. For countries where the specified currency is not the local currency, currency conversion must be enabled for the price to apply there.
-
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 the Partner Center 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 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 Catalog using a spreadsheet; add these books directly in the Partner Center interface )
- Title
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:
* Our system will attempt to process other encodings, but using one of the listed encodings is strongly recommended.Accepted formatsAccepted encodings*Accepted filename extensions- comma-separated
- tab-separated
- UTF-16
- UTF-8
- .csv
- .txt
-
To return to the Partner Center account , from the Book Catalog, click Advanced options.
-
Upload book list.
-
Click Choose fileand select your edited spreadsheet file from your computer.
-
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 uploaded lists
Important:Some features in this section are only available in the Partner Center’s new version. To switch to the new version, at the top right, click Settings
To check the status of your spreadsheet submission:
- Visit the Book Catalog in your Partner Center account .
- Click Advanced options.
- Select View uploaded lists. You'll find a list of your past uploads with timestamps, the user who uploaded the file, and the number of rows processed for each file.
- To download the uploaded file, click the file name.
Upload status types:
- Processing:A recent upload is still in process. Depending on the number of the books and changes made, this can take up to a few hours. If the upload is in processing status for more than 2 hours, make sure the file is in UTF-16 format, and try breaking the file up into multiple files containing a smaller number of books and re-upload. If the file is still in processing status after 12 hours, contact us .
- Complete:The upload of the file is complete and all the rows in the file were successfully processed.
- Complete with errors:The upload of the file is complete but at least one row wasn't successfully processed. Download the error details by clicking the error count in Rows with errors column.
- Canceled:The upload was canceled by a user of your Partner Center account.
- Invalid: No rows were successfully processed.
You can filter your past uploads by status from the "Status" column header. You can also search for any file name from the search bar at the top.
To view details on any errors, click the error counts in the “Rows with errors” column. You'll be prompted to download a spreadsheet containing the specific error messages for your upload. The first column contains the identifier of the row with the error, and the second column contains the specific value that caused the error, along with an error message. For help with a specific error, search for words in the error message page in the Error messages article . Use this information to make corrections to your spreadsheet and upload it again.
