--- 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/claudeExcelRBIMacor_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) ## Related Tools: [TREMOR - Macro Stress Signals](https://www.tigzig.com/tremor), [Practice Lab](https://www.tigzig.com/xlwings-starter), [Data Importer](https://www.tigzig.com/xlwings-data-importer) Explore: [Claude for Analytics hub](https://www.tigzig.com/ai-in-excel), [Quant and macro apps](https://www.tigzig.com/markets), [All guides](https://www.tigzig.com/blog) More posts: [Claude in Excel just one-shotted an XGBoost response model with train-test split, AUC and full decile table. In a spreadsheet.](https://www.tigzig.com/post/claude-in-excel), [TREMOR - Macro Early Warning Dashboard - 50+ Indicators, Updated Daily](https://www.tigzig.com/post/tremor-macro-dashboard-50-indicators), [Claude in Excel - Nifty50 Return Distribution Analysis (30 days forward) 2008 to 2026](https://www.tigzig.com/post/claude-in-excel-nifty50-return-distribution-analysis), [Claude in Excel + MCP + xlwings Lite + Claude Code: Pull Data, Build a Model, Validate It.](https://www.tigzig.com/post/claude-in-excel-mcp-xlwings-lite-claude-code-combining-4-tools) --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/claude-in-excel-rbi-macroeconomic-dashboard Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms