UK Lottery Number Checking Spreadsheets


If you play the UK Lottery on a regular basis (with the same numbers each time) or if you have a subscription, you might find the following spreadsheet useful:
(12.1 KB)

For 10 lines:
(11.5 KB)

For 100 lines:
(13 KB)

(9 KB)

EuroMillions - 100 lines:
(9.39 KB)

The first two spreadsheets will work with Lotto and Thunderball games.  You must enable macros in order for these to work.

How to Use

Firstly you need to enter the numbers you play with on the left-hand side.  You can add up to 4 lines for each game (unless you are using the 10 or 100 line version of the spreadsheet), the below examples use 2:


Your Lotto Numbers


Your Thunderball Numbers

Every time a draw is held, you will need to enter the winning numbers on the right-hand list i.e.:


Lotto Results

The green column is for the Bonus ball.  If you want to, you can enter the Jackpot and whether their was a rollover for that week i.e. 0 for no rollover, 1 for rollover, 2 for double-rollover, etc.


Thunderball Results

The pink column is for the Thunderball.

The number of matches will automatically appear in the A, B, C and D columns, which correspond with the numbers you have in the 'My Numbers' section.  If you have won, the cell will become green, as shown above.

Checking the Results

You can check the Lotto and Thunderball results at The National Lottery website:

Archived Comments

From: john <jrhuskisson>
Date: Sunday, July 10, 2011 at 08:00:52
Comments: why do you not say how much is paid to the lottery
what happens to all the money put on this week if the prize money does not go up.
Who gets all the interest on the money not claimed
From: John
Date: Wednesday, May 18, 2011 at 01:24:25
Comments: an excellent spreadsheet! New to macros, how would i alter your macro to highlight having two main numbers in open office?
From: Dave
Date: Tuesday, March 1, 2011 at 00:43:45
Comments: Hi, Have downloaded your Euro Million 100 Spreadsheet, but how do you know if you have won or not? Put in my numbers then put in the same numbers in the winning numbers but nothing happens, what should happen to know that you have won?



Reply: You must enable macros for these spreadsheets to work.  As the above screenshots show, winning draws should be automatically highlighted in green.
From: Chiller
Date: Monday, June 7, 2010 at 12:09:06
Comments: Do you know a fast way of inputting the previous draw numbers? I am wanting to use your spreadsheet to pick out a set of numbers which have never had a big win / only a few £10 wins.

I have a file with EVERY single draw to date listed.


Reply: Ideally if you can open your file in Excel, copy and paste (as values) the results into one of the Lotto spreadsheets (above).  You will then need a way of activating the macro for each line to show the results.  This can be done by pressing F2 on one of the winning number cells (or bonus ball) for each line or a quicker way would be to create a macro to do this for you.
From: Ram
Date: Friday, January 22, 2010 at 02:20:55
Comments: Hi,
I do see that there are 6 columns, but my lotto has
only 5 numbers with a max of 39.
Please let me know if i can use it.
Reply: Sorry, but I designed these spreadsheets for the UK lottery only.
From: roy roberts
Date: Saturday, November 14, 2009 at 18:09:12

Load of crap ... these sheets are only for recording the winning numbers and prizes , and do not show if you have won or not .... Do just the same on a piece of paper.... ROY

Reply: The winning numbers show up as highlighted in green.  Maybe there is a bug in one of the spreadsheets.  Which one did you try?  Also have you enabled macros?
From: Bill
Date: Tuesday, October 6, 2009 at 04:25:56

Very useful tool. However, I have to re-enter the winning numbers, everytime I change my played numbers

Reply: If you enter new numbers under 'My Numbers', the results for previous draws will not change.  Future results will be against the numbers currently in 'My Numbers'.
From: Shirley
Date: Sunday, October 4, 2009 at 13:13:44
Comments: Brilliant, I have been using a lottery programme which I bought in 1994 it is no longer working as I run a syndicate of 25.  Have put your spreadsheet into mine which keeps a note of payments and winnings, also so much easier now everything is in one place.  Thanks very much.
From: Janet
Date: Sunday, September 13, 2009 at 13:57:03
Comments: Hi Martin,

I have found the 100 line lottery spreadsheet to be very it possible to have a 100 line version for the Euromillions as well?



Reply: I have added a 100 line version of the EuroMillions spreadsheet above.
From: stephen smith
Date: Friday, May 29, 2009 at 12:38:24
Comments: is it possible to ammend the sheet for many lines.. i have a syndicate that varies from 25 to 35
Reply: I have added a 100 line version of the spreadsheet above.
From: Alex
Date: Wednesday, January 7, 2009 at 14:28:34
Comments: Hi there,

I've downloaded your lottery spreadsheet and it is very helpful indeed, I have been trying to do something like this without sucess for some weeks now. I'd like to know if you have done one for the euro lottery? If not is there any chance you could email me the vba code for the macro to accomodate the euro lottery and 10 play lines.

Thanks in advance


Reply: I have added a EuroMillions version of the spreadsheet above.
From: lee barwise
Date: Friday, July 18, 2008 at 21:50:38
Comments: Martin

Your lottery checking spreadsheet is a very useful tool, the only problem is that can it be expanded so that more lines can be used instead of just 4? I have 9 lines and would like to continue using it but i am unable to add more lines?



Reply: I have added a 10 line version of the spreadsheet above.

Martin Allen 1999 - 2017.  Last updated Sunday 14 May 2017 22:06 +0100.