Monthly MF portfolio files = hours wasted re-formatting. Here's a tool that fixes it
Published: September 19, 2025
Why This Exists
If you track Indian MF portfolios, you know the drill. Monthly disclosure Excel files = same info, different layouts. Spending time re-structuring is dead time.
What You Get
- A converter utility built for analysts.
- Drop in raw files.
- Get back clean CSVs with ISIN mapping + standardized names.
- Plug straight into your analysis workflow
How It Works
- AI-powered schema detection: Automatically figures out data layout
- Cross-validation: Runs multiple models to check totals.
- Override: When in doubt, enter the schema manually - tool re-runs instantly.
Extra Utilities
- Append multiple funds → one file.
- Transpose holdings → side-by-side view.
- Logs + validation table → quick audit trail.
What Next - Analysis Options
- Do it your way → pivots, Jupyter, Colab.
- Use the AI Analyst SQL Agent at app.tigzig.com/analyzer → Choose File Load to a temporary DB → analyze with Claude Sonnet 4 / DeepSeek / Qwen3 Max.
- Upload to ChatGPT (Go/Plus). Have it load into python/ pandas and analyze.
Bottom line: A single, focused utility. Converts messy disclosures → clean, structured data. From there, analysis is up to you. Usage guide + build guide included → hit 'Docs' on top.
Live at
Resources for Analysts
- RBICC Tool: If you also work with RBI Monthly ATM/ POS/ Cards, this Excel to CSV converter might be useful - app.tigzig.com/rbi-cards
- Full Suite: All 25+ open-source analytics apps are here → app.tigzig.com
🔗
Blog Migration Notice: Some links or images in earlier posts may be broken.
View the original post on the old blog site.