Free manga collection spreadsheet template
Updated
A spreadsheet is a good way to start tracking manga: it’s free, flexible, and entirely yours. The usual mistake is giving each series one row, which works until you need to know which volumes are missing. This template uses one row per volume instead.
Download the template (CSV). It opens in Excel, Google Sheets, Numbers, and LibreOffice.
The columns
| Column | What goes in it | Example |
|---|---|---|
| series_title | Series name, spelled the same every time | Vinland Saga |
| volume_number | Whole number | 4 |
| owned | yes or no | yes |
| read | yes or no | no |
| wishlist | yes or no | no |
| price_paid | What you actually paid | 7.50 |
| store | Where you bought it | Local bookshop |
| condition | NEW, LIKE_NEW, VERY_GOOD, GOOD, ACCEPTABLE, or POOR | VERY_GOOD |
| purchase_date | YYYY-MM-DD | 2026-03-14 |
| read_date | YYYY-MM-DD | 2026-04-02 |
| notes | Anything else, such as the edition | 2-in-1 edition |
| isbn | Optional |
Formulas worth adding
Assuming the template’s column order, these work in both Excel and Google Sheets. Put them on a separate sheet, and in Excel refer to the data sheet by name.
- Volumes owned:
=COUNTIF(C:C,"yes") - Volumes read:
=COUNTIF(D:D,"yes") - Total spent:
=SUM(F:F) - Average price per volume:
=AVERAGE(F:F) - Owned in one series:
=COUNTIFS(A:A,"Vinland Saga",C:C,"yes")
Fill it in faster
- Look up the total for each series first. Our volume checklists list the count for popular titles.
- Type volumes 1 and 2, then drag the fill handle to number the rest of the run.
- Paste the same series name down the first column, because a misspelling splits a series in two.
- Freeze the header row and add a filter, so you can narrow down to one series on a phone.
When a spreadsheet stops being enough
Spreadsheets start to strain at a few hundred rows, especially on a phone. Typical signs are checking your list in a shop and giving up, or having formulas break after you sort a column. Charts also have to be built by hand. Our comparison of spreadsheets, Notion, and apps goes through the tradeoffs.
Moving your spreadsheet into ReadLedger
This template uses the same column names as ReadLedger’s importer, so your work carries over if you switch. Export your sheet as CSV, then import it from your account. You’ll see a preview before anything is saved, along with any rows that need fixing. You can also export to CSV or JSON at any time, so you won’t be locked in.