The Scenario
You administer a staking fund with 40 validators and the fund accountant sends the same request every month: a withdrawal reconciliation. They need epoch, slot, amount, and recipient address for every withdrawal made during the month. Last month you exported CSVs from beaconcha.in for each validator, imported them into Excel, and spent three hours aligning columns. The accountant found two rows where the amounts didn't match because a gwei value had been rounded during the CSV import. The fund's audit is next quarter.
The bad version:
- Export a withdrawal CSV from beaconcha.in for validator 1, import into Excel, check that the gwei column imported without rounding
- Repeat for all 40 validators, keeping a log of which CSVs have been imported because the filenames don't include the validator index
- Discover that two validators had multiple withdrawals in the same epoch and the CSV exported them as separate rows while a third validator collapsed them — and now you're not sure which format is authoritative
An audit doesn't ask "did you try your best?" It asks "does the number match?"
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your 40 validator indices from column A, pulls withdrawal records from Beaconchain for each one, and writes the complete reconciliation table in a flat format the accountant can work with directly.
Pull withdrawal records for validators listed in column A of my Excel table from Beaconcha.in and populate columns B through E with: epoch, slot, withdrawal amount in gwei, and recipient address
What You Get
- One row per withdrawal event across all 40 validators
- Four columns: epoch, slot, withdrawal amount in gwei, and recipient address
- Validator index in a fifth column for attribution
- Multiple withdrawals in the same epoch written as separate rows, not combined
What If the Data Is Not Quite Ready
The accountant needs amounts in ETH, not gwei
Pull Beaconchain withdrawal history for all validators in column A of my Excel table — write epoch, slot, amount converted from gwei to ETH, and recipient address — one row per withdrawal
You need to filter to only withdrawals that occurred in April 2025
Fetch Beaconchain withdrawal history for validators in column A of my Excel table — filter to withdrawals in epochs corresponding to April 2025 — write epoch, slot, amount in ETH, and recipient address to the Withdrawals worksheet
The accountant also needs a per-validator subtotal at the end of each validator's rows
Pull Beaconchain withdrawal history for validators in column A of my Excel table — write epoch, slot, amount in ETH, and recipient address one row per withdrawal grouped by validator — insert a subtotal row after each validator's withdrawals showing total amount and count
Build the complete audit-ready package: all withdrawals, per-validator subtotals, and a summary worksheet
Fetch Beaconchain withdrawal history for all validators in column A of my Excel table — write detailed records to the Withdrawals worksheet with subtotal rows per validator — create a separate Summary worksheet showing each validator's total withdrawal amount in ETH and withdrawal count for the period
All three views from a single instruction, so the accountant gets the package rather than a starting dataset.
Try It
Get the 7-day free trial of SheetXAI and open the fund's reconciliation workbook with your 40 validator indices in column A, then ask SheetXAI to pull the complete withdrawal history. The spoke on reward summaries is a useful companion for the investor report, and the hub page documents all Beaconchain workflows available in SheetXAI.