Google Sheets add-on

CNPJ and CEP lookups right in Google Sheets.

Fill Brazilian company data from a CNPJ and addresses from a CEP with simple formulas.

Coming soon on Marketplace Watch the demo

Free plan: 100 lookups per month.

Example: the formula =CNPJ("33000167000101";"razao_social") returns PETROLEO BRASILEIRO S A PETROBRAS; =CEP("01310100";"logradouro") returns Avenida Paulista.
  • =CNPJCompany data from a CNPJ
  • =CEPAddresses from a CEP
  • 100Free lookups per month
  • R$ 29Pro, per month

How it works

From a list of CNPJs to a filled sheet.

  1. Install the add-on

    Coming soon on the Google Workspace Marketplace. You will install it from there, in your Google account.

  2. Write a formula

    Pass the CNPJ or CEP and the field you want back.

  3. Fill down

    Drag the formula down the column to fill the whole list.

=CNPJ(A2;"razao_social")
ABCDE
1CNPJRazão socialSituaçãoMunicípioUF
200.000.000/0001-91BANCO DO BRASIL SAATIVABRASILIADF
333.000.167/0001-01PETROLEO BRASILEIRO S A PETROBRASATIVARIO DE JANEIRORJ
460.701.190/0001-04ITAU UNIBANCO S.A.ATIVASAO PAULOSP
533.592.510/0001-54VALE S.A.ATIVARIO DE JANEIRORJ
647.960.950/0001-21MAGAZINE LUIZA S/AATIVAFRANCASP

Functions

Two functions. The fields you need.

=CNPJ()

Company data from a CNPJ

=CNPJ("33000167000101";"razao_social")
Result: PETROLEO BRASILEIRO S A PETROBRAS

Fields

razao_social
Legal name
nome_fantasia
Trade name
situacao
Registration status
municipio
City
uf
State
cnae
Main activity
telefone
Phone
email
Email
endereco
Full address

=CEP()

Addresses from a CEP

=CEP("01310100";"logradouro")
Result: Avenida Paulista

Fields

logradouro
Street
bairro
Neighbourhood
cidade
City
uf
State

Data comes from third-party public sources (BrasilAPI, CNPJá, CNPJ.ws). See the Terms.

Demo

See it working in a real sheet.

Type a CNPJ or CEP, add a formula, fill down. The video loads from YouTube only when you press play.

Pricing

Start free. Upgrade when you need more.

  • Free

    For occasional lookups.

    R$ 0

    • 100 lookups per month
    • =CNPJ and =CEP functions
    Coming soon on Marketplace

  • Pro

    For larger lists and regular use.

    R$ 29/ month

    • More lookups beyond the free limit
    • Billed monthly through Stripe
    • Cancel anytime
    Coming soon on Marketplace

Good to know

Limits, stated plainly.

From the Terms and the Privacy Policy.

  • Data comes from third-party public sources (BrasilAPI, CNPJá, CNPJ.ws), provided “as is”: no guarantee that it is complete, accurate, current, or available at any time. Verify critical information at the official source.
  • Free plan: 100 lookups per month. Pro: R$ 29 per month, billed through Stripe. Cancel anytime; Pro access continues until the end of the period already paid.
  • The content of your spreadsheet is not sent or stored. The CNPJ and CEP values you query are not written to the database.

More from Errand Code

Other products.

Stop copying company data by hand.

Coming soon: install once, then it's just a formula.

Coming soon on Marketplace