Open your daily new company registration CSV in Microsoft Excel and learn how to filter, sort, and analyze MCA company data using pivot tables, VLOOKUP, and advanced filtering. Our CSV files work seamlessly with Excel — no add-ins required.
Your daily company data arrives as a CSV file, which Excel opens natively. To get started, download the CSV from your daily email or from your dashboard, then follow these steps.
Save the daily CSV attachment from your inbox or download it from your NewCompanyAlert dashboard.
Launch Microsoft Excel and start a blank workbook.
Go to File › Open, locate the downloaded CSV, and select it. Excel parses the commas automatically.
If the wizard appears, choose “Delimited”, tick “Comma” as the delimiter, then click Finish to load the data into columns.
Format CIN and Pin Code as Text, dates as DD/MM/YYYY, and capital columns as INR currency to finish the import.
Pro tip: In Excel 2016 and later, use Data › Get Data › From Text/CSV instead of File › Open. This route gives you an encoding preview, lets you explicitly set UTF-8, and handles Indian-language characters in company names and addresses far more reliably. For full details on the underlying file format, see our CSV format guide.
A few quick formatting tweaks ensure your company data displays correctly and is ready for analysis the moment it opens.
Format the CIN / LLPIN column as Text to preserve leading zeros and the full 21-character identifier.
Format the Date of Registration column as a date so you can sort and filter chronologically.
Format Authorised and Paid-Up Capital as INR currency to add thousands separators and the ₹ symbol.
Apply “Format as Table” to enable one-click filtering, sorting, and a clean visual style across the sheet.
Formatting CIN as text is the single most important step — Excel sometimes interprets long numeric-looking identifiers as numbers and drops leading zeros, which breaks the 21-character CIN format. Once these formats are in place, the sheet is ready for filtering and pivot-table analysis.
One of the first things most teams do is narrow the national dataset down to the states they care about. Excel makes this a one-click operation.
Excel instantly hides every row that does not match, leaving only companies from your selected states. Combine this with a City filter to drill down further — for example, Maharashtra › Pune. To explore state-level coverage, browse our newly registered companies in India resource.
Use the same filter approach on the Category column to isolate specific company structures. This is invaluable when your offering targets one type of entity.
Private Ltd
Show only newly registered private limited companies.
LLP
Isolate Limited Liability Partnerships for partnership-focused outreach.
OPC
Target One Person Companies, often solo founders.
Simply click the Category filter, untick “(Select All)”, then tick the structure you need. Excel filters the entire dataset in place, so all your other columns — address, capital, email — stay aligned with the filtered rows.
Pivot tables turn raw company data into instant insights. Select any cell in your data, go to Insert › PivotTable, and use these ready-made setups.
Rows: State
Values: Count of CIN
See which Indian states are registering the most new companies each day.
Rows: Category
Values: Sum of Authorised Capital
Compare authorised capital totals across Pvt Ltd, Public, OPC, and LLP structures.
Rows: Business Activity
Values: Count of CIN
Identify which industries and NIC codes are seeing the most new incorporations.
To build any of these, click anywhere in your data, choose Insert › PivotTable, and drag fields into the Rows and Values areas. For a count, Excel defaults to “Count of CIN” when you add a text field to Values — exactly what you want for counting companies. For capital sums, add the Authorised Capital field and change the summary to Sum.
Refresh the pivot table any time you load a new daily CSV by right-clicking it and choosing Refresh. If you append new daily files into a single sheet (or use a named Excel Table as the source), your pivot tables update automatically — giving you an evergreen view of registration trends. Learn more about the source fields in our features overview.
VLOOKUP lets you pull information from a second sheet into your company data. A common use case is mapping NIC business-activity codes to human-readable industry names from a separate reference sheet.
=VLOOKUP(B2, NIC_Codes!A:B, 2, FALSE)Here, B2 is the NIC code in your company data, NIC_Codes!A:B is the two-column lookup range on your reference sheet, and the 2 returns the industry name from the second column. Copy the formula down the whole column to enrich every row at once.
The same pattern works for anything you want to append — region groupings from a state list, account ownership from a sales rep roster, or priority scores from a custom segmentation sheet. For a deeper look at the full data set behind these fields, see our CSV column reference.
After filtering your company data down to a specific state, industry, or company type, you will often want to share that slice with a teammate or load it into another tool.
This makes it easy to hand a state-specific or industry-specific list to a colleague without exposing the entire national dataset. For more on the format itself, revisit our CSV format guide.
Common questions about working with new company data in Microsoft Excel.
Yes, CSV opens natively in Excel with a simple File › Open. For best results with Indian-language characters that sometimes appear in company names and addresses, use Data › Get Data › From Text/CSV, which lets Excel detect UTF-8 encoding automatically.
Format the CIN column as Text before importing data, or prefix each CIN with an apostrophe (for example ’U80902MH2024PTC123456). Because CINs are alphanumeric and can begin with a zero, treating them as text preserves the full 21-character identifier exactly as issued by the MCA.
Yes. Excel pivot tables work perfectly with our CSV data. You can count companies by state, sum authorised capital by category, or break down registrations by business activity — all without any manual data preparation.
Yes. Dates are stored in DD/MM/YYYY format, which Excel recognises automatically. Once open, you can apply any regional date format you prefer, or sort and filter by registration date out of the box.
Yes. After filtering, use File › Save As and choose the .xlsx format to preserve all your formatting, filters, and pivot tables. This is ideal for sharing state-specific or industry-specific slices with team members.
Sign up free and start receiving daily new company data as CSV files that open instantly in Excel — ready for filtering, pivot tables, and analysis.
Want to learn more? Explore our features, browse newly registered companies in India, or read the blog.