--- title: "Download the ratings as CSV or XLS — RatingTheRaces Support" description: "Export a full race card from RatingTheRaces as a CSV or XLS file so you can study the ratings in Excel or your own spreadsheet. A Premium and Pro feature." url: https://ratingtheraces.com/downloads-data/download-ratings/ date_modified: "2026-10-18" --- [Help Centre](https://ratingtheraces.com/support/) / [Downloads & Data](https://ratingtheraces.com/downloads-data/) /Download the ratings as CSV or XLS # Download the ratings as CSV or XLS How-to premium / professional new Premium and Professional members can pull a full race card out of the browser as a CSV or XLS file and work with the ratings in their own spreadsheet. Sometimes you want the ratings in a spreadsheet rather than on screen, to sort your own way, add columns, or keep a record. RatingTheRaces lets you export a full race card as a **CSV** or **XLS** file. Downloads are included with [Premium](https://ratingtheraces.com/plans-billing/premium-account/) and [Professional](https://ratingtheraces.com/plans-billing/professional-account/) accounts. ## Yesterday, today and tomorrow: from your dashboard The quickest way to grab a whole day. On your [dashboard](https://ratingtheraces.com/getting-started/dashboard-tour/) the **XLS and CSV Downloads** panel has a **Yesterday / Today / Tomorrow** toggle, a line confirming which day you are about to download, and a card for each file with one-click **XLS** and **CSV** buttons. Yesterday's files come with the results and XSP included. [![The XLS and CSV Downloads panel: Yesterday, Today and Tomorrow tabs, the day line, then the Full Ratings and Race Type Version file cards, with the free Staking Manager below](https://ratingtheraces.com/help/download-ratings/3-downloads-panel.webp)](#zoom-help-download-ratings-3-downloads-panel) [![The XLS and CSV Downloads panel: Yesterday, Today and Tomorrow tabs, the day line, then the Full Ratings and Race Type Version file cards, with the free Staking Manager below](https://ratingtheraces.com/help/download-ratings/3-downloads-panel.webp)](#close) ## Any other day: from the Ratings To download a **past day** (or any day while you're browsing the cards), navigate to it on the ratings first, then use the Tools menu: 1. Open [WebRatings](https://ratingtheraces.com/tools-features/customize-ratings-view/) and use the **date picker** (the calendar beside the date at the top of the grid, or the **‹ ›** arrows) to move to the day you want. **Back To Today** jumps you back. 2. Click **⚙ Tools** at the top of the grid. 3. Choose **Download CSV/XLS**, then pick your format. [![On a past day's ratings, the date picker in the toolbar and the Tools menu open showing Download CSV/XLS](https://ratingtheraces.com/help/download-ratings/1-tools-download.webp)](#zoom-help-download-ratings-1-tools-download) [![On a past day's ratings, the date picker in the toolbar and the Tools menu open showing Download CSV/XLS](https://ratingtheraces.com/help/download-ratings/1-tools-download.webp)](#close) Then open the file, see [Opening the file in Excel or Sheets](https://ratingtheraces.com/downloads-data/open-in-excel/). For older dates a quick confirmation appears before the file is built, and a full day's data can take a minute or two to generate. ## How far back can I download? Everyone on a paid plan can always download **today, tomorrow, and every day that passes while you're a member**. How far into the **past** you can reach depends on your plan and your billing term (monthly, 6-monthly or yearly). It's based on how long you've been continuously subscribed and only ever grows, renewing never resets it. ### Professional: the full archive after 3 months Whatever your billing term, once you've been a Professional member for **three months** you can download the **entire archive**. Before that: | Billing term | From day one | Until the archive opens | | --- | --- | --- | | Monthly | one month back | one more month back each month | | 6-monthly | six months back | stays there until the 3-month mark | | Yearly | twelve months back | stays there until the 3-month mark | After three months, every Professional member has the whole archive. ### Premium: a window that keeps growing Premium gives you a rolling window that **grows the longer you're a member**, but never opens the full archive. Longer billing terms start you further back: | Billing term | From day one | How it grows | | --- | --- | --- | | Monthly | no history before your join date at first | one month back once you've been a member a month, then another month back each month after that | | 6-monthly | three months back | six months back at the 3-month mark, then another six months at each renewal | | Yearly | six months back | a full year back at the 6-month mark, then another year at each renewal | The history window is based on continuous membership, so it carries over when you renew, but it resets if your subscription lapses and you re-join later. ## The Race Type Version Below the Full Ratings card on your dashboard there's a second file card, **Race Type Version**. It's the same day's data, but the run-score (R) figures only count a horse's runs of **today's race type**, so on a Flat card you see each horse's Flat R figures and any hurdle or chase runs show a dash. It keeps like with like for a horse that has switched codes. ## CSV or XLS, which should I take? - Take **CSV** if you're going to import the data somewhere, feed it into your own model, or you just want the raw numbers with no fuss. - Take **XLS** if you'd rather open a ready-made, formatted workbook and read it much as it looks on the site. ## What's in the file The export carries every ratings and stats column from the racecard for the runners in that card: the RTR figures, odds and value columns, R10 to R1 and the AV figures, the horse, trainer, jockey and sire records, OR, C AE, Win %, LR O/R, Draw by Distance and the horse's field size, direction and class records. Professional members also get LWOR. The only racecard columns you will not find are your own NAP and NagMe marks, which are personal to you, and the silks. For what each heading means, keep the [ratings columns reference](https://ratingtheraces.com/understanding-the-ratings/ratings-columns-reference/) open alongside it. ### C AE and Win %, side by side In both files **C AE** sits immediately to the left of **Win %**. They are neighbours only because both joined the download at the same time and went on the end together. They measure different things, and Win % is not a percentage of C AE. - **C AE** is the Combined A/E: one figure that blends every A/E on the runner's row. That is the horse, jockey, trainer and sire win and place A/Es, plus the draw and the jockey and trainer, jockey and sire, and trainer and sire pairings, each one weighted by the number of runs behind it. It is a ratio, not a percentage: above 1 means those records have been beating the market, below 1 means they have been over-bet. A runner with no records behind it at all shows 0. How A/E works is in [What does A/E mean?](https://ratingtheraces.com/understanding-the-ratings/ae-statistic/) - **Win %** is the horse's win chance from our Value Odds: 100 ÷ Value Odds. Value Odds of 4.0 is 25, and every runner's Win % in a race adds up to 100. The file carries it as a plain number with no % sign. More in [Value Odds, Value % and Win %](https://ratingtheraces.com/understanding-the-ratings/value-odds/). ### Two columns that are not on the racecard Added on 26 September 2026, both included with Premium and Professional: - **Beaten Fav LTO** reads `True` or `False`: was this horse the beaten favourite last time out? It is the flag only, so the price, course and date of that run stay on the [BF hover](https://ratingtheraces.com/understanding-the-ratings/beaten-favourite/) on the racecard. On a typical day it is true for a small share of the card, 35 of 468 runners when this was written. - **Claim (lbs)** gives the apprentice or conditional allowance as a plain number, 3, 5, 7 or 10, and is blank when the jockey does not claim. The two files put them in different places, which is worth knowing before you build anything on top: - **In the CSV**, each one sits beside the column it belongs to: Beaten Fav LTO straight after Horse nationality, Claim (lbs) straight after Jockey name. Because the claim is tied to the jockey, hiding Jockey name in [Select Columns](https://ratingtheraces.com/tools-features/customize-ratings-view/) hides the claim with it. - **In the XLS Raw Races tab**, the two sit together near the right-hand end, after Weight (lbs) and before the Professional columns (LWOR and the Last Handicap Win block). Since 3 October they are on the **WS, PS and WP** sheets as well, so you get them whichever sheet you work from. ### The four tabs in the XLS - **WS**, **PS** and **WP** are the formatted race cards, laid out much as the site shows them, in the win, place and win-place stat views. - **Raw Races** is one flat table, one row per runner, every column. This is the tab for pivot tables, lookups, macros and your own models. **If you build against these files, read a column by its heading, not by its position.** New columns usually go on the right-hand end, and Weight (lbs) did in September, but that is not a promise we can keep for every column: Beaten Fav LTO and Claim (lbs) went in beside the horse and the jockey in the CSV, which shifts the position of everything to their right, and they land somewhere different again in the XLS. A lookup on the heading copes with all of that. A macro pointed at a column number does not. The CSV is the Raw Races table on its own, trimmed to the columns you have switched on in [Select Columns](https://ratingtheraces.com/tools-features/customize-ratings-view/). Switch a column back on and it reappears in your next download. ## Downloading one race A member asked for this one. If you only want the race in front of you, there is a **Download race** button on the racecard, at the right-hand end of the View bar and on the single-race page. **Professional.** [![The right-hand end of the racecard View bar with the Download race button](https://ratingtheraces.com/help/download-ratings/race-button.webp)](#zoom-help-download-ratings-race-button) [![The right-hand end of the racecard View bar with the Download race button](https://ratingtheraces.com/help/download-ratings/race-button.webp)](#close) It gives you that race's CSV only, and the file is **built at the moment you click it**, so the prices in it are as fresh as the ones on the card rather than whatever the day file held when it was last rebuilt. The Odds Movement columns come with it, so you get the opening price, the latest and the move alongside the ratings. The full day's files are unchanged and still where they always were. ## Trying it on a free account Downloads are a Premium and Professional feature, but you do not have to take our word for what is in them. Any signed-in member, free accounts included, can download **one full sample day** as both XLS and CSV: a real card from earlier in the season, complete, with nothing stripped out. It is in the Downloads panel where the padlock used to be. Open it in your own spreadsheet and you will know exactly what you would be getting before you spend anything. Downloads are a Premium and Professional feature. On a Free account you'll be prompted to upgrade, see [How much does it cost?](https://ratingtheraces.com/plans-billing/pricing/). Was this article helpful? ### Related articles [ ### When do the downloads refresh? Your RatingTheRaces download always reflects the latest published ratings; the files rebuild through the day, so a later export picks up the newest data. ](https://ratingtheraces.com/downloads-data/download-refresh/)[ ### Opening the file in Excel or Sheets How to open your RatingTheRaces CSV or XLS export in Excel, Google Sheets or Numbers, and fix the odd column that imports in the wrong number format. ](https://ratingtheraces.com/downloads-data/open-in-excel/)[ ### My download hasn't updated If your RatingTheRaces XLS or CSV download looks out of date or won't open, these quick checks, a fresh export and a cache clear, sort almost every case. ](https://ratingtheraces.com/downloads-data/download-not-updating/)