SheetMagicSheetMagic

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.

Try

Results show here on the page, not in your inbox. Your email caps free runs per person. We send one email asking you to confirm it; nothing else comes unless you click it. Privacy policy

Free. Up to 5 results, in up to about a minute.

Your results

Run a search above. The rows land in this sheet.

RowCard NameSetGameMarket PriceMedian PriceLow PriceLow + ShippingListingsRelease DateURLImageRarityCard NumberEnergy TypeFoil OnlySealed Product
1
2
3
4
5

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.

  1. Card Name
  2. Set
  3. Game
  4. Market Price
  5. Median Price
  6. Low Price
  7. Low + Shipping
  8. Listings
  9. Release Date
  10. URL
  11. Image
  12. Rarity
  13. Card Number
  14. Energy Type
  15. Foil Only
  16. Sealed Product

From this page to your sheet

  1. 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. 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. 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)
Type it in any cell once SheetMagic is installed.

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.