Consult CNPJ for Free with Excel
Use this Excel spreadsheet to consult company data through the CNPJ using the CNPJ.ws API, with data from Receita Federal, Sintegra, and Suframa.
Last updated
Was this helpful?
Use this Excel spreadsheet to consult company data through the CNPJ using the CNPJ.ws API, with data from Receita Federal, Sintegra, and Suframa.
Last updated
Was this helpful?
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 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
See below how simple it is to use our Spreadsheet:
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:
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:
After clicking the "Consult/Update" button, the spreadsheet will provide all the available data, simple right?
Yes
100
00:00:57
No
100
00:34:40
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.
Best regards!
Remember that 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 (), 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 . We made a comparison, consulting 100 different CNPJs, with and without the token:
To learn more about our plans and payment methods, visit .
