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

ColumnWhat goes in itExample
series_titleSeries name, spelled the same every timeVinland Saga
volume_numberWhole number4
ownedyes or noyes
readyes or nono
wishlistyes or nono
price_paidWhat you actually paid7.50
storeWhere you bought itLocal bookshop
conditionNEW, LIKE_NEW, VERY_GOOD, GOOD, ACCEPTABLE, or POORVERY_GOOD
purchase_dateYYYY-MM-DD2026-03-14
read_dateYYYY-MM-DD2026-04-02
notesAnything else, such as the edition2-in-1 edition
isbnOptional

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.

Keep reading