--- title: "Claude in Excel built a 50-chart India Macroeconomic Dashboard from RBI data in under an hour" slug: claude-in-excel-rbi-macroeconomic-dashboard date_published: 2026-02-08T14:00:00.000Z original_url: https://www.tigzig.com/post/claude-in-excel-rbi-macroeconomic-dashboard source: fresh processed_at: 2026-02-08T14:00:00.000Z --- # Claude in Excel built a 50-chart India Macroeconomic Dashboard from RBI data in under an hour ![Claude Excel RBI Macro Dashboard](/images/blog/c;laudeExcelRBIMacor_01.png) Claude in Excel yesterday one-shotted a xgboost response model... today it prepared a Live India Macroeconomic Indicator Dashboard - Jan 2026. RBI Data. Less than an hour including data engineering, validation sheet and a 50 chart dashboard. Here's the file. [Live file Jan 2026 India top 50 Macro indicators](https://docs.google.com/spreadsheets/d/1bQRpvhkByzk8KaWzgyfxclmrYV2PqIzC/edit?usp=drive_link&ouid=104934656995825254465&rtpof=true&sd=true) This is the first pass with a few formatting instructions. Sharing AsIs. Some formatting issues still there. ## What it did 50 Macro indicators - in weekly, fortnightly, monthly, quarterly sheets. Had it do the following: - Organize into flat file / database format - With columns for frequency, unit of measure and value - Create validation sheet - show 3 totals - all should tally - Show formulas so I can audit it - Create chart for indicators - Output the reconstructed code Took around 1 hour. Wall clock time. Got it done on the side. ## Could this be done differently? I actually wanted to get this done for some time. Claude Code can do it easily, with lesser tokens and a re-usable script. But here everything happened inside Excel including formatting. All these live processing's are likely to be token heavy. This was one off analysis. For repeatability you would need to either feed it the same base code (high token) or better have Claude Code create an offline script or an xlwings-Lite script... many options depending what you want. ## Data Source RBI publishes the raw data here if you want the file going forward: [RBI Database on Indian Economy](https://data.rbi.org.in/#/dbie/home) ## Related Posts - [Claude in Excel just one-shotted an XGBoost response model](https://www.tigzig.com/post/claude-in-excel)