Rio Grande do Sul Company Database (CNPJ) with Email and Phone: 632,854 Active (September 2026)
632,854 active establishments of companies in Rio Grande do Sul, Brazil (legal entities, no MEI) from the Receita Federal CNPJ register, with email (84.7%), E.164 phone (98.5%), CNAE, size, capital, address and municipality.
632,854 rows, 37 columns, CSV. US$119.00, one-time payment.
FAQ about this dataset
- What does this dataset include?
- 632,854 rows and 37 columns: cnpj, cnpj_basico, matriz_filial, razon_social, nombre_fantasia, naturaleza_juridica_codigo, naturaleza_juridica, porte_empresa, capital_social_brl, fecha_inicio_actividad, cnae_principal_codigo, cnae_principal_descripcion, among others. Before buying you can see the full schema with each column's fill rate and the first 25 rows for free, without signing up.
- Where does the data come from?
- Dados abertos CNPJ, Receita Federal do Brasil: September 2026 edition (cut-off 14 September 2026), state of Rio Grande do Sul. Collected and processed by datasets.lat (as of September 14, 2026).
- How often is it updated?
- Planned update frequency: quarterly. Buyers also get every new version of this dataset we publish at no extra cost.
- What format is the download?
- Your choice: CSV (UTF-8, with headers), Excel (.xlsx) or JSON. It opens in Excel, Google Sheets, Python, R or any SQL database. The download is available right after payment and all three formats are in your library.
- What license does it have?
- License: commercial use (internal; no resale of the file as is). It contains contact or personal data published by their owners or by official sources; the listing states the legal basis, and you must use it in line with your country's data protection law. Details are in the terms of use.
- How much does it cost?
- US$119 as a one-time payment with Mercado Pago or PayPal. It is not a subscription.
What's included
- 632,854 active establishments of 573,677 companies in Rio Grande do Sul (legal entities only, no MEI or sole proprietors), each with at least one phone or email, in 497 municipalities. 564,647 head offices and 68,207 branches.
- Email for 535,885 (84.7%) and E.164 phone (+55) for 623,339 (98.5%); 352,390 with a mobile number and 97,361 with two or more phones.
- Top municipalities: Porto Alegre (135,170), Caxias do Sul (38,976), Novo Hamburgo (19,266), Canoas (18,975), Passo Fundo (16,980), Pelotas (14,228), Santa Maria (14,071), Gravataí (11,928).
- By legal nature: 518,720 limited liability companies (LTDA), 30,632 private associations, 26,057 building condominiums, 9,310 single-member law firms, among others.
- By size: 362,114 micro-enterprises (ME), 178,433 medium, large and other ("demais"), 92,307 small businesses (EPP). 347,651 are in the Simples Nacional tax regime.
- By CNAE section: wholesale and retail trade (154,354), professional, scientific and technical services (68,598), administrative and support services (66,414), health and social work (47,331), manufacturing (44,863), other services (41,918); 1,239 distinct CNAE activities.
- 116,830 establishments opened in 2025 and 2026.
- 37 columns (Spanish names): CNPJ (14 digits) and base CNPJ, head office or branch, legal name, trade name, legal nature (code and description), company size (porte), share capital in BRL, activity start date, main CNAE (code and description), secondary CNAEs, registration status and date, Simples Nacional option, address (street type, street, number, complement, neighborhood/bairro, CEP), municipality, state (UF), up to 3 E.164 phones, email, free-mail flag, how many companies share the email and the phone, has_phone / has_mobile / has_email flags, country, source and cut-off date.
About the emails and phones
- These are the contact details each company registered with the Receita Federal: the email registered with the Receita Federal; for many companies it is the accountant's email or that of the firm that filed the registration, not a sales contact.
- To help you filter, email_compartido_por_empresas shows how many distinct companies use the same email: 333,788 rows have an email used by a single company and 104,094 an email shared by 10 or more companies (typically accounting offices). telefono_compartido_por_empresas does the same for phones (132,390 rows with a phone shared by 10 or more companies).
- email_gratuito flags Gmail, Hotmail, Yahoo, Outlook, BOL, UOL, Terra, iG, Live and iCloud addresses (329,395 rows); 206,490 rows have an email on a company domain.
- Syntax is validated, but no test emails were sent: some mailboxes may no longer exist.
Use cases
- B2B prospecting in Rio Grande do Sul: lists by CNAE, municipality, size and opening date, ready for your CRM or dialer.
- Email and phone campaigns: filter on tiene_email, tiene_movil and email_compartido_por_empresas = 1.
- Accountant channel and market sizing: spot accounting offices through shared emails and count companies by activity and municipality.
How we prepared it
This is the Rio Grande do Sul part of our national file, with the same preparation:
- Source: Receita Federal do Brasil open CNPJ data (Dados Abertos CNPJ), September 2026 edition (cut-off date 14 September 2026). The Empresas, Estabelecimentos and Simples Nacional files are joined by base CNPJ, with the official CNAE, legal nature and municipality descriptions.
- Of the 73,366,147 establishments in the register, 28,263,121 are active. We excluded 17,431,451 active establishments of natural persons: individual entrepreneurs (legal nature 213-5, which holds nearly all of the 13,738,467 active MEI establishments), group 4 (rural producer as a natural person, political candidate, individual real estate business) and companies whose legal name contains a CPF. 1,227 establishments of companies flagged as MEI in the Simples file are also excluded.
- We also excluded 51,773 establishments based abroad, 124,813 political-party bodies (their contact is usually a person and reveals political affiliation) and 804,516 establishments without any valid phone or email.
- Phones: area code (DDD) validated against Brazil's 67 codes, the ninth digit added to old 8-digit mobiles, filler numbers dropped, and the three phone fields merged without duplicates, in E.164 (+55). tiene_movil marks a mobile number.
- Emails: lowercased and syntax-checked; 70,648 invalid or filler emails (naotem@, [email protected], [email protected]) and obvious domain typos (gmail.con, gmai.com) were removed.
- Names without double spaces; asterisk-only trade names emptied; CEP as 00000-000. CNAE and legal nature descriptions are in Portuguese, as in the official classification.
- No partners (QSA), CPF or shareholder data.
If you need all of Brazil, see the national file (9,849,341 establishments in all 27 states): https://datasets.lat/en/datasets/brazil-companies-cnpj-email-phone
If you purchase, you get the updates we publish for free.
Columns
- cnpj (integer)
- cnpj_basico (integer)
- matriz_filial (string)
- razon_social (string)
- nombre_fantasia (string)
- naturaleza_juridica_codigo (integer)
- naturaleza_juridica (string)
- porte_empresa (string)
- capital_social_brl (number)
- fecha_inicio_actividad (date)
- cnae_principal_codigo (integer)
- cnae_principal_descripcion (string)
- cnaes_secundarios (string)
- situacion (string)
- fecha_situacion_cadastral (date)
- opcion_simples (boolean)
- tipo_logradouro (string)
- logradouro (string)
- numero (string)
- complemento (string)
- bairro (string)
- cep (string)
- municipio (string)
- uf (string)
- telefono_1_e164 (string)
- telefono_2_e164 (string)
- telefono_3_e164 (string)
- email (string)
- email_gratuito (boolean)
- email_compartido_por_empresas (integer)
- telefono_compartido_por_empresas (integer)
- tiene_telefono (boolean)
- tiene_movil (boolean)
- tiene_email (boolean)
- pais (string)
- fuente (string)
- fecha_corte (date)