Skip to main content
The Excel Import feature is restricted to ADMIN and OPERADOR roles. If you have the NOC role, the “Importación Excel” menu item will not appear in the sidebar.

​
Overview

The Import module at /importacion lets you upload an .xlsx or .xls workbook and verify that it contains the columns ICP System requires before ingesting the data. The system scans every sheet in the workbook and identifies the first one that contains all required columns.

​
Workflow

1

Select a file

Click Seleccionar archivo. A file-picker dialog opens filtered to .xlsx and .xls files. Selecting a file clears any previous results or errors from the page.
2

Upload and validate

After a file appears on the page, click Cargar y Listar Columnas. The button is disabled until a file is selected. A spinner replaces the button label while the upload is in progress.
3

Sheet scan

The backend receives the workbook and returns every sheet’s column list. The frontend then iterates through the sheets and checks whether each one contains every column in the required list.
4

Result

  • If a valid sheet is found, the page displays that sheet’s name and renders a scrollable table listing its columns with an index number next to each one.
  • If no sheet passes validation, an error banner appears: “No se encontró ninguna hoja con todas las columnas requeridas”.
Only the first sheet that satisfies all required columns is processed. If your workbook has multiple sheets that could match, make sure the intended sheet appears first in tab order.

​
Required Columns

Your workbook must contain a sheet with all of the following column names. Column names are matched exactly (case-sensitive, including accented characters):
Column names must match exactly, including spaces and accent marks. OBSERVACIÓN (with accent) and OBSERVACION (without) are treated as different values.

​
API Endpoint

The page calls the import service via a multipart/form-data POST:

​
Response format

The backend returns a dictionary keyed by sheet name. Each value is an array of ColumnaExcel objects:
Example response:
In this example, DATOS ENLACES contains all required columns and would be selected as the valid sheet; Resumen would be skipped.

​
Row Data Endpoint

A second endpoint returns the actual row data from the valid sheet after validation:
Each row in the response maps directly to the FilaHoja type:
The response wraps the rows in an envelope: