Onboarding Import: Titles

Part of the Onboarding Import series.

The Titles sheet is the foundation of your import. Every edition, contract, and sales record in PubGizmo is tied to a title, so it is important to get this sheet right before working on the others.

Columns

Column A — Title

Enter the title of the work in its natural reading order (e.g., A Tidy Armageddon). PubGizmo parses leading articles (A, An, The) automatically for sorting purposes, so you do not need to move the article to the end. All title entries must be unique.

Match Warning — The title as entered here must be matched exactly on the Editions and Contracts sheets. When entering a title on those sheets, use only the title — do not include the subtitle.

Column B — Subtitle

Enter the subtitle here if the title has one. Do not include the subtitle in the Title column.

Column C — Imprint

Enter the imprint under which this title was published, if your press uses imprints. If your press publishes all titles under the same imprint or press name, you may leave this blank or enter your press name consistently throughout.

Column D — Genre

Enter the genre or genres for this title. Separate multiple genres with a semicolon (not a comma).

Important: PubGizmo will add any genre(s) you enter to your master genre value list. Be consistent — if you call it "Science Fiction" for one title, do not call it "SciFi" for another, or you will end up with both in your selector list. "Nonfiction" (or "Non-fiction" or "Non fiction") is the most common consistency trap — pick one form and use it throughout.

Column E — Keywords

Enter keywords for this title, separated by a semicolon (not a comma). You can learn more about how keywords help you group and find titles by theme and content on the Keywords wiki page.

Column F — Description

Enter the title's description, blurb, or back-cover copy. Embedded formatting from pasted text will be lost, but you can employ basic HTML tags (e.g., <i>, <b>) if needed for italics or emphasis within the text.

Column G — BISAC Code Primary

Enter the primary BISAC subject code for this title, if you have one. BISAC codes are available from the Book Industry Study Group (BISG). Example: FIC028070.

Column H — BISAC2

Enter a second BISAC subject code if the title warrants additional classification. Leave blank if one code is sufficient.

Column I — BISAC3

Enter a third BISAC subject code if applicable. A maximum of three BISAC codes are supported across Columns G, H, and I. Leave blank if not needed.

Column J — BISAC Regional Themes

Enter a BISAC Regional Theme code if applicable. Regional Themes are a separate BISAC vocabulary indicating geographic focus — for example, a book specifically about or set in a particular region. Separate multiple entries with a semicolon. Example: 4.0.2.1.0.0.0.

Column K — BISAC Merchandizing Themes

Enter one or more BISAC Merchandizing Theme codes if applicable. These are used by retailers to place titles into promotional or display categories beyond the primary subject classification. Separate multiple entries with a semicolon. Example: ET034.

Column L — Thema

Thema is an international subject classification scheme used in ONIX metadata. Enter one or more Thema codes if your press uses them, separated by a semicolon. Example: FLQ;1KBZTP;3MRBF.