The Scenario
You're an independent staker running 20 validators and tax season just arrived. Your accountant sent back your draft return with a request: they need the income broken out by type, per epoch, for the full calendar year. Not total rewards — the full breakdown: attestation rewards, proposer rewards, execution tips. The data exists on beaconcha.in. Getting it into a workbook in a format an accountant can actually use is a different matter.
The bad version:
- Export a CSV from beaconcha.in for validator 1, open in Excel, map the relevant income columns into the workbook, check the unit labels
- Repeat for all 20 validators, keeping track of which CSV belongs to which validator index because the filenames are ambiguous
- Realize the income CSV doesn't include execution tips in the same export and go back to find a second data source, then manually cross-reference the two tables
Your accountant charges by the hour. Sending them a half-built workbook with columns out of order is not the kind of thing that speeds up a tax filing.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your validator indices in column A, understands the income endpoint structure, and pulls the full per-epoch breakdown from Beaconchain directly into the workbook without any manual table construction on your part.
For validators listed in column A of my Excel table, fetch per-epoch income from Beaconcha.in and populate columns B through E with epoch, attestation reward, proposer reward, and execution tip
What You Get
- A flat table in the Income worksheet: one row per epoch per validator
- Four columns: epoch number, attestation reward in gwei, proposer reward in gwei, and MEV/execution tip in wei
- All 20 validators processed in sequence, with validator index written into a fifth column for cross-referencing
- Any epoch where a reward type is zero is still written as zero, not left blank, so your accountant's SUM formulas don't break
What If the Data Is Not Quite Ready
You need the rewards in ETH rather than gwei/wei for the tax software
Pull Beaconcha.in income history for all validator indices in column A of my Excel table — convert attestation and proposer rewards from gwei to ETH and MEV tips from wei to ETH before writing — one row per epoch per validator in the Income worksheet starting at row 2
Some epochs had no proposer reward because no block was assigned
Pull Beaconcha.in income history for validators in column A of my Excel table — write epoch, attestation reward, proposer reward, and execution tip — mark epochs with no block proposal as 0 in the proposer reward column rather than leaving blank, and add a Proposal column with TRUE/FALSE
You need only the calendar year 2025, not all-time history
Pull Beaconcha.in income history for all validator indices in column A of my Excel table — filter to epochs corresponding to calendar year 2025 only — write epoch, date estimate, attestation reward, proposer reward, and execution tip to the Income worksheet
Pull the income data and add a running total column so the accountant can verify year-to-date at any row
Fetch Beaconcha.in income history for validators in column A of my Excel table — epochs covering calendar year 2025 — write epoch, attestation reward, proposer reward, execution tip, and a running total of combined rewards in ETH — one row per epoch per validator in the Income worksheet
Cleanup and calculation in a single instruction means the accountant gets a complete table, not a starting point.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your validator indices in column A, then ask SheetXAI to pull the full income breakdown into a new worksheet. You might also want the spoke on pulling balance history for yield tracking, and the hub page covers all Beaconchain workflows available in SheetXAI.