Book Tracker - ISBN Scanner

Example CSV file (download)

This is an example file only. It is not your personal library. It shows the correct header row and sample book rows so you can see how a valid import looks before you build your own file.

Download example CSV

The button above starts a direct download of the example CSV file (the file is stored on Google servers). Save it where you can find it, then import it from Files on your iPhone or iPad if you want a practice import. On some browsers you may see a short Google confirmation step before the file saves. Do not mistake this sample for a backup of your real books.

Before you start

• Try the example first (optional): You can download the example only CSV here: download example CSV. It is for practice and layout reference, not your real data.
• File format: Use UTF-8 CSV, comma-separated. Exports from the app are built this way; imports should match.
• Header row: Row 1 must list column names (see below). Remove blank rows between the header row and your first data row.
• File size / rows: Large files may be slow. Start with a small test file if you are unsure.
• Device: These steps assume iOS (iPhone or iPad). Grant file access when the system asks (for example when picking from Files).
• Import and export share the same column rules: See Column headers and data format below.

Export your library

Export creates a CSV you can save to iCloud Drive, On My iPhone, or another location you choose.

1. Open Book Tracker and go to the screen that lists export options (for example Settings → Export or Library → Export — see the note above).
2. Tap Export (or the button your build uses, such as Export library).
3. If the app asks what to include, choose full library, selected books, or a date range. Pick what you need.
4. When the share sheet appears, pick Save to Files (or another destination). Give the file a name you will recognise.

What the file contains: The app writes one header line, then one row per book. Headers and column order follow Constants.expectedColumns exactly (see below). ISBN values are wrapped in quotes on export so spreadsheets keep them as text.

Import a file

1. Open the import flow (for example Settings → Import or Library → Import).
2. Tap Choose file / Import and pick your UTF-8 CSV from Files. For a first test, download the example-only CSV here, save it, then choose that file in Files.
3. If the app shows a preview or validation step, read any warnings. Fix the file and try again if needed.
4. Confirm the import when you are satisfied. Wait until the app finishes; do not force-quit during the process.

Import vs column order: You do not need to reorder columns to match the export table, as long as the header names in row 1 are correct (the importer matches by header, not position). Whitespace around header names is trimmed.

If the app offers a dry run or preview import, use it first on a copy of your file.

Column headers and data format

CSV is a plain-text spreadsheet: one row per book, values separated by commas. Use UTF-8 encoding and commas as the delimiter (same as export).

Canonical column order (export / recommended import)

Exports are built from Constants.expectedColumns in this exact order. The header line is these names joined with commas; each data row uses the same column order.

BookID,Author,Title,Genre,ISBN,Status,Notes

Empty template (copy this single line for a new file):

BookID,Author,Title,Genre,ISBN,Status,Notes

Alternatively, download the same example-only CSV (with headers and sample rows): download example CSV.

Import: header names and Book ID

• BookID is required on import. The importer also accepts Book ID (space between words) for the same column.
• Other columns are matched by name: Author, Title, Genre, ISBN, Status, Notes.
• Author and Title are both required for a row to import; formatting is normalised on import (for example title capitalisation).
• A blank BookID on a row may be assigned a new ID by the importer. Export always writes the stored ID.
• Genre maps to the app's location/label field (free text).
• ISBN is free text; quote ISBNs in CSV when needed so tools do not drop leading zeros.
• Notes is free text. If a note contains commas, quotes, or newlines, use CSV quoting/escaping (RFC 4180 style).
• Extra columns: Additional columns beyond this schema are ignored on import workflows that follow it.

Status values (import and export)

Import parsing accepts the following (export uses the same labels; read dates export as Read (YYYY)):

• Read — optionally with a year in parentheses, for example Read (2024).
• Currently Reading
• TBR
• DNF
• Unread — Wishlist is treated as Unread on import.
• Blank or unrecognised status → cleared (no status).

Field reference

Example: header plus one data row

Use UTF-8 CSV, comma-separated. This matches export order and valid status text. You can also download the ready-made example file (sample data only): download example CSV.

BookID,Author,Title,Genre,ISBN,Status,Notes
1,"Morrison, Toni",Beloved,Fiction,"9781400033416",Read (2024),Won Pulitzer; classroom copy

Example: minimal row (empty optional fields)

BookID,Author,Title,Genre,ISBN,Status,Notes
2,"Rowling, J. K.",Harry Potter And The Philosophers Stone,Young Adult,"",Currently Reading,

Re-importing an export

Re-importing a file you exported from the app is supported when headers stay valid. Extra columns are ignored. If you edit a file, keep header names exact and follow status and quoting rules above.

Common errors and fixes

• Wrong or missing headers — Compare row 1 to the example CSV (sample file): download example CSV, or to the header line BookID,Author,Title,Genre,ISBN,Status,Notes below.
• Row not importing — Each data row needs both Author and Title filled.
• Status not recognised — Use exactly Read, Read (YYYY), Currently Reading, TBR, DNF, or Unread. Anything else is cleared. Wishlist imports as Unread.
• Extra spaces in header names — Leading/trailing spaces on headers are trimmed; fix odd spacing inside names.
• ISBN or Notes broken in Excel — Keep ISBN quoted as in export; quote Notes if they contain commas, quotes, or line breaks.
• Duplicate Book IDs — Resolve duplicate IDs across rows if the importer rejects or merges unexpectedly.
• Wrong file type — Use real UTF-8 CSV, not a renamed Excel file.

Privacy and safety

Exported files may contain titles, notes, or other details you consider personal. Store them in a secure location (password-protected drive, device passcode). Avoid emailing sensitive exports without encryption if that could expose your data.

For how Book Tracker handles data in the app and online services, see Privacy Policy.

Need more help?

Use the contact form at the bottom of this page, or email info@6ixdesign.com.au. If you maintain separate in-app help or documentation, add that link here when available.