Import Data
Upload a CSV or Excel file exported from your ILS
Not sure how? Ask your system administrator. They can usually generate one for you.
- Your file should have one row per item.
- Include as many columns as possible. The tool matches them automatically.
- At minimum: Title, Call Number, and Publication Year.
- For circulation reports, add a Checkouts column.
- Wrong format? Save as .csv, .xlsx, or .xls. Other formats are not supported.
- File too large? Try splitting into smaller files or removing unnecessary columns.
- Weird characters? Save your CSV as UTF-8 encoding. Most spreadsheet apps have this option.
- Reports look empty? Check the Column Mapping page to see which fields were detected.
Templates
Not sure if your file will work? Download a template to see the expected format, or compare it against the example file.
Upload File
What Happens After Upload?
Column matching
The tool scans your column headers and matches them to standard fields (Title, Author, Call Number, etc.). It understands dozens of common variations, so you don't need to rename anything.
Data cleanup
Publication years, checkout counts, and dates are automatically cleaned up and converted to the right format. For example, "c2019" or "2019." both become 2019.
Subject classification
Call numbers are read to determine the subject area of each item. This works with both Library of Congress (LC) and Dewey Decimal call numbers.
Supported Column Names
Your file does not need all of these. The tool works with whatever data you have and skips fields that are missing.
| Data Field | Recognized Column Names |
|---|---|
| Title | Title, BTitle, Item Title, Bib Title |
| Author | Author, Primary Author, Main Author, Bib Author |
| ISBN | ISBN, ISBN13, ISBN-13 |
| Call Number | Call Number, Call #, Call No, Local Call Number |
| Publication Year | Pub Year, Publication Year, Year, Date, Pub Date |
| Subject | Subject, Subjects, Primary Subject, Subject Heading |
| Format | Format, Material Type, Mat Type, Item Type, IType |
| Location | Location, Branch, Library |
| Barcode | Barcode, Item Barcode |
| Checkouts | Checkouts, Total Checkouts, Total Circs, YTD Circ, Circs |
| Last Checkout | Last Checkout, Last Checkout Date, Last Circ Date |
| Date Added | Created Date, Date Added, Cataloged Date, Cat Date |
| Status | Status, Item Status |
| Price | Price, Cost, Replacement Cost, List Price |
| Collection | Collection, Collection Code, CCode |
| Copies | Copies, Copy Count, Number of Copies |