Built and run by one person.
Pull India Mutual Fund NAVs Straight Into Excel. 50, 100 or More Schemes, in a Few Clicks.
Top•MFPRO - Mutual Fund Analytics•DUCKIT - CSV to DuckDB•MF File Converter

Pull India Mutual Fund NAVs Straight Into Excel. 50, 100 or More Schemes, in a Few Clicks.

Published: August 19, 2026

Related toolsMFPRO - Mutual Fund Analytics•DUCKIT - CSV to DuckDB•MF File Converter

Want to pull India Mutual Fund NAV's directly into Excel. Say for 50 or 100 schemes. .. or more? Now do that in just a few clicks on MFPRO .. in batches of 20 ..simple interface, advanced search and filters. Free. No Sign In. All schemes from 2006, updated 3x a day.

Get a CSV. Open it in Excel and it is ordinary rows.

Ratios. Returns, CAGR, drawdown, whatever you normally work out with formulas.

AI assistance. If you use Claude or something similar alongside Excel, it will write those formulas for you off the same file. If you are using Claude Cowork or ChatGPT Work it will fetch the data for you and do the calculations for you too.

Link: tigzig.com ➜ MFPRO ➜ Data & API

Docs, Guides and Data Dictionary. What each field means, how the data is pulled and how it is checked. Every doc page has a copy button, so you can hand the whole thing to your AI.

Full database. And if you want everything rather than a selection, the full history is one download, April 2006 onward. That one is 37 million rows, so it is not an Excel file, and you would bring it in through something like xlwings Lite reading it via DuckDB.

Some quick points for analysts

Name changes. And they have changed a lot this year. SEBI reissued the categorisation framework in February and AMCs have been re-filing since, so the same fund can turn up under a new category name, and sometimes a new scheme name, between two of your files. If you are matching on name, that break shows up as rows dropping out of your join without any error.

Use the AMFI scheme code as your key. It survives renames. ISIN works too, but check your coverage before you rely on it: about one in fourteen live schemes carries no ISIN at all, and across the full history including matured schemes it is closer to a quarter. Some schemes also carry a second ISIN for the reinvestment option.

Direct and Regular are separate scheme codes, and so are Growth and IDCW, so one fund in your head is usually four rows in the file.

SEBI has revised mutual fund categorisation

SIF is separate for now

SIF data is not yet integrated into MFPRO. It sits separately on sif.tigzig.com. Small file .. ~11K rows .. just download the whole thing into Excel.