TICKERMINT

To get Pokemon card prices in Google Sheets, paste =IMPORTDATA("https://api.tickermint.cards/sheets/price?q=charizard%20ex%20199/165&key=YOUR_KEY") into a cell: it returns the card's latest TCGplayer market price (for example, 322.37 for Charizard ex 199/165). A key comes with a plan: start the Developer plan ($19 a month, 50,000 lookups a month, Google Sheets and CSV included) with a 7-day free trial, card required, at tickermint.cards/developers. Prices update once a day. Google runs every sheet from a few shared addresses, so sheets without a key share 25 lookups a day between them: use a key.

Pricing stock for a shop or anything you sell? That is commercial use: API Pro, $49 a month, same 7-day trial.

FOR DEVELOPERS · COPY AND PASTE · 25 LOOKUPS A DAY WITHOUT A KEY · EVERY PLAN STARTS WITH 7 DAYS FREE

Pokemon card prices in Google Sheets

IMPORTXML or IMPORTHTML stopped working on a price page? Why it happens and the one-formula fix

GET YOUR KEY

Start a plan at tickermint.cards/developers (7 days free, card required; Developer is $19 a month from day 8 until you cancel). Your key arrives by email. Put it in the formulas below where they say YOUR_KEY. Google runs every sheet from a few shared addresses, so sheets without a key share 25 lookups a day between them: use a key. A single price cell works without a key while that shared allowance lasts; lists, ranges and CSV rows need the key. A Developer key gives 50,000 lookups a month. Anyone who can open the sheet can see the key.

ONE CARD, ONE ROW

Replace 517045 with your card's id: the number at the end of its TickerMint page (tickermint.cards/card/517045), or product_id from search. The first row is the header.

=IMPORTDATA("https://api.tickermint.cards/products/517045.csv?key=YOUR_KEY")

BY NAME, JUST THE PRICE

Type the card the way you would search for it, with the collector number to be sure: the cell gets the latest market price, the same number the card page shows. The second formula reads the name from cell A2, so you can fill it down a list. Add &field=low, name, url, id or date for another value, and &game=one-piece (or lorcana, riftbound, gundam, yugioh, fusion-world) to stay in one game. A name it cannot match says so in the cell.

=IMPORTDATA("https://api.tickermint.cards/sheets/price?q=charizard%20ex%20199/165&key=YOUR_KEY")
=IMPORTDATA("https://api.tickermint.cards/sheets/price?key=YOUR_KEY&q="&ENCODEURL(A2))

A LIST OF NAMES AT ONCE

One import prices up to 50 cards from a column of names or ids: one row per card with your query, the matched name, market price, date and card page. Put it in the header cell next to your list. Each card counts as one lookup.

=IMPORTDATA("https://api.tickermint.cards/sheets/prices?key=YOUR_KEY&q="&TEXTJOIN("&q=", TRUE, ARRAYFORMULA(ENCODEURL(A2:A51))))

BY ID, JUST THE PRICE

INDEX picks row 2, column 7 (market_price_usd). The second formula reads the id from cell A2, so you can fill it down a column of ids.

=INDEX(IMPORTDATA("https://api.tickermint.cards/products/517045.csv?key=YOUR_KEY"), 2, 7)
=INDEX(IMPORTDATA("https://api.tickermint.cards/products/"&A2&".csv?key=YOUR_KEY"), 2, 7)

A WHOLE SET AT ONCE

One import lists every card and sealed product in a set (the set id is the number in its page URL, tickermint.cards/set/23237); each card in it counts as one lookup. Pricing a long list? Import the set on its own tab and look your cards up with XLOOKUP: one request instead of hundreds.

=IMPORTDATA("https://api.tickermint.cards/sets/23237.csv?key=YOUR_KEY")
=XLOOKUP(A2, Prices!B:B, Prices!G:G, "not in set")

A =TICKERMINT() FUNCTION

Extensions, Apps Script, paste this over the empty file, put your key between the quotes on the KEY line, and save. Then type =TICKERMINT("charizard ex 199/165") or =TICKERMINT(517045) in any cell, =TICKERMINT(A2, "low") for another value, or =TICKERMINT(A2:A200) to price a whole column (a range answers market, name, date or url). A name takes the top search result, so add the collector number to be sure. The matching runs on TickerMint, so the script never needs updating. Answers are cached for 6 hours.

/**
 * TickerMint price of a card, by name or TickerMint id.
 * =TICKERMINT("charizard ex 199/165")     latest market price in US dollars
 * =TICKERMINT(517045)                     by TickerMint id
 * =TICKERMINT(A2, "low")                  market, low, name, url, id or date
 * =TICKERMINT(A2, "market", "one-piece")  stay in one game
 * =TICKERMINT(A2:A200)                    a whole column, 50 cards per request
 *
 * Paste your key from tickermint.cards/developers#keys into KEY below
 * (a key comes with a plan; every plan starts with 7 days free):
 * without one, every sheet shares Google's 25 lookups a day.
 *
 * @param {string|number} card what you would type in search, a TickerMint id, or a range
 * @param {string} field optional: market (default), low, name, url, id or date
 * @param {string} game optional: pokemon, one-piece, lorcana, riftbound, gundam, yugioh or fusion-world
 * @return the value for the cell
 * @customfunction
 */
const KEY = ""; // your key, e.g. "tm_live_..."

function TICKERMINT(card, field, game) {
  const API = "https://api.tickermint.cards";
  const f = String(field || "market").toLowerCase();
  const g = (game ? "&game=" + encodeURIComponent(game) : "") + (KEY ? "&key=" + encodeURIComponent(KEY) : "");
  const value = (v) => (/^\d+(\.\d+)?$/.test(v) ? Number(v) : v);

  if (Array.isArray(card)) {
    // a range: one request per 50 cards, answers in the same order
    const cells = card.map((row) => String(row[0]).trim());
    const asked = cells.filter((c) => c);
    const col = ["query", "name", "market", "date", "url"].indexOf(f);
    const rows = [];
    for (let i = 0; i < asked.length; i += 50) {
      const q = asked.slice(i, i + 50).map((c) => "q=" + encodeURIComponent(c)).join("&");
      const csv = UrlFetchApp.fetch(`${API}/sheets/prices?${q}${g}`).getContentText();
      rows.push(...Utilities.parseCsv(csv).slice(1));
    }
    let n = 0;
    return cells.map((c) => [c ? value(rows[n++][col < 0 ? 2 : col]) : ""]);
  }

  const text = String(card).trim();
  if (!text) return "";
  const cache = CacheService.getScriptCache();
  const key = ("tm:" + f + ":" + (game || "") + ":" + text.toLowerCase()).slice(0, 240);
  let v = cache.get(key);
  if (v === null) {
    const q = encodeURIComponent(text);
    const body = UrlFetchApp.fetch(`${API}/sheets/price?q=${q}&field=${f}${g}`).getContentText();
    v = (Utilities.parseCsv(body)[0] || [""])[0];
    cache.put(key, v, 21600); // 6 hours: prices change once a day
  }
  return value(v);
}

25 lookups a day without a key, to try the API in personal and non-commercial projects with a link back. A key comes with a plan, and every plan starts with a 7-day free trial (card required). Inside a commercial app, site or tool, use API Pro ($49 a month). Never mirror or resell the data. Plans →

EXAMPLE OUTPUT

=IMPORTDATA(".../sheets/price?q=charizard%20ex%20199/165"), example
322.37
=IMPORTDATA(".../products/517045.csv"), example
date,product_id,name,set,number,printing,market_price_usd,url
YYYY-MM-DD,517045,Charizard ex - 199/165,SV: Scarlet & Violet 151,199/165,Holofoil,322.37,https://tickermint.cards/card/517045
=IMPORTDATA(".../sets/23237.csv"), first rows
date,product_id,name,set,number,printing,market_price_usd,url
YYYY-MM-DD,502552,Bulbasaur - 001/165,SV: Scarlet & Violet 151,001/165,Reverse Holofoil,0.32,https://tickermint.cards/card/502552
YYYY-MM-DD,502553,Ivysaur - 002/165,SV: Scarlet & Violet 151,002/165,Reverse Holofoil,0.53,https://tickermint.cards/card/502553
YYYY-MM-DD,502554,Venusaur ex - 003/165,SV: Scarlet & Violet 151,003/165,Holofoil,1.07,https://tickermint.cards/card/502554
... one row for every card and sealed product in the set

