Exporting & Retailer Sheets

Pubblish gives you several ways to take your catalogue data out of the app. You can download your whole catalogue as a spreadsheet, or produce a ready-to-paste field sheet for Amazon KDP. You can also export ONIX for retailers. This guide covers each one and where to find it.

Export your whole catalogue

Use this to get every title and edition out as one Excel file.

  1. Open Tools from the sidebar.
  2. Click the Export card.
  3. On the Export page, click Download catalogue.xlsx.

The file downloads as pubblish_catalogue_<date>.xlsx. Any workspace member can export, including viewers.

The spreadsheet columns match the import template exactly. You can edit the file offline and re-import it to make bulk updates. See Importing your catalogue for the re-import steps.

The export includes:

  • Title and edition metadata — ISBN, ASIN, language, audience, age range, AI disclosure, and keywords
  • Descriptions — one short and one long description per title
  • BISAC subject codes — up to 5 per title
  • Contributors — up to 8 per title, with pen name and role
  • Series memberships — up to 3 per title
  • Copyrights — up to 3 per title, with year and holder

Some fields are not yet in the export file:

  • Thema subjects
  • Extra descriptions
  • Edition languages beyond the original language
  • Identifiers other than ISBN and ASIN
  • Asset files such as covers The Export page lists these under What is not yet included.

On re-import, editions are matched by ISBN. Keep the ISBN column to update existing editions. Remove the ISBN to create new ones.

Export a KDP field sheet for one edition

The KDP sheet lists every field Amazon KDP asks for during title setup. Each field is pre-filled with your data, so you can copy it straight into KDP.

  1. Open the title and go to the Editions tab.
  2. In the edition’s row, click the store icon (its tooltip reads Amazon KDP entry sheet).

The sheet is read-only. It has two sections:

  • Details — the fields that are the same for paperback, hardcover, and Kindle, such as title, contributors, description, categories, and keywords
  • Content — the paperback-specific fields, such as ISBN, trim size, page count, and weight

Each row shows the field name, your value, and a Status. Empty or over-limit fields are flagged so you can fix them before you paste. Every row has a Copy button. The Copy All Fields button at the top copies each value to your clipboard in sequence.

Pricing is not on the sheet. KDP sets prices per marketplace, so you enter those in KDP directly.

Any workspace member can open a KDP sheet, including viewers.

Export ONIX for retailers

ONIX is the industry-standard XML format that retailers and distributors use to receive book metadata. Pubblish can export ONIX 3.0 for a single edition.

ONIX export is a paid add-on. It is not part of any plan by default. The export option only appears once the add-on is active on your workspace. When it is active, a file-code icon (tooltip Export ONIX) appears in the edition’s row on the Editions tab.

On the Export ONIX page:

  • If required data is missing, the page shows Cannot export: required data missing and lists what to fix.
  • If recommended data is missing, the page shows Recommended data missing. You can still export with the Download Anyway button.
  • If everything is present, click Download ONIX to download the XML file.

To ask about the ONIX add-on, see Billing & Subscriptions.

Export your workspace data

Separately, the Settings page has an Export my data button in its title bar. It downloads your whole workspace’s data as a JSON file. This is for data portability, not retailer sheets. Only admins and owners can use it. See Settings & account.