MTG Collection Spreadsheet: A Practical Template

A spreadsheet is a flexible way to catalog a Magic collection. You control the fields, can filter the list for a deck or sale, and keep a copy in a familiar format. The tradeoff is maintenance: the sheet only stays useful if every row identifies the right card and changes are recorded consistently.

Start small. A clear table with ten dependable columns is better than a complicated workbook you stop updating.

Use One Row for One Exact Version

Create a separate row whenever the printing, finish, language, or condition changes. Identical copies can share a row and use the quantity field.

Begin with these columns:

Column	What to record
Card name	Full printed name
Set code	Three-letter set code
Collector number	Number exactly as printed
Finish	Regular, foil, etched, or other
Quantity	Number of matching copies
Language	Language of the physical card
Condition	Scale used by your marketplace
Unit price	Price for one matching copy
Location	Box, binder, or deck
Notes	Signed, altered, graded, or uncertain details

The set code and collector number prevent cards with the same name from collapsing into one entry. If a version is difficult to identify, use our guide to finding the exact MTG printing.

Calculate Values Without Hiding Assumptions

Add a Row value column and multiply quantity by unit price. In an Excel table, a formula can look like:

=[@Quantity]*[@[Unit price]]

Then sum that column for the collection estimate. Keep one currency throughout the workbook and record the market, price type, and date in cells above the table. Otherwise, a total can look exact while combining numbers that are not comparable.

Do not convert missing prices to zero. Leave them blank or mark them for research so the total visibly remains incomplete. Record manually valued graded cards separately from ordinary marketplace prices.

Add Fields Only When They Support a Decision

Purchase price can help track spending. A sale-status column helps prepare listings. A wishlist flag helps plan purchases—but wishlist items must not be included in the owned total.

Avoid collecting data merely because a template offers a column. Every required field adds time to new cards. If you never filter by artist, rarity, or mana value, those details can stay in a card database instead of your personal sheet.

Make the Sheet Harder to Break

Turn the range into an Excel table or add filters in Google Sheets. Freeze the header row, restrict finish and condition fields with dropdowns, and keep numbers as numbers rather than typing currency symbols into each cell.

Give every physical storage location a short consistent label. Filters can then answer practical questions such as “Which cards worth checking are in Binder 2?”

Before a large import or formula change, save a dated copy. Sort a duplicate sheet rather than the only copy until you trust the setup.

Keep Prices and Quantities Current

Choose a review rhythm based on your purpose. Update valuable cards and planned sales more often than bulk. When a price changes sharply, verify the exact printing and current listings instead of accepting the result automatically.

Record purchases, trades, and sales as they happen. Stale quantities usually damage the collection total more than an imperfect daily price.

If manual upkeep becomes the slowest part of collecting, move the live catalog to an app and use spreadsheets for analysis or backup. Foilio can scan or import your MTG collection, update available Cardmarket and TCGplayer prices daily, and export it to an Excel file. The spreadsheet remains yours; the repetitive maintenance no longer has to be.