CSV COLUMNS · /products/{id}.csv AND /sets/{id}.csv

  • date: the day of the price (prices update once a day)
  • product_id: TickerMint's id, the number in the card page URL
  • name: card or product name as TCGplayer lists it
  • set: set name
  • number: collector number, empty for sealed product
  • printing: the printing the price is for (Holofoil, Reverse Holofoil, Normal...)
  • market_price_usd: TCGplayer market price in US dollars, the same number the card page shows
  • url: the TickerMint card page (the link back our terms ask for)

Prices are TCGplayer market prices for the card's main printing, the same number its TickerMint page shows. Full endpoint list and OpenAPI on /developers.

Next step: start a plan with 7 days free. Developer plan: $0 today, then $19 a month from day 8 until you cancel. Cancel online anytime. We email you before the first charge. A key gives you CSV and Google Sheets, 600 requests a minute and the bulk endpoints.
START 7 DAYS FREE →
WITHOUT A KEY
25 lookups a day to try the API, personal use, link back.
PLANS
a key comes with a plan; every plan starts with a 7-day free trial, card required.
COMMERCIAL USE
API Pro and above.
NEVER
mirror or resell our data.
GRADED PRICES
a separate add-on with its own source credit.

The details: API terms.

QUESTIONS

How do I get Pokemon card prices into Google Sheets?

+

Use =IMPORTDATA("https://api.tickermint.cards/sheets/price?q=charizard%20ex%20199/165&key=YOUR_KEY") to get one card's market price by name in a single cell, =IMPORTDATA("https://api.tickermint.cards/products/{id}.csv?key=YOUR_KEY") with the number from the card's TickerMint page URL for a full row, or /sets/{id}.csv for a whole set. Each row has the date, card name, set, collector number, printing and the TCGplayer market price in US dollars. A key comes with a plan: start the Developer plan ($19 a month, 50,000 lookups a month, Google Sheets and CSV included) with a 7-day free trial, card required, at tickermint.cards/developers. Google runs every sheet from a few shared addresses, so sheets without a key share 25 lookups a day between them: use a key. It works the same for Pokemon, One Piece, Lorcana, Riftbound, Gundam, Yu-Gi-Oh and Dragon Ball Super Fusion World cards.

How often do the prices update?

+

TickerMint records the TCGplayer market price once a day, with history back to February 2024. Each CSV answer is cached for up to an hour, and Google Sheets re-fetches imported data on its own schedule, so a sheet shows the latest daily price without any refresh button.

Is it free?

+

A sheet needs a key, and a key comes with a plan that starts with a 7-day free trial. Without a key you get 25 lookups a day to try it, for personal projects with a link back to the TickerMint page the price came from. A key comes with a plan, and every plan starts with a 7-day free trial (card required): Developer ($19 a month) for personal and non-commercial use, API Pro ($49 a month) for showing the prices inside a commercial app, site or tool. Never mirror or resell the data. Each card in a list or set counts as one lookup. The url column in every row is the link back.

Why does a cell show an error instead of a price?

+

A cell that shows a tickermint.cards link instead of a price ran out of the shared keyless lookups: Google runs every sheet from a few shared addresses, so sheets without a key share 25 lookups a day between them. Add &key=YOUR_KEY to the URL (or set KEY in the script) and the sheet uses your own plan's lookups; a Developer key gives 50,000 a month. Very large sheets can also hit the per-minute limit, and the cell fills in on the next refresh. Import a whole set once instead of one formula per card. Anyone who can open the sheet can see the key.

Same data, other tools: Excel · Python · JavaScript · API, MCP server and embeds · Download all history (CSV)