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's important to get this sheet right before working on the others.
Column Notes
Title
Enter titles exactly as it appears on the book, including the leading article (A, An, The), for example "A Tidy Armageddon", not "Tidy Armageddon, A". PubGizmo will parse this as needed for indexing and metadata.
All title entries must be unique and appear only once on this sheet – no duplicates.
MATCH WARNING: The title as entered here is the value that 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.
Subtitle
Enter the subtitle here if the title has one. Do not include the subtitle in the Title column.
Author Name
Enter the primary author's name. MATCH WARNING: The author name as entered here must be matched exactly on the Contracts sheet.
Genre
You can enter multiple genres in a single cell; separate them 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.
Keywords
Enter multiple keywords in a single cell, separated by a semicolon (not a comma). You can learn more about how keywords help you group and find titles on the Keywords wiki page.
BISAC Code Primary, BISAC2, BISAC3
Enter BISAC subject codes if you have them, one code per column, in priority order. Most titles will have one or two; a maximum of three is supported. Leave unused columns blank. BISAC codes are available from the Book Industry Study Group (BISG).
BISAC Regional Themes
Enter the BISAC Regional Theme code if applicable. Regional Themes are a separate BISAC vocabulary used to indicate geographic focus (e.g., a book specifically about or set in a particular region). Separate multiple entries with a semicolon.
BISAC Merchandizing Themes
Enter the BISAC Merchandizing Theme code(s) 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.
Thema
Thema is an international subject classification scheme used in ONIX metadata. Enter one or more Thema codes if your press uses them. Separate multiple entries with a semicolon (e.g., FLQ;1KBZTP;3MRBF).