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 spreadsheet in a format an accountant can actually use is a different matter.
The bad version:
- Navigate to beaconcha.in and pull the income history page for validator 1, copy the table, paste into a new tab
- Repeat for all 20 validators, realigning columns each time because the paste destination keeps shifting
- Realize the income table doesn't include execution tips in the same view and go back to find a second endpoint, then manually cross-reference the two tables
Your accountant charges by the hour. Sending them a half-built spreadsheet 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 Google Sheet. 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 sheet without any manual table construction on your part.
Pull Beaconcha.in income history for all validator indices in column A of my sheet and write epoch, attestation rewards in gwei, proposer rewards in gwei, and MEV tips in wei — one row per epoch per validator, all written into the Income tab starting at row 2
What You Get
- A flat table in the Income tab: 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 — 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 tab 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 — 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 — filter to epochs corresponding to calendar year 2025 only — write epoch, date estimate, attestation reward, proposer reward, and execution tip to the Income tab
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 — 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 tab
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 a Google Sheet with your validator indices in column A, then ask SheetXAI to pull the full income breakdown into a new tab. You might also want the spoke on pulling balance history for yield tracking, and the hub page covers all Beaconchain workflows available in SheetXAI.