Public Pricing Data

TradeSkillMaster publishes pricing data as plain CSV files at https://public-data.tradeskillmaster.com. The files are static and public with no API key, sign-in, or rate limits. You can pull them straight into Google Sheets, Excel, or any tool that can read a URL.

File URLs

https://public-data.tradeskillmaster.com/{gameType}/{regionSlug}/realm/{realmSlug}/items.csv
https://public-data.tradeskillmaster.com/{gameType}/{regionSlug}/realm/{realmSlug}/pets.csv
https://public-data.tradeskillmaster.com/{gameType}/{regionSlug}/commodities.csv
https://public-data.tradeskillmaster.com/{gameType}/{regionSlug}/region/items.csv
https://public-data.tradeskillmaster.com/{gameType}/{regionSlug}/region/pets.csv
Segment
Values

The slugs are the same ones in your realm's page URL on this website. The quickest way to find yours is to open your realm here and copy the values out of the address bar.

For example, non-commodity item prices for Area 52 (US Retail):

https://public-data.tradeskillmaster.com/retail/us/realm/area-52/items.csv

Files

File
Scope
Contents
Updated

Pet files are only published for game versions that have a battle pet market (Retail and Mists of Pandaria). Commodity files are only published for Retail regions.

Columns

Realm files and commodities.csv:

Column
Description

Region files:

Column
Description
  • All prices are in copper (1 gold = 10,000 copper).
  • Pet files list the base species only (one row per species, no pet-level breakdown).
  • updatedAt is the same value for every row in a file and reflects the upstream scan time, not when the file was generated.

Using the data in Google Sheets

IMPORTDATA reads a CSV straight from a URL:

=IMPORTDATA("https://public-data.tradeskillmaster.com/retail/us/realm/area-52/items.csv")

To look up a single item's market value (column 3), combine IMPORTDATA with VLOOKUP. For example, for item 210796:

=VLOOKUP(210796, IMPORTDATA("https://public-data.tradeskillmaster.com/retail/us/realm/area-52/items.csv"), 3, FALSE)

Google Sheets automatically refreshes IMPORTDATA cells roughly once per hour. Because the files only change every few hours (realm and commodity data) or daily (region data), pulling more often than that returns the same values.