Download daily new company registration data as clean, structured CSV files. Every record includes CIN, company name, address, capital, directors, email, and phone — ready to open in Excel or import straight into Salesforce, HubSpot, or Zoho CRM.
A CSV (Comma-Separated Values) file is a universal plain-text format used to store tabular data. Each line in the file represents one row, and each field within that row is separated by a comma. The first row is usually a header that names every column, so both humans and software can understand the structure at a glance.
Because CSV is plain text, it opens in almost any application — Microsoft Excel, Google Sheets, Apple Numbers, Notepad, and every major CRM. There are no proprietary formats, no macros, and no compatibility headaches. A CSV file created on a Windows laptop will open identically on a Mac, a Linux server, or inside Salesforce.
We chose CSV as the delivery format for our new company data for three reasons. First, universal compatibility: any spreadsheet or CRM your team already uses can read it. Second, small file size: daily files stay under 1 MB, so they arrive cleanly by email and open instantly. Third, easy import: the structured, comma-delimited layout maps cleanly to CRM fields, so you can load hundreds of new companies in minutes without manual cleaning. For hands-on Excel techniques, see our companion guide on using company data in Excel.
Every column in the daily CSV is documented below. Email Only plans include the first 14 columns; Email + Phone plans add the three premium director columns marked with a star, for a total of 17 columns.
| Column Name | Data Type | Description |
|---|---|---|
| CIN / LLPIN | Text (21 chars) | Corporate Identity Number or LLP Identification Number — the unique government identifier for every company or LLP. |
| Company / LLP Name | Text | The full registered legal name of the company or Limited Liability Partnership as filed with the MCA. |
| Date of Registration | Date (DD/MM/YYYY) | The date the company or LLP was incorporated and officially registered with the Registrar of Companies. |
| Registered Address | Text | The complete registered office address filed at the time of incorporation, including building, street, and locality. |
| State | Text | The Indian state in which the company is registered, useful for state-level filtering and regional targeting. |
| City | Text | The city of the registered office, letting you segment leads by metro, tier-2, or tier-3 locations. |
| Pin Code | Text (6 digits) | The 6-digit postal code of the registered office. Format as text in Excel to preserve any leading zeros. |
| Category | Text | The company category — Private Limited, Public Limited, One Person Company (OPC), or LLP — telling you the legal structure. |
| Sub-Category | Text | Further classification of the company category, such as Non-govt company or Subsidiary of a foreign company. |
| Class of Company | Text | Class I, Class II, or Class III — a classification based on the company’s capital and membership size. |
| Authorised Capital | Number (INR) | The maximum share capital the company is authorised to issue to shareholders, stated in Indian Rupees. |
| Paid-Up Capital | Number (INR) | The amount of share capital actually paid and subscribed by shareholders at incorporation, in Indian Rupees. |
| Business Activity | Text | A description of the principal business activity based on the NIC (National Industry Classification) code. |
| Company Email | Text | The verified email address submitted at incorporation, ready for B2B outreach and CRM enrichment. |
| Director Names | Text (Premium) | The full names of all directors of the company. Included with Email + Phone plans. |
| Director DIN | Text (Premium) | The Director Identification Number (DIN) assigned to each director by the MCA. Included with Email + Phone plans. |
| Director Mobile | Text (Premium) | The mobile phone numbers of the company’s directors for direct sales outreach. Included with Email + Phone plans. |
* Premium columns included only with Email + Phone plans.
Opening your daily company data CSV in Excel takes under a minute. Follow these steps to ensure dates and numeric capital columns render correctly.
Save the CSV file from your daily email or download it from your dashboard.
Launch Microsoft Excel and start a blank workbook.
Go to File › Open, browse to your downloaded CSV, and select it.
If the wizard appears, choose “Delimited”, select “Comma” as the delimiter, then click Finish.
Format CIN and Pin Code as Text, dates as DD/MM/YYYY, and capital columns as currency (INR) as needed.
Tip: In newer Excel versions, use Data › Get Data › From Text/CSV for better UTF-8 encoding support. See our detailed walkthrough on working with company data in Excel.
The CSV format imports directly into every major CRM. Below are quick-start guides for the three most popular platforms.
The same CSV works in Pipedrive, Freshsales, and Microsoft Dynamics — just use each platform’s import wizard and map the columns to your custom fields.
Our CSV files follow a consistent, predictable structure so they import cleanly into any tool on the first try. Here is exactly what to expect inside every file.
Because the format is consistent across every daily delivery, you can build a one-time import mapping in your CRM and reuse it each day — no re-formatting, no surprises. To understand the broader data set these columns come from, read about our platform features and the company registration data we deliver.
CSV keeps your daily company data portable, lightweight, and instantly usable across every tool in your stack.
Opens in Excel, Google Sheets, Numbers, and every CRM — no special software or plugins required.
Small file size means your daily CSV arrives as a normal email attachment that opens instantly, every time.
Structured columns map cleanly to CRM fields, so you can load hundreds of new companies in minutes.
Everything you need to know about the new company data CSV format.
NewCompanyAlert delivers data as CSV (Comma-Separated Values) files. CSV is a universal, plain-text format that opens natively in Microsoft Excel, Google Sheets, Apple Numbers, and every major CRM tool, so you can start working with your company data the moment it arrives in your inbox.
Every CSV file is UTF-8 encoded. This ensures Indian-language characters that occasionally appear in company names and registered addresses render correctly in Excel, Google Sheets, and CRM imports without producing garbled text or missing characters.
Email Only plan CSV files contain 14 columns covering company registration and email data. Email + Phone plan CSV files contain 17 columns, adding director names, DIN, and director mobile numbers for direct sales outreach.
Yes. The CSV format is compatible with all major CRM tools including Salesforce, HubSpot, Zoho CRM, Pipedrive, and Microsoft Dynamics. You simply map each CSV column to the corresponding CRM field during the import wizard and the records load in minutes.
No. Daily CSV files are typically under 1 MB, making them easy to open in Excel and attach to an email. Monthly compilations, which bundle several days of data into a single file, may be larger but still open comfortably in any modern spreadsheet application.
Sign up free and start receiving daily new company data as clean, structured CSV files — ready for Excel or your CRM.
Want to learn more? Explore our features, read the blog, or see our daily new company data feed.