Track your competition wins on a prize spreadsheet
It’s a new year and we’re all raring to get winning! Get ready to welcome all those shiny new prizes into your home by creating a spreadsheet to record all the details. Unlike a notebook, a spreadsheet enables you to tally up totals easily – you can also search it, filter it and create pie charts to see how well you do with different types of comps.
For 2026, I’ve enlisted the help of Chris Buso to improve my prize spreadsheet, so it now has a second tab with lots of helpful statistics!
Save a copy of the spreadsheet to your own Google Drive by clicking here.
Here’s a screenshot of my 2025 prize spreadsheet to show how it works:
At the top you can see the total number of prizes and value – this updates with a running total when a new prize is added. If I’m not sure on a prize value I try to estimate it – if I’ve not had a prize delivered yet I’ll leave the value box blank until I know exactly what I receive.
Over the years I’ve added new columns to my basic spreadsheet. I track whether I’ve responded to the winning notification, and also have a column to track if I’ve featured the prize in my monthly unboxing video on YouTube. Where possible I try to thank the promoter too, so I make a note of how I do it (usually an Instagram story).
On the second tab is a brand new statistics section – this whole tab is automatically updated according to the prize data you add on the first tab!
A spreadsheet is useful to:
- calculate the value of the prizes you win over a certain period of time
- give you a boost during a dry spell – you’ll be surprised how many small prizes you win, and making sure you list all those little wins will help you feel more positive and enthusiastic
- see which type of competitions you’re most successful with, and should be focusing on
- remind yourself to say THANKS to the promoter, which is really appreciated
- see how you’re doing if you set yourself regular comping goals – eg. to win a prize a week, or to win ten Instagram competitions in 2026!
Check out my Comping Year posts to see how I use the information from my spreadsheet to do my annual comping success report.
How to set up your prize spreadsheet
- Click this link to Make a copy of the spreadsheet to save to your own Google Drive
- Tap in the title box to change the name of the document
- Type in the boxes to enter details of each prize you win, or select an option from the drop down menu
It’s as easy as that! Each time you add a prize, the totals at the top and on the second tab will update with the statistics!
Spreadsheet tips
- Hover over the letters at the top of the columns and a small down arrow appears – tap this and you can Sort Sheet A>Z. Using this tool you can sort your prizes into value order, or type of competition – reset it to date order by sorting the Prize Number column.
- Delete or insert columns by clicking on the arrow at the top of a column
- If you tap Return in a cell, the cursor moves to the cell below – use Option-Return to start a new line in the same cell
- Change the width of columns by hovering between the letters until a blue bar appears, then drag the bar across
- Use different colours for text or background by highlighting a row, column or cell and clicking the A or the paint bucket in the top menu.
- Create a pie chart or graph by clicking at the top of a column, then going to the … option at the end of the menu bar and tapping the bar chart icon.
- To search your spreadsheet, go to Edit > Find and replace and type your search term in – keep clicking Find to show all results
- Save your spreadsheet to your bookmarks bar for easy access, or add as an icon to your phone home screen to access it quickly
Expanding your prize spreadsheet
I’ve expanded my Prize Spreadsheet into a Comping Spreadsheet, by adding extra tabs (do this by tapping the plus sign at the bottom of the sheet), so I have:
- Prizes – prize spreadsheet
- Effort – list of creative/effort comps I want to enter
- Entered – effort, purchase or low entry comps I’ve entered
You could also add a Purchase comps tab, to keep track of your barcodes, batchcodes, and unique codes (I used to have a Purchase tab on my spreadsheet, but now use the compers shopping list and a daily list in Google’s Tasks app to track my purchase entries instead!). Or add a tab to track your Text comp entries!
Compers always ask me if it’s worth keeping a spreadsheet of all the competitions they enter. I consider this to be a waste of time and means you’re focusing on the amount of comps you didn’t win, which can be rather deflating! Rather than recording everything, I just save details of the effort-based, purchase, creative or low entry comps that I enter, along with notes and my written entries if appropriate.
After entering these effort based comps I move them over to my Entered spreadsheet tab. On the Entered spreadsheet I also save links to any particular comps I’ve entered where I believe I have a good chance of winning – maybe a local comp or a comp with very few entrants. Then I can go back and check they announced a winner after the closing date. I highlight a row green if I won, and red if I saw the winner announced and it wasn’t me! White rows mean I’ve not heard of a winner, so when I have a spare moment I will contact the promoter to check a winner was chosen.
I hope you do decide to create a spreadsheet for 2026 – and let me know when you’ve added your first prize to it! Wishing you lots of luck for the year ahead.
Enjoyed this post? Find more tips on being an organised comper in my blog post and video guide Ten great ways to organise your comping.
Hi Di, Thanks for this insperation. With Google Sheets this is very helpfull, I already using Ggoogle sheets since 2 years for tracking my wins and the daily comps. For the daily comps this is very helfull if I have all links on one place and can open 6-10 at one time to enter in a row. I used this methode also in Dec for all the calender comps – collect all links & promoter and created columns with the date for each day 1-24 (or 31). So I was able to open always 10- 12 at onces and deleted the date from the day I entered . After the day was done I hid the column from the day . With you example I expand now my sheets with the statistic tab and a few other tabs for special comps . Thank you and have a great start 2026.
Hi Di, is there a way of printing just the template off please? My mum wants to start documenting her wins but doesn’t really want to sit at her laptop filling this in, she would prefer to fill it in on paper if that’s okay. Thank you in advance.
I haven’t done a printable version of this yet! In the meantime would your mum like to jot down her wins in a copy of my BootComp 2025 planner instead? I have a few spare copies here and will happily send one out to her if you email the delivery address to di@superlucky.me!
Help computers and I are not always friends. I don’t get alot of stuff like how to start a spread sheet would you please do a teaching video on it!!! My brain and I don’t grasp alot of information.
I have it set up to count each month, so I can see what I have won. Then I add it up at the end of the year to get a total.
Im optimistic, as not won anything yet (only been comping again for a couple of weeks) but I just set up this spreadsheet, thanks Di xx
Thanks, Di! I just got back into comping after a few years and thanks to my spreadsheet from 2021, I noticed that I realized that I had an unused $50 Barnes & Noble Gift card. I must have taken some time to decide what to buy and just forgot about it. Fortunately, I was able to redeem it for a few books.
Whew! Well spotted!
Won a bottle of Rose wine at local pub on New Years Day
Gotta love a win on the 1st Jan – well done!
Thanks I have now set up a spreadsheet. I had no idea about google docs and google drive so your instructions were really clear and helpful. Not sure what you meant about changing it to be a comping spreadsheet, and as im not very tech savvy never heard of asana – do you have a page about how this is used for comping, I’ve started doing purchase necessary in the past 12 months so maybe i need to get organised lol. Thanks for your guidance im working my way through Bootcomp!
I’ll cover Asana and spreadsheets in a video in the BootComp group soon!
Thanks Si, am going to use this spreadsheet see if I can create a widget. My wins have been around the same as 2021, so I need to look at a growth strategy for 2023…. Right now I have no idea lol. If your doing a workshop in the midlands Birmingham, Notts, Leicester that would be brilliant. Best wishes for 2023
Thanks for sharing Di. I’ve had my trusty “Competition Wins” spreadsheet from when I first started comping in 2012. I had a break in 2016 and just returned at the end of August last year.
I’ve decided to adopt your style of spreadsheet, Google Docs is a great idea and I’ve added in all my previous years to my new spreadsheet so thank you and good luck to us all for 2022
Brilliant! Good luck for 2022 Sarah – I’ve just added the first win of 2022 to mine. Just a £5 Love2Shop voucher with Cadbury, but it’s a start!!
Thank you for these fab tips , i am becoming more tech savy . wishing everyone good luck in 2022
Thanks for sharing this. I have finally plucked up the courage to get one set up.
Hi Di,
Fantastic organisation. I have multiple spreadsheets, rather than having it all on one but I think I prefer your way so I’m going to have a fiddle round and change them. Can I ask what the colour coding is for in the purchase one?
Yellow = must enter this one!
Green = have entered already but would like to enter again as multiple entries allowed!
Thanks for the spreadsheet! I note you put your Lidl Cineworld vouchers expiring end of March, mine says end of Feb? I would like longer too 🙂
Oops, I misread the date! Yes, mine are end of Feb too. Very soon!
Yes, very soon! Hope the Unlimited card/code comes soon. Then both my husband with the vouchers, and I can go together until end of Feb. He was not lucky enough to win Unlimited. I saw 94 free films last year! One year I saw 132, including 26 premieres and 7 Gala Screenings! Those were the days, not many premiere comps these days 🙂 Only managed 7 premieres/galas last year.
Thanks Maggie – hope you’re well! x
Good luck to you too Jo!
Amazing!!! Great start to the New Year!!! I’m still waiting for lift off!
Hope you have some goodies to add to your spreadsheet soon!
Good luck Lisa!