Skip to main content
Help › Importing

Importing from a Spreadsheet or CSV

If you track your cookbooks in a spreadsheet — Excel, Google Sheets, Numbers, or anything that can export CSV — you can import that file directly into Cookbooker.

Prepare your file

Your file needs to be saved as a .csv file with column headers in the first row. The most important column is ISBN — without it, Cookbooker can't match books to its catalogue.

Download a blank template to see the expected format and fill it in.

Supported columns

Column name Required? Notes
ISBN or ISBN13Required10 or 13 digit ISBN. Used to match against the catalogue.
ASINOptionalAmazon product ID. Used if no ISBN is present.
TitleOptionalShown in the preview; used when creating a new catalogue entry.
AuthorOptionalShown in the preview; used when creating a new catalogue entry.
RatingOptionalWhole number 1–5. Imported to your shelf rating.
Review or NotesOptionalWritten review text. Published with your consent.
Column names are case-sensitive. Use the exact names from the table above or the template file.

Import your file

  1. Go to Bookshelf → Import your collection.
  2. Select Spreadsheet or other source.
  3. Upload your CSV file.
  4. Review the matched results and click Import.
Books without an ISBN will appear in the "Couldn't identify" section and won't be imported. Make sure every row you want to import has a valid ISBN.
← From Eat Your Books Account settings →