# Consult CNPJ for Free with Excel

Have you ever needed to consult a company's CNPJ but didn't know where to start? The CNPJ (Cadastro Nacional da Pessoa Jurídica) is a unique and important number to identify a company in Brazil. Consulting it in Excel can be a practical and efficient solution. In this post, you will learn how to consult a company's CNPJ in Excel quickly and easily. Follow along!

First, let's understand what Excel is: Excel is a spreadsheet editor produced by Microsoft that is present on practically every computer on the planet. It is the best platform for creating spreadsheets, and many companies rely on the use of these spreadsheets.

Therefore, being able to consult a CNPJ through Excel spreadsheets is extremely useful and can assist in decision-making.

By integrating the [CNPJ.ws](https://www.cnpj.ws) API with Excel, we can automate these consultations easily and quickly, allowing you to use the API to consult various data about your customer or supplier.

* Corporate Name
* Trade Name
* Partners
* Address
* State Registration
* Registration Status
* CNAE
* Simples Option
* MEI Option
* Phone
* Email

See below how simple it is to use our Spreadsheet:

#### Enabling Macros

The spreadsheet uses VBA (Visual Basic for Application) to automate the queries, so when you open the spreadsheet you must enable Macros by clicking the **"Enable Content"** button:

![CNPJ.ws x Excel Integration - Macros](https://github.com/bitize/cnpjws-gitbook-en/blob/main/blog/assets/CNPJws-Excel-macros.jpg)

#### How to search

To search, simply fill in the company's CNPJ in the CNPJ column (in the **"Consultas"** spreadsheet) and then click the **"Consult/Update"** button above:

![CNPJ.ws x Excel Integration](https://github.com/bitize/cnpjws-gitbook-en/blob/main/blog/assets/CNPJws-Excel.jpg)

After clicking the **"Consult/Update"** button, the spreadsheet will provide all the available data, simple right?

Remember that [CNPJ.ws](https://www.cnpj.ws) has a public API and you can consult CNPJs for free, just don't fill in the Token. However, the public API has a limitation of **3 queries per minute** ([see the documentation](https://docs.cnpj.ws/referencia-de-api/api-publica/limitacoes)), which makes the query a bit slow, but for a small volume of queries it can be viable.

If you need more speed or a larger volume of queries, check out [our plans](https://www.cnpj.ws). We made a comparison, consulting 100 different CNPJs, with and without the token:

| Using the Token | Queries |     Time     |
| :-------------: | :-----: | :----------: |
|       Yes       |   100   | **00:00:57** |
|        No       |   100   |   00:34:40   |

[**Click here to download the Spreadsheet for Free**](https://www.cnpj.ws/ConsultaDadosEmpresariaisViaCNPJws.zip)

This spreadsheet is provided as an example only and does not represent an official CNPJ.ws product. Therefore, we do not offer support for Excel-related issues. Feel free to customize this example according to your needs. If you have any questions or suggestions, we are here to help! Contact us at: <contato@cnpj.ws>.

To learn more about our plans and payment methods, visit [CNPJ.ws](https://www.cnpj.ws).

Best regards!


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cnpj.ws/en/blog/consultar-cnpj-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.