Muchas Cámaras de Comercio locales (Bogotá, Medellín, Cali, Barranquilla) ofrecen consultas masivas gratuitas en sus sedes virtuales.
| Column | Why it matters | |--------|----------------| | NIT | Primary key for linking data | | Razón Social | Legal company name | | Estado (Activa/Inactiva) | Avoid defunct companies | | CIIU Code | Industry classification | | Representante Legal | Best feature as explained | | Fecha de Constitución | Company age | | Capital Suscrito | Financial size estimate | base de datos de empresas gratis en excel colombia best
| Feature | Free (this guide) | Paid (Informa/Datacrédito) | |---------|------------------|----------------------------| | Bulk download | Partial (SECOP only) | Yes, full census | | Phone/email | Rarely included | Often included | | Financials | No (except SuperSociedades) | Yes | | Ultimate beneficiaries | Limited | Yes | Paste into Excel template (columns below)
For a small list (<200 companies), do manually: | Source | Data Available | Limitation |
| Source | Data Available | Limitation | |--------|----------------|-------------| | RUES – Cámara de Comercio (Single search) | Legal name, NIT, address, legal rep, status, economic activity | One by one (no bulk download) | | SIREM – DIAN | Tax status, NIT, name, address | No direct bulk, but can scrape/search | | SuperSociedades | Large companies financial data, registration | Only for supervised entities | | Datos.gov.co | Some public datasets (e.g., contractors, beneficiaries) | Not a full company census | | Transparencia Económica | Ultimate beneficiaries (partial) | Limited coverage |