Import your book list from a spreadsheet
Years of records may already sit in a spreadsheet. Bring them in once, then scan only what is new.
Try TitleEntryTitleEntry imports a book list from a CSV or Excel file. You match the columns and see exactly what the import will do, and only then is anything saved. From then on the imported books sit in one catalogue with everything you scan.
Last updated: 27 October 2026
What the import understands
Spreadsheets are kept in many ways, so the import is forgiving about the shape of the file:
- CSV or Excel .xlsx files, up to 50,000 rows each
- Column names in English, Turkish, Spanish or French
- Commas, semicolons or tabs between columns
- ISBN-10s, converted to 13 digits, hyphens or not
- Shelves and genres named in the file, created as it imports
- Prices with a decimal point or comma, dates like 2026-10-21 or 21.10.2026
Working from an older .xls file? Open it in Excel, save it as .xlsx or .csv, and it imports like any other.
Importing a book list in four steps
Upload the file
On All Books, choose Import and pick the file. It goes to private storage that only your account can reach, and it is deleted once the import finishes or you cancel.
Match the columns
Each column is matched to a book detail by its name, with an example value from your file beside it. Change any match, or leave a column as Not imported.
Read the check
A dry run counts the new books, the copies that will join books you already have, rows repeated in the file and rows it will skip. Values it could not read are listed with their row numbers. Nothing is written at this point.
Import
Rows go in five thousand at a time, with progress you can watch. If the connection drops, press Try again: rows already saved are not saved twice.
Tips for a clean import
Keep ISBNs as text
Excel likes to show a 13-digit number as 9.78E+12, and once saved that way the digits are gone. Format the ISBN column as text before you save the file. The import spots the damaged ones and keeps those books without an ISBN.
Start from the template
No spreadsheet yet? The import offers a template with your account’s own columns, already named so they match, and a second sheet explaining what goes in each one.
A list of ISBNs is enough
A file with nothing but ISBNs still imports. Each book’s details are looked up afterwards while All Books is open. A long list takes a while, so most people import titles too.
Your values come first
Where the file gives a title, an author or a year, that is what is saved. TitleEntry fills only the empty fields from book records it already holds, so a local spelling or an old edition’s details stay as you wrote them.
Then keep it current
An import is the starting point, not a yearly chore. New stock goes in with the ISBN scanner or a shelf photo, and the imported books are searched, filtered and moved like any other.
With the list in, count the shelves against it in an AI stocktake, or compare it with an approved list using check books against a list. More on running a catalogue for a library or a bookstore.
Frequently asked questions
Open All Books, choose Import and select a CSV or Excel file. Match the columns, read the check of what will happen, then import.
Yes, if that program can export a CSV or Excel file. The columns are matched by name and you can change any match before importing.
That depends on your duplicate setting. With one row per book, an ISBN you already have adds its copies to that book’s count. With one row per copy, every row becomes its own entry.
No. Apart from adding copies to a book’s count, the import leaves the books already in your catalogue as they are. For the books it adds, your values are kept and only empty fields are filled in.
Each file can hold up to 50,000 rows and 50MB. A bigger catalogue goes in as several files, one after another.
Tell us about your list through the contact form. We set up the account, and the import is ready to use straight away.
Already have a list?
Send us a sample of your spreadsheet and we will show you how it imports.
Get in touch