TCGplayer Prices in Google Sheets, No TCGplayer API Needed
Search a card and see its TCGplayer market, median and lowest price with set, rarity and listing count. Install SheetMagic to get the results as rows in Google Sheets.
Your results
Run a search above. The rows land in this sheet.
| Row | Card Name | Set | Game | Market Price | Median Price | Low Price | Low + Shipping | Listings | Release Date | URL | Image | Rarity | Card Number | Energy Type | Foil Only | Sealed Product |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||||||||
| 2 | ||||||||||||||||
| 3 | ||||||||||||||||
| 4 | ||||||||||||||||
| 5 | ||||||||||||||||
| 6 | ||||||||||||||||
| 7 | ||||||||||||||||
| 8 |
Install SheetMagic to get every result in Google Sheets
The same scraper runs from a formula in your sheet and writes every row there. The free plan includes 100 one-time scraping credits.
Free TCGplayer price scraper for Google Sheets, in short
To get TCGplayer prices into Google Sheets without the TCGplayer API, search a card on this page to preview its market, median and lowest price. Then install the free SheetMagic add-on and type =TCGPRICE("Charizard ex 199/165", "pokemon", 1) in a cell. Each matching card is written as a row in a new tab.
16 columns for every result
Each result is one row, with these columns in this order. Fields the source does not show stay blank.
- Card Name
- Set
- Game
- Market Price
- Median Price
- Low Price
- Low + Shipping
- Listings
- Release Date
- URL
- Image
- Rarity
- Card Number
- Energy Type
- Foil Only
- Sealed Product
From this page to your sheet
1. Look up a card here
Type a card name, ideally with its set and card number, pick the game, and run the search. You see up to 5 matching cards on this page.
2. Install SheetMagic for free
Add SheetMagic from the Google Workspace Marketplace and click Activate. No card is needed, and the free plan includes 100 one-time scraping credits.
3. Get the prices in Google Sheets
Type =TCGPRICE("Charizard ex 199/165", "pokemon", 1) in a cell. The matching cards land as rows in their own tab, with prices, set, rarity and a link to each product.
Who uses it, and for what
Pricing a collection you plan to sell
List the cards you want to sell, look up each one's market and low price, and set your asking prices in the same sheet you use to track inventory.
Store owners checking buylist prices
Before you make an offer on a binder, pull the current market price and listing count for the key cards so your buy price is based on today's numbers.
Tracking prices on cards you hold
Re-run the formula on the cards you care about and keep each result tab, so you can compare market prices over time without checking TCGplayer by hand.
The same thing, inside Google Sheets
TCGPRICE takes a search term, an optional game such as "pokemon", "magic" or "yugioh", and an optional maximum number of results. It runs in the background and writes the cards to a new tab with the same columns you see on this page. Each card returned uses 61 scraping credits. It's just a formula, so you never leave the sheet.
=TCGPRICE("Charizard ex 199/165 Pokemon 151", "pokemon", 1)Other ways to do it
- Copying prices by hand from TCGplayer
- Fine for a few cards. For a binder or a full set it means searching each card, retyping prices, and redoing it all when prices move.
- IMPORTXML
- Free, but TCGplayer loads its search results with JavaScript, so IMPORTXML usually returns empty cells or errors instead of prices.
- The TCGplayer API
- The official route for developers. It needs developer access and code of your own, and you still have to build the step that writes prices into Sheets.
- A standalone card price tracker
- Good for browsing one card at a time. Getting the numbers into your own spreadsheet still means exporting or copying them yourself.
Questions
- Is this TCGplayer price scraper free?
- Yes. Searching a card on this page is free and shows up to 5 results. To get results in Google Sheets you install the free SheetMagic add-on, whose free plan includes 100 one-time scraping credits. Each card returned in Sheets uses 61 credits, so larger lookups need more credits from a paid plan.
- Do I need a TCGplayer API key?
- No. You do not need a TCGplayer account, an API key or any code. You type the card you want, and SheetMagic returns the prices shown on TCGplayer's public search results.
- Is it allowed to scrape TCGplayer prices?
- This tool reads prices that TCGplayer shows publicly to anyone who searches, without logging in. It does not access accounts or private seller data. How you reuse the data is up to you, so check TCGplayer's terms before republishing it.
- What data do I get for each card?
- One row per card with its name, set, game, market price, median price, lowest price, lowest price with shipping, listing count, release date, product link, image, rarity, card number, energy type, and whether it is foil only or a sealed product.
- Which games does it cover?
- Pokemon in English and Japanese, Magic: The Gathering, Yu-Gi-Oh!, Disney Lorcana, One Piece, Flesh and Blood, Dragon Ball Super, Cardfight!! Vanguard and Weiss Schwarz. You can also search all games at once.
- How do I get TCGplayer prices into Google Sheets?
- Install SheetMagic from the Google Workspace Marketplace and click Activate. Then type =TCGPRICE("Black Lotus Alpha", "magic", 1) in a cell. The matching cards are written as rows in their own tab, and the formula cell shows how many results it found.
- Does it show graded card prices?
- No. TCGplayer does not track graded card prices such as PSA or BGS, so neither does this tool. For graded cards, eBay sold listings are the usual reference, and SheetMagic has a separate eBay scraper for those.
Free plan
100scraping credits, one time
Run the full TCGplayer price scraper in Google Sheets.
Install SheetMagic from the Google Workspace Marketplace. No card, no separate account, and no deadline on the free allowance.
