---
title: "Monthly MF portfolio files = hours wasted re-formatting. Here's a tool that fixes it"
slug: monthly-mf-portfolio-files-hours-wasted-re-formatting-here-s-a-tool-that-fixes-it
date_published: 2025-09-19T13:23:15.876Z
original_url: https://www.tigzig.com/post/monthly-mf-portfolio-files-hours-wasted-re-formatting-here-s-a-tool-that-fixes-it
source: migrated
processed_at: 2025-12-03T13:00:00.000Z
---

# Monthly MF portfolio files = hours wasted re-formatting. Here's a tool that fixes it

## 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

1. Do it your way → pivots, Jupyter, Colab.
2. Use the AI Analyst SQL Agent at [app.tigzig.com/analyzer](http://app.tigzig.com/analyzer) → Choose File Load to a temporary DB → analyze with Claude Sonnet 4 / DeepSeek / Qwen3 Max.
3. 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

[app.tigzig.com/mf-files-ai](http://app.tigzig.com/mf-files-ai)

## 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](http://app.tigzig.com/rbi-cards)
* **Full Suite:** All 25+ open-source analytics apps are here → [app.tigzig.com](http://app.tigzig.com/)