Updated on 9 October 2026

Create companies in Ubyquo in bulk from Excel

Save time by creating several companies at once with an Excel template, also using data from Sage.

Ubyquo lets you create several companies in bulk using an Excel template, so you do not have to register each company individually.

If you use Sage

With Sage Despachos or Sage 200 you can get the company data directly from Sage and use it to prepare the Excel file (last section).

Part 1 Fill in the Excel template

  1. 1

    Download the template

  2. 2

    Fill it in

    Open the template, complete the required fields for each company you want to create and save the file.

Part 2 Create the companies in Ubyquo

  1. 3

    Open “Gestionar carpetas”

    Open Ubyquo and go to Gestionar carpetas (Manage folders).

    Manage folders option in Ubyquo
  2. 4

    Click “Creación masiva desde Excel”

    Click Creación masiva desde Excel (Bulk creation from Excel) and select Leer Excel (Read Excel).

    Bulk creation from Excel in Gestionar carpetas
  3. 5

    Choose the template

    Browse for and select the template you filled in.

  4. The folders are created

    Ubyquo automatically creates the folders for the companies included in the file.

Sage Get the data from Sage Despachos or Sage 200

  1. 1

    Export the companies from Sage

    Open Sage, go to Inicio > Empresas (Home > Companies), click Exportar a Excel (Export to Excel) and save the generated file.

    Home › Companies in Sage
  2. 2

    Remove the ones you do not need

    Open the Excel file and delete the rows of the companies you do not want to import.

  3. 3

    Add the “Ejercicio” column Required

    Add a column named Ejercicio (Fiscal year) and fill it in with the fiscal year for each company.

    If you do not add the Ejercicio column with its value, the company code will not be saved.

  4. 4

    Import it into Ubyquo

    Once the file is ready, use the Ubyquo Creación masiva desde Excel option to import the data (part 2).