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.
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 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:
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:
After clicking the "Consult/Update" button, the spreadsheet will provide all the available data, simple right?
Remember that 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), 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. We made a comparison, consulting 100 different CNPJs, with and without the token:
Yes
100
00:00:57
No
100
00:34:40
Click here to download the Spreadsheet for Free
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.
Best regards!
Last updated
Was this helpful?
