MTG Collection Spreadsheet Template: What It Needs and When to Skip It

Searching for an MTG collection spreadsheet template usually means one thing: you’ve decided to finally get your collection documented, and Excel or Google Sheets feels like the natural place to do it. Fair enough. A spreadsheet is free, flexible, and yours. Before you build one, though, it’s worth knowing what a good template contains, where spreadsheets quietly fail collectors, and what the alternative looks like in 2026.

The Columns Your Template Actually Needs

Most homemade collection spreadsheets fail because they track too little to be useful or too much to maintain. This set of columns is the workable middle:

• Card name. Obvious, but use the exact printed name; you’ll thank yourself when searching.
• Set code. The three-to-five letter code (like MH3 or LTR). The same card from different sets can differ in price by an order of magnitude, so “which printing” is not optional.
• Collector number. The final disambiguator. Modern sets have multiple versions of the same card in the same set: showcase frames, extended art, borderless. The collector number pins down exactly which one you own.
• Finish. Regular or foil, as separate rows or a dedicated column. Foils are priced in their own market and a template that ignores finish produces a wrong total, full stop.
• Quantity. How many copies of this exact printing and finish.
• Price and currency. One column per market you care about; for most people that’s Cardmarket in euros, TCGplayer in dollars, or both.
• Price date. The most overlooked column and the most important one. A price without a date is a rumor. You need to know how stale your numbers are.

Optional but nice: condition, language, storage location (which box or binder), and a notes column. Resist adding more. Every extra column is future homework.

The Two Ways Spreadsheets Fail

Entry never finishes. Every card is a manual row: look up the set code, find the collector number, check two marketplaces, type five fields. At two minutes per card, a five-hundred card collection is seventeen hours of data entry. Most spreadsheets die at row eighty, and a catalog of 15% of your collection answers no question worth asking.

Prices rot. This is the structural problem no template fixes. The day you type a price, it starts drifting. Reprints, tournament results, and set releases move the market weekly. Six months later your spreadsheet shows a collection value with no relationship to reality, and “just update the prices” means repeating the seventeen hours. A spreadsheet is a photograph of your collection’s value on one day in the past.

If you enjoy spreadsheet-keeping as a hobby in itself, none of this will stop you, and the template above is a solid foundation. But if the spreadsheet was always a means to an end, there’s a shortcut.

The Same Result Without the Data Entry

Everything that template tries to capture is what a collection tracker records automatically. In Foilio, the workflow replacing those seventeen hours looks like this: point your camera at a card, and the scanner identifies the exact printing, set code, collector number, and all. Tap once for regular, once for foil. Quantity, finish, and identity are captured in seconds, and prices arrive on their own, updated daily from Cardmarket and TCGplayer in euros and dollars.

The price-rot problem disappears entirely, because the “spreadsheet” refreshes itself every day. Instead of a stale total you get a current one, with a chart showing how it moved over the past weeks, which is the question you actually wanted the spreadsheet to answer. If you’ve never had a real number for your collection, here’s how to find out what your MTG collection is worth.

And When You Still Want the Spreadsheet, Export One

Here’s the part that makes this a genuinely better path rather than a trade-off: Foilio exports your collection to a real Excel file whenever you want one. The export includes quantities, sets, finishes, and current prices in both euros and dollars, with counts and prices as actual numbers you can sum and sort. You get a perfectly formatted, up-to-date collection spreadsheet in two taps, generated from data that was captured by camera instead of typed by hand.

So the honest recommendation for anyone hunting a template: let the app do the cataloging and pricing, and export the spreadsheet whenever you need one for insurance documentation, a sale listing, or your own records. It’s the same spreadsheet you were about to build, minus the seventeen hours, and the prices are from today.

Foilio is free on the App Store. Scan a stack of cards tonight, tap export, and open the finished spreadsheet before you’d have typed row twenty.