Upd — Base De Datos De Empresas Gratis En Excel Colombia

The primary way to obtain a free, official, and updated (2026) database of companies in is through the RUES (Registro Único Empresarial y Social)

portal and regional Chambers of Commerce. Currently, there are over 1.5 million registered companies

available for public access in formats compatible with Excel. 1. Official Free Download Sources

The following official government and chamber sources provide the most reliable data without cost: RUES (National Portal)

: Offers a public database of companies with active and current mercantile registration. Data includes NIT, representative name, company type, size, and economic activity. Datos Abiertos Colombia base de datos de empresas gratis en excel colombia upd

: The national open data portal contains specific datasets like Empresas registradas Base de Datos PYMES

(updated as of December 2025) which can be opened directly in Excel via OData. Chamber of Commerce of Bogotá (CCB) : Provides a Business Database Online

tool to segment by activity, city, and size, allowing for the download of commercial and financial information. Chamber of Commerce of Medellín (Antioquia) : Features a dedicated section for Bases de datos sin costo (free databases) accessible through their services menu. Datos Abiertos Colombia 2. Step-by-Step: How to Download from RUES

To get the most current 2026 data for free, follow this general procedure through the Chamber of Commerce portals: Access the Portal : Go to the Chamber of Commerce of Medellín services page. Authentication The primary way to obtain a free, official,

: Enter your identification number and agree to data treatment policies. A security token is usually sent to your registered email or phone. Apply Filters : You can filter by

Department, Municipality, Size (Micro, Small, Medium, Large), Economic Activity (CIIU) , and registration dates. : Once filtered, select the Excel (XLSX) format and click " Descargar detalle de la consulta 3. Comparison of Free vs. Paid Options

While free databases are extensive, they often lack direct contact emails to prevent spam. Free (RUES/Open Data) Paid (InfoDatos/eInforma) Variable (e.g., $155 - $355) Data Types NIT, Name, Legal Rep, Activity Verified Emails, Cellphones, Financials Excel (via filters/OData) Excel (Full direct download) Periodic / Live Portal Monthly updates (2026 versions available) 4. Top Companies (Context for Data Verification)

When auditing a downloaded database, you can verify its accuracy by checking for major entities often featured in 2026 rankings: Datos Abiertos Colombia Where These "Free" Databases Usually Come From

I’m unable to generate a full “deep report” with live Excel files or real-time database dumps, but I can give you a structured, actionable guide to free company databases in Colombia that you can export to Excel, along with reliable sources and update cycles.

Where These "Free" Databases Usually Come From

1. RUES (Registro Único Empresarial) Scrapes: Some creators scrape public data from the Chambers of Commerce (Cámaras de Comercio). The problem? They almost never include email addresses or direct phone numbers. You get legal names, city, and legal rep names (useful for cold calling, but not updated weekly).
2. Government Portals (SIREM, MUISCA, RUCOM): Data from Dian or Supersociedades is free but structured for audits, not marketing. Converting it to a clean Excel sheet requires heavy cleaning (merging duplicates, removing liquidated companies).
3. "UPD" (Updated) – The Lie: Most free files circulating on Telegram, Google Drive, or Facebook groups have a date of creation, not update. You will often see "Actualizado Marzo 2024" when the file was actually last modified in 2022. There is no free, automated system updating these daily.

B. SECOP II (Sistema Electrónico de Compras Públicas)

Si buscas empresas B2B (Business to Business) que venden al gobierno, esta es la fuente definitiva.

• Qué encontrar: Todas las empresas que han ganado contratos con el Estado.
• Cómo usarlo:
  1. Entra a colombiacompra.gov.co.
  2. Ve a la sección de "Datos Abiertos" o utiliza el portal de "SECOP II - Explorador".
  3. Puedes filtrar por fecha (2023-2024), categoría (tecnología, construcción, etc.) y descargar el listado de proveedores en Excel. Esta es una base de datos de "compradores activos" muy valiosa.

2. What to Expect from “Free” – Realistic Scope

A genuinely free, ready-made Excel file with 500,000+ clean Colombian company records does not exist legally from a single source. However, you can assemble or obtain useful free datasets from the following official and semi-official channels:

| Source | Typical Data Included | Update Frequency | Excel Available? | Best For | |--------|----------------------|------------------|------------------|-----------| | RUES (Registro Único Empresarial) – via Cámaras de Comercio | Company name, NIT, legal rep, address, economic activity (CIIU), incorporation date, status | Daily, but free downloads limited | No direct – requires scraping or paid bulk request | Legal verification, due diligence | | SIREM (Sistema de Información de Registro de Empresarios) – Supersociedades | Larger corporations, financial data, board members | Annual | No – but you can export search results | Corporate governance analysis | | Datos Abiertos Colombia (www.datos.gov.co) | Registered companies, some with location and CIIU codes | Monthly/quarterly | Yes (CSV → Excel) | Free, official, structured | | Confecámaras open data | Aggregated RUES extracts | Semi-annual | Yes (limited columns) | Regional analysis, counts by sector | | Scraped public lists (e.g., Proveedores Red Clips, SECOP II suppliers) | NIT, business name, contact (sometimes) | Varies – often outdated | User-generated – often sold as “free sample” | Niche B2B leads |

Current update (2026): The most reliable free Excel data comes from Datos Abiertos Colombia and Confecámaras – both are legal, updated at least quarterly, and offered in open formats.

1. RUES (Registro Único Empresarial y Social) – Cámaras de Comercio

Este es el santuario de los datos empresariales. Las Cámaras de Comercio (Bogotá, Medellín, Cali, etc.) tienen buscadores públicos.

• Cómo obtener el Excel: Usa el servicio de Descarga masiva de certificados o el Visor RUES. Aunque la descarga directa de 1 millón de registros no es gratuita, el visor público sí te permite filtrar y copiar resultados (hasta 1.000 registros por búsqueda).
• Truco UPD: Busca empresas que hayan renovado su matrícula en los últimos 60 días. Eso garantiza que los datos (teléfono, correo, dirección) están recién validados.
• Link clave: www.rues.org.co