--- title: "Pull India Mutual Fund NAVs Straight Into Excel. 50, 100 or More Schemes, in a Few Clicks." slug: mfpro-nav-into-excel-aug2026 date_published: 2026-08-19T12:00:00.000Z original_url: https://www.tigzig.com/post/mfpro-nav-into-excel-aug2026 source: fresh processed_at: 2026-08-19T12:00:00.000Z --- # Pull India Mutual Fund NAVs Straight Into Excel. 50, 100 or More Schemes, in a Few Clicks. 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](https://www.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](https://www.tigzig.com/post/sebi-mf-categorisation-changes-jul2026) ## SIF is separate for now SIF data is not yet integrated into MFPRO. It sits separately on [sif.tigzig.com](https://sif.tigzig.com). Small file .. ~11K rows .. just download the whole thing into Excel. ## Related Tools: [MFPRO - Mutual Fund Analytics](https://www.tigzig.com/mfpro), [DUCKIT - CSV to DuckDB](https://www.tigzig.com/duckit-xlwings), [MF File Converter](https://www.tigzig.com/mf-files-ai) Explore: [MF NAV API docs](https://www.tigzig.com/apis/mf-nav), [Python in Excel with xlwings Lite](https://www.tigzig.com/xlwings-starter), [Claude for Analytics hub](https://www.tigzig.com/claude-for-analytics) More posts: [SEBI Has Revised Mutual Fund Categorisation and Introduced a New Fund Type. The Major Changes, and What They Mean for MFPRO Users and Analysts.](https://www.tigzig.com/post/sebi-mf-categorisation-changes-jul2026), [MF NAV API FAQ. Why Am I Getting an Error, Why Is There No SIF NAV, and Why Does the AUM Look Wrong?](https://www.tigzig.com/post/mf-nav-api-faq-aug2026), [Pulling Indian Mutual Fund NAVs One Scheme at a Time? Three Ways to Get the Same Data in Far Fewer Calls.](https://www.tigzig.com/post/mfpro-nav-fewer-calls-batch-files-parquet-aug2026), [An Excel Tracker for Hundreds of Yahoo Finance Tickers, Built with xlwings Lite. For When WEBSERVICE Keeps Failing.](https://www.tigzig.com/post/sp500-excel-tracker-xlwings-yfin-aug2026) --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/mfpro-nav-into-excel-aug2026 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