Peru SUNAT Taxpayer List in Excel: Active Companies
Peru SUNAT taxpayer list in Excel or CSV: 886,182 active RUC 20 companies, 867,351 verified, with filters by region, ISIC activity, employees and trade.
Short answer: the reduced taxpayer register (padrón reducido) from SUNAT, Peru's tax authority, is free, but it is a text file with millions of taxpayers that does not fit in an Excel sheet. Filtered to active RUC 20 companies (legal entities) there are 886,182, which do fit in one sheet; 867,351 of them are "habido", meaning verified at their tax address. Our Peru companies with RUC from the SUNAT register dataset downloads in Excel, CSV or JSON, with 30 columns and a cut-off of September 30, 2026, for a one-time US$349.
This guide is practical: what the file looks like in Excel, which columns to filter and how many companies remain with each filter.
Why the official register does not open well in Excel
Excel allows up to 1,048,576 rows per sheet. SUNAT's reduced register includes individuals plus deregistered and suspended companies, so it is far over that limit: among RUC 20 records alone, we dropped 1,471,756 that were not active.
The official file also lacks economic activity, headcount and foreign trade. Those fields are in the monthly RUC register on Peru's National Open Data Platform, and the two have to be joined by RUC.
If you only care about a few thousand companies in one district, you can do it yourself with Python, R or a SQL database. If you want to open the result in Excel and start filtering, the joined file is faster.
The columns you will use in Excel
| Column | Content | Rows with data |
|---|---|---|
ruc, razon_social |
Validated 11-digit RUC and legal name | 100% |
habido |
true or false, to filter in one click | 100% |
condicion_sede_fiscal |
Habido, no habido, no hallado, pending and others | 100% |
tipo_contribuyente |
50 official types (SAC, EIRL, SRL and others) | 100% |
actividad_ciiu_rev4_principal |
ISIC revision 4 description | 98.9% |
trabajadores |
Integer headcount | 40.6% |
actividad_comercio_exterior |
Importer, exporter, both or none | 100% |
departamento, provincia, distrito, ubigeo |
Tax location | 99.9% to 100% |
sede_fiscal |
Full address, also split into street, number, unit, lot, block and zone | 100% |
Column names and values are in Spanish, as SUNAT publishes them.
How many companies remain with each filter
By address condition: habido 867,351, no habido (not located) 15,316, no hallado (not found) 2,203, pending 1,121, not applicable 156 and to be verified 33.
By department (region), total and habido:
| Department | Active companies | Habido |
|---|---|---|
| Lima | 444,470 | 435,806 |
| Arequipa | 52,480 | 51,325 |
| La Libertad | 43,900 | 42,985 |
| Cusco | 28,966 | 28,719 |
| Piura | 26,894 | 26,126 |
| Junín | 26,352 | 25,702 |
| Cajamarca | 25,223 | 24,690 |
| Callao | 24,675 | 24,174 |
By size: 359,967 companies report a headcount figure (28,078 of them report zero). 284,407 have 1 to 10 workers, 36,392 have 11 to 50, 7,542 have 51 to 200, 2,622 have 201 to 1,000 and 926 have over 1,000. Combining habido = true with 11 or more workers leaves 47,376 companies.
By foreign trade: 108,487 import and export, 34,504 only import and 6,891 only export.
A combined example: habido companies in Arequipa with 11 to 50 workers and some foreign trade activity: 262.
How to build your list in Excel in 6 steps
- Download the Excel file. It has 886,182 rows in one sheet.
- Turn on filters on the header row (Data > Filter).
- Filter
habido= true. This leaves out the 18,831 active companies that are not habido. - Pick department and district. In the province of Lima, the districts with the most companies are Lima (36,189), Santiago de Surco (35,721), Miraflores (27,667) and San Isidro (23,162).
- Filter by activity. Use a text filter on
actividad_ciiu_rev4_principal(for example, "construcción" or "transporte"). - Refine by size or foreign trade. A number filter on
trabajadoresand a list filter onactividad_comercio_exterior.
If you work with the CSV, import it as UTF-8 and set ubigeo as text so you keep the leading zero of departments 01 to 09.
What each filter is for
- B2B prospecting: activity, district and headcount to build sales territories.
- Customer and supplier validation:
habidoandcondicion_sede_fiscalbefore granting credit or issuing a purchase order. - Foreign trade: the 149,882 companies with registered import or export activity, by sector and region.
- Market research: company density by district and activity.
The register has no phones or emails. For contacts, the Peru business database with phone numbers has 52,537 businesses and can be matched by name and district. To see who sells to the government, look at Peru public contracts 2026. More Peruvian sources are on the Peru data page.
FAQ
Can I download the SUNAT register in Excel for free?
SUNAT publishes the reduced register for free, but as text and with more rows than Excel can hold. Our file, already filtered to 886,182 active RUC 20 companies, downloads in Excel, CSV or JSON for US$349.
What do habido and no habido mean?
Habido means SUNAT located the taxpayer at its registered tax address. No habido means it could not, which is a warning sign before selling on credit or signing a contract.
Does it include sole traders (RUC 10)?
No. Only RUC 20, legal entities. We also removed 11 RUC 20 records that SUNAT classifies as natural persons.
How often is it updated?
Quarterly updates are planned. Buyers get new versions at no extra cost.
Can I test it before buying?
Yes. The page shows the schema with each column's fill rate and the first 100 rows without signing up, and a free account lets you download 500 rows. Payment is one-time, with PayPal in USD.
Test your filters on the sample
Open the Peru companies with RUC from SUNAT, download 500 free rows with a free account and try the filters in this guide in Excel before you decide. For other countries, see Latin America company data by country.