
- The core is Excel: one table with every bet and three columns that calculate themselves.
- The pivot table tells you in seconds which market and which odds range are giving you results.
- The bankroll chart shows the trend, but with few bets it proves nothing.
There are eight steps and the spreadsheet is built only once. Bookmark this article: your ticks stay in this browser and you continue whenever you can.
Your progress is saved in this browser.
Why does betting with Copilot start in Excel?
Copilot is Microsoft's assistant.
It lives in Windows, in the browser and, depending on your plan, inside the Microsoft 365 programs.
Its natural fit with betting is Excel.
Excel has two tools that a chat does not.
The pivot table, which summarizes hundreds of rows in seconds.
And charts, which show the evolution of your bankroll at a glance.
The problem is that many people do not know how to build them.
That is where Copilot comes in: you describe what you want to see and it tells you which formula or which clicks you need.
If you are still choosing a tool, see the comparison of AIs for betting.
The general method, with no brand, is in how to bet with AI.
Features change: check in the app what your plan includes.
Copilot does not know the result of any match and can give you a wrong formula.
Betting involves the risk of losing money, for adults 18 and over only.
Which columns and formulas the Excel spreadsheet has
The table has nine columns, from A to I.
You enter six by hand: date, match, market, odds, stake and result.
The other three calculate themselves.
| What it calculates | Cell | Formula in English Excel |
|---|---|---|
| Odds range | E2 | =IF(D2<1.7,"Low",IF(D2<2.5,"Medium","High")) |
| Profit of the row | H2 | =IF(G2="W",F2*(D2-1),IF(G2="L",-F2,0)) |
| Running bankroll | I2 | =$L$1+SUM($H$2:H2) |
| Total yield | L2 | =SUM(H:H)/SUMIF(G:G,"<>",F:F) |
| Profit of one market | L3 | =SUMIF(C:C,"Corners",H:H) |
Column D is the decimal odds, F the stake and G the result: W, L or V if it was void.
In cell L1 you enter your starting bankroll.
The cutoffs of 1.7 and 2.5 for the odds range are an example: use your own.
The formulas are written for English Excel, with commas.
In Spanish Excel, IF is SI, SUMIF is SUMAR.SI, SUM is SUMA, and the arguments are separated with a semicolon.
There the decimals are written with a comma: 1,7 instead of 1.7.
Test the row with a case you can calculate by hand.
Example: a stake of 2 at odds of 1.85 and result W must give a profit of 1.70.
With a starting bankroll of 100, column I shows 101.70.
Would you rather start from a ready-made template?
The guide to betting control in Excel has the complete structure.
If you do not know what bankroll to put in L1, use the bankroll calculator.
How to bet with Copilot in 8 steps
Steps 1 to 5 are the setup.
Steps 6 to 8 are the routine.
Tick them as you go.

What you tell Copilot before you start
Copilot does not see your file if you use it from the chat.
That is why the first message describes the spreadsheet precisely.
You are going to help me with a betting spreadsheet in Excel. My Excel is in [ENGLISH / SPANISH] and uses [COMMA / SEMICOLON] as the argument separator. My version is [DESKTOP EXCEL / EXCEL FOR THE WEB]. The table is called Bets and has these columns: A Date, B Match, C Market, D Decimal odds, E Odds range, F Stake, G Result (W, L or V), H Profit, I Running bankroll. My starting bankroll is in cell L1. When I ask for a formula, give me the formula in my Excel language, the cell where it goes and a test case with example numbers. If a function does not exist in every version of Excel, tell me and cite the Microsoft help page. If you are not sure it will work in my version, write “I don’t know”. Do not recommend bets to me.
How to ask for the formulas you are missing
The table above covers the basics.
You ask for what comes next in plain language.
With the Bets table you already know, I need: 1) the yield of a single market: profit of [MARKET] divided by the stake wagered on [MARKET], not counting rows with no result, 2) the longest streak of consecutive lost bets, 3) the maximum drawdown of the bankroll from its highest point, 4) conditional formatting that colors the row when the stake in column F exceeds [MAXIMUM STAKE]% of the bankroll in L1. For each one: formula in my Excel language, cell, and a test case I can calculate by hand. If any needs a function my version may not have, say so and give me an alternative. If you do not know how to solve one with formulas, answer “I don’t know”.
Do not paste anything without the test case.
A formula that “seems to work” and adds up wrong is worse than no formula.
How to build the pivot table by market
This is the part that sets Excel apart.
The pivot table crosses your bets without writing a single formula.
- Rows: the Market field.
- Columns: the Odds range field, if you want to cross the two.
- Values: count of Match, sum of Stake and sum of Profit.
- Calculated field: Yield = Profit / Stake, formatted as a percentage.
- Filter or slicer: the date, to look at a specific month.
Guide me click by click to create a pivot table in my version of Excel from the Bets table. I want: Market in rows, Odds range in columns, and in values the number of bets, the sum of Stake and the sum of Profit. Then explain how to add a calculated field called Yield that divides Profit by Stake. Add a slicer by month. Name each menu exactly as it appears in Excel in [ENGLISH / SPANISH]. If a step changes between desktop Excel and Excel for the web, show both variants and cite the Microsoft help. If you are not sure of the name of a menu, write “I don’t know”.
A quick check of the calculated field.
Example: a market with a profit of 6 on a total stake of 120 must show a 5% yield.

How to read the bankroll chart without fooling yourself
The line chart for column I is honest.
The risk lies with whoever looks at it.
A curve that rises for three weeks does not yet say the method works.
That is why you ask Copilot for the monthly reading with a condition.
It has to tell you first whether the bets are enough to conclude anything.
I am pasting the summary of my pivot table for the last month: [PASTE TABLE]. First tell me how many bets there are in each market and whether that number is enough to draw conclusions. Then point out: the market with the most stake, the rows where the average stake exceeds my rule of [MAXIMUM STAKE]%, and any odd jump in the bankroll. Do not tell me which market to bet on more. Answer in six lines at most. If nothing can be stated with this data, write “I don’t know” instead of guessing.
To understand why few bets are misleading, read how many bets it takes to measure a method.
And if you want a criterion for stake size, try the Kelly calculator with a prudent fraction.
Which common mistakes to avoid
- Pasting a formula in Spanish into an English Excel, or the other way around.
- Choosing markets by the pivot table's yield with twenty bets.
- Forgetting to refresh the pivot table and reading old numbers.
- Entering the bets after you know the result.
- Deleting or “correcting” lost rows so the curve looks better.
- Uploading to a chat a file with personal data or data from your bookmaker account.
The spreadsheet also has a ceiling.
It does not bring live odds and does not alert you to anything on its own.
That is explained in the limits of Excel for betting.
When another AI is a better fit
This workflow is strong on logging and analysis with Excel.
For other needs, there are sister guides.
- If your spreadsheet lives in Google Sheets: how to bet with Gemini.
- To calculate probabilities from a CSV of results: how to bet with ChatGPT.
- For a written audit of your history and your rules: how to bet with Claude.
- To verify a data point with its sources: how to bet with Perplexity.
- For last-minute news: how to bet with Grok.
The spreadsheet measures your bets, it does not choose them.
For a point of comparison, the Gambeta betting AI publishes free predictions with their probability and a public track record.
Responsible gambling: a tidy spreadsheet does not eliminate risk.
Bet only money you can afford to lose and read the responsible gambling guide.
For adults 18 and over only.
What to read next
Your Excel already summarizes and charts on its own.
The next step is to complete the structure with the guide to betting control in Excel.
Then find out how far the spreadsheet goes with the limits of Excel.
And before drawing conclusions from your pivot table, stop by sample size.
Frequently asked questions
Can you bet with Copilot?
Copilot does not place bets and does not operate at any bookmaker.
It helps you build and read your Excel spreadsheet.
You decide on the bet.
Do I need Copilot inside Excel?
No.
Copilot inside Excel depends on your Microsoft 365 plan.
If you do not have it, ask for the formula in the chat and paste it into the cell yourself.
Why does the formula return an error?
It is almost always the language or the separator.
In English Excel the functions are called IF and SUMIF and the arguments are separated with a comma.
In Spanish Excel they are SI and SUMAR.SI and the arguments use a semicolon.
What is a pivot table?
It is a summary that Excel builds by itself from your table.
It groups the bets by market, by month or by odds range and adds up whatever you ask for.
It does not change your original data.
How is it different from the Gemini guide?
The Gemini guide works with a Gem and a spreadsheet in Google Sheets.
This one works in Excel and puts the weight on analysis with a pivot table and a chart.
Choose according to the program you already use.
How many bets do I need to trust the pivot table?
Many more than it seems.
With 20 or 30 bets per market, the difference between one and another can be just luck.
Use the table to spot discipline mistakes before you use it to choose markets.