Moving Your Card Inventory Off Spreadsheets

A spreadsheet feels like control right up until you're standing at your table, phone in one hand, a buyer asking whether you have a card in stock, and no way to find out without scrolling a thousand rows. Here's how to move off the spreadsheet without losing anything you've built.

Almost every card dealer starts on a spreadsheet. It's free, it's familiar, and for the first few hundred cards it mostly works. The trouble shows up at the table, under pressure, when the spreadsheet that was fine at your desk becomes the slowest thing between you and a sale. You can't search it fast, you can't trust it to be current, and one wrong tap on a phone keyboard turns a price into a typo.

Moving to a phone-based inventory isn't about abandoning the discipline you already have. It's about keeping the parts that work (knowing your cost, tracking what sold) and dropping the parts that fight you at a show. This guide covers where spreadsheets actually break, what to set up first so the switch pays off immediately, and how to bring your existing data across without leaving a single card behind.

Where the spreadsheet actually breaks

Spreadsheets don't fail all at once. They fail in the specific moments that cost you money.

• Search at the table. A buyer names a card. On a phone, scrolling and pinch-zooming a wide sheet to find one row is painfully slow, and the line notices. Inventory you can't find fast is inventory you can't sell fast.
• Staying current. The sheet is only right if you update it every single sale, by hand, mid-rush. Miss a few and by teardown your counts are fiction. A stale inventory is worse than none, because you trust it and it's wrong.
• Values. A spreadsheet doesn't know what a card is worth today. You either leave prices blank or paste in numbers that go stale the moment you save the file.
• One device, one file. The master sheet lives on a laptop at home, or in a cloud file that needs signal to open. Neither is what you want in your hand at a packed convention hall.

None of these mean you were doing it wrong. They mean the tool was built for a desk, and you work a table.

What to set up first

When you switch, resist the urge to perfect everything on day one. A few fields, done consistently, beat a flawless system you abandon by the second show. Start here:

1. Get your stock searchable. The single biggest win is being able to find any card in seconds. Scan your inventory in or import it (more on that below), so a buyer's question becomes a one-tap lookup instead of a scroll.
2. Record cost as cards come in. What you paid is the one number you can never reconstruct later. Capture it the moment a card enters stock and your margin math is done for you at sale time. If you're not already, see how to track cost basis on your card inventory.
3. Attach a market value. Let the tool carry a current value by set and condition so you're not hand-pricing every card off memory.
4. Log sales in the moment. Ring each sale against the actual card as it happens. That's what keeps your counts honest and feeds an accurate profit number without a teardown-night reconciliation.

Get those four habits running and the rest (shows, expenses, deeper reports) slots in naturally once the base is solid.

Bring your data across, nothing lost

The fear that keeps dealers on spreadsheets is losing the work already in them. That's a solved problem: a clean CSV import brings your existing rows straight in, so years of records move over in one step instead of being re-keyed card by card. In CardOps, CSV import and export (both directions) is part of Pro, so you can bring a spreadsheet in and, just as important, take everything back out whenever you want.

That two-way door matters more than it sounds. Data you can't export is data you don't really own. Before you commit to any inventory tool, confirm you can get your records out as easily as you put them in. No lock-in means the switch is low-risk: if it isn't for you, your data walks out with you.

For cards that aren't in a spreadsheet yet (loose stock, a box you never logged), scanning is faster than typing. Point the camera and the card is recognized on-device against a 20,000+ Pokémon catalog, with a market value attached, no manual entry.

What you gain the first weekend

The payoff isn't abstract. The first show after the switch, the differences are immediate: you answer "do you have it?" in seconds instead of stalling, your prices reflect real market values instead of stale guesses, and your sales log itself as you go so you actually know what the show made before you've packed up.

And because a phone inventory runs on the device, it doesn't fall over when the hall wifi does. CardOps' Show Mode keeps search, sales, and pricing working offline and syncs once you're back on signal, which is the one thing a cloud spreadsheet can never promise in a basement convention center.

Start small, stay consistent, and keep your data portable. That's the whole migration.