Help & Support

Read the attached trading-card checklist and create an Excel workbook for Card Collector DB's Complete Release Import. Do not invent information; leave unknown values blank or use UNKNOWN only where the rules below allow it.

Create these worksheets with exactly these headers:

Release
Requirement: exactly one data row; the worksheet name is Release only.
Year | Publisher | Brand | Release | Release Category | Franchise | Sport | Team | Release Date | Release Notes | Source

Checklists
Checklist Type | Checklist Name | Parent Checklist | Parallel Name | Serial Numbered Status | Serial Numbered To | Checklist Notes

Cards
Card Key | Parent Card Key | Card Checklist | Card Number | Name | Team | Serial Numbered Status | Serial Numbered To | Card Notes

People on Cards
Optional Sports Cards worksheet; use one row per identified person on a multi-person card. The worksheet name is People on Cards only.
Card Key | Person Name | Team | Appearance | Display Order

Subjects on Cards
Optional worksheet; include only reusable identities supported by the source. The worksheet name is Subjects on Cards only.
Card Key | Subject Key | Subject Name | Subject Type | Appearance | Display Order | External Source | External Identifier | Subject Notes

Rules:
1. The Release sheet has one row. Release is the product/release name only; do not repeat Year or Publisher in it. Use Release Category for the top-level category, such as Sports Cards or Trading Card Game. Put the game identity in Franchise. Sports Cards may use Sport and Team; Trading Card Game requires Franchise and must leave Sport and Team blank. Never put Pokémon TCG, Magic: The Gathering, or another franchise in the legacy Sport or Category field. Brand is the optional product line when it differs from Publisher. Pokemon is normalized to Pokémon in brand and franchise fields; searches accept either spelling. Use the publisher's official spelling and YYYY-MM-DD for a known Release Date.
2. Checklists must include exactly one BASE row. For BASE and INSERT rows, use Checklist Name and leave Parent Checklist and Parallel Name blank. For PARALLEL rows, leave Checklist Name blank; provide Parent Checklist and Parallel Name. A parallel is related to its parent checklist, not automatically to every parent card.
3. Cards must use the Card Checklist label: the Base/insert checklist name, or Parent Checklist — Parallel Name for a parallel. Generate a unique, stable Card Key for every card, such as BASE-B-1 or COMPASS-C-1. Card Key and Parent Card Key are import references, not public card numbers.
4. Use Parent Card Key only for a PARALLEL card that corresponds to a specific card in its immediate parent checklist. Never infer a parent from row position. Leave it blank if unknown or not applicable.
5. Preserve printed card numbers exactly and store Card Number cells as text, retaining leading zeros, prefixes, punctuation, and slashes without Excel numeric or date conversion. An asterisk used only as a PDF legend marker must not become part of the card number; move that explanation to Checklist Notes.
6. Serial Numbered Status values: Checklists use NO, YES, MIXED, or UNKNOWN. Cards use INHERIT, NO, YES, or UNKNOWN. Provide Serial Numbered To only with YES, as a positive whole number, and only when the denominator is established by the source. YES with a blank limit means confirmed serial numbered with no known denominator; UNKNOWN means the source does not establish whether it is serial numbered. Use INHERIT only when the card should follow its checklist setting. Do not guess a print run or assign an individual copy serial number.
7. Each Cards row needs Name. Use the player or subject exactly as printed. For Sports Cards, Cards Team is optional compatibility information for a single-team or team-focused card. For a multi-person sports card, do not combine teams in one cell: add one People on Cards row per person and enter the team applicable to that person on the card. Non-sports cards must leave Team blank and must not use People on Cards. Use People Appearance: Featured player, Cameo, Coach, or Other; Display Order begins at 1.
8. Put PDF-wide legends and checklist-wide facts in Checklist Notes. Put only individual-card facts in Card Notes.
9. Subjects on Cards never replaces or rewrites the printed Cards Name. Add a row only for a reusable identity established by the source; title-only cards are valid. Subject Type must be Person, Character, Creature or species, Team, Organization, Object, Location, Event, or Other. Appearance must be Featured subject, Cameo, Creator or artist, Team or group, or Other. Use the same optional Subject Key for repeated appearances of one proposed identity. Supply External Source and External Identifier together or leave both blank. Do not assume every Pokémon title is a creature, and do not turn Magic card names into characters or creatures without evidence.
10. Before delivery, check that Card Keys are unique, every Card Checklist matches a defined checklist label, every supplied Parent Card Key refers to a card in the immediate parent checklist, and every person/subject row references an existing Card Key. Account for every source-listed collectible without inventing versions or expanding partial parallels into complete parent checklists. Report unresolved relationships or coverage gaps rather than guessing.
11. Deliver a downloadable Excel (.xlsx) workbook with the exact worksheet names and headers above, not just tables in chat. If file creation is unavailable, say so explicitly and provide clearly labeled fallback tables without claiming they are import-ready. List every uncertain, unreadable, ambiguous, or missing fact separately outside the workbook's catalog fields. Do not put extraction warnings in Card Notes, silently normalize team names, merge people with matching names, or invent reusable subjects.