Download the ratings as CSV or XLS
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 and Professional accounts.
Yesterday, today and tomorrow: from your dashboard
The quickest way to grab a whole day. On your dashboard 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.
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:
- Open WebRatings 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.
- Click ⚙ Tools at the top of the grid.
- Choose Download CSV/XLS, then pick your format.
Then open the file, see Opening the file in Excel or Sheets.
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 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, CAE, 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 open alongside it.
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. New columns are always added at the right-hand end, so anything you have built against the existing columns keeps working.
The CSV is the Raw Races table on its own, trimmed to the columns you have switched on in Select Columns. Switch a column back on and it reappears in your next download.
Was this article helpful?