Important legal & practical note:
Free databases are generally outdated , incomplete , or limited to basic data (name, city, sector). For complete financials, legal representatives, or shareholders, you need paid sources (e.g., Datacrédito Experian, Información y Tecnología S.A. (ITSA), EMIS).
Portal Nacional de Datos Abiertos
For those looking for historical or statistical data without the requirement of being a registered merchant, the is the premier destination.
Excel file with many companies
If you need a real , you can legally create one by aggregating public searches:
- Hacer una limpieza inicial: eliminar duplicados, normalizar nombres y corregir formatos de teléfono.
- Validar una muestra (10–20%) por llamadas o email antes de campañas masivas.
- Enriquecer con fuentes adicionales (LinkedIn, websites corporativos) para mejorar emails y cargos.
- Usar filtros por ciudad y CIIU para segmentación eficaz.
- Registrar la fecha de descarga y mantener un plan de actualización periódico.
CIIU codes
for a specific industry to help you filter your search. Excel templates to organize the data once you download it.
The Catch
: These are often "bait" versions of larger paid databases. They are useful for small, one-off projects but lack the verification found in official RUES downloads.
' Sample Excel VBA to query DIAN public RUT (basic example) Sub GetCompanyName() Dim nit As String nit = "800.123.456-7" ' example ' Use XMLHTTP to request the public page and parse HTML ' Then write response to cell End Sub