Work with Excel in DECA ERP

Choose between the available tools with no integration fee, or connect your workbook directly to DECA ERP through a tailored API integration.

View free option View direct integration

Two ways to work with Excel

The difference is whether you use existing features or need your own workbook to send and receive data automatically.

No integration fee

Browser or free desktop application

In the browser, you can import supported Excel/CSV files for customers, drivers and vehicles, then create DeCA documents in the web app. You can also use DECA Autoentrada on Windows to process emails with Excel attachments and create documents when the data follows a recognisable format.

Integration: €0. No custom workbook adaptation is needed. Access to DECA ERP is required; the subscription and optional third-party services are priced separately.

Open the web app View free desktop app

Direct integration · quoted separately

Your Excel workbook connected through the API

We adapt your delivery note or transport order to create and update DeCA documents from its own cells, then return the number, status, links and QR code to the workbook. No duplicate entry in the web app is needed.

Adaptation and setup carry an integration fee, based on the work required. The downloadable example lets you test the process but does not replace adapting your own workbook.

Request a quote View API example

Free browser imports do not turn every Excel workbook into a DeCA automatically. For direct sending from your own workbook, ask about API integration.

Direct API integration example

The workbook contains entirely fictional data and two working tabs: the transport order and the DeCA panel. The required VBA code is already included in the .xlsm file.

Download Excel demo View the complete API

Create from the worksheet

Reads the consignor, carrier, date, registrations, goods, weight, origin, destination and a second leg or transit point.

Update the same DeCA

After creation, subsequent operations update the same document while retaining its number, URLs and version history.

Results in Excel

Displays the company DeCA number, technical ID, status, public URL, private completion link and QR code.

Direct actions

Open the document, copy the QR code to the clipboard and unlink the workbook when preparing a new DeCA.

How to test it

Open the workbook

Download the Excel file and select Enable Content so that its macros can run.

Review the data

On ORDEN DE CARGA, enter a unique reference in cell A9 and change any fictional values you want to test.

Create the DeCA

Open the DECA tab and select Crear / actualizar DeCA. The panel displays the returned URLs and QR code.

Update or prepare another

Edit the order and save it again to create a version. For another document, use Desvincular / crear otro and enter a new reference.

Demo environment: the downloadable workbook is configured with the DEMO company API key. Records are shared within that test environment and must not contain real information.

Using it with a live company

The sample provides a technical starting point. For production use, the account holder replaces the demonstration key with their own API Key using Configurar acceso.

External reference

Each order must use a stable, unique reference. DECA ERP uses it to prevent duplicates and locate the document for later updates.

Authentication

The macro sends the API Key in the X-Api-Key HTTP header. The key identifies the company and isolates its documents from other account holders.

Traceability

Updates create versions in DECA ERP. The company number and public URL remain stable while the current content is updated.

Important: a live API Key is stored inside the workbook. Treat the file as confidential, restrict it to authorised users and never distribute a production-configured copy as a public template.

Adapting an existing Excel workbook

We can connect the delivery note, transport order or template that a company already uses. Adaptation is quoted separately because it depends on each workbook's cell layout, validations, worksheets and business rules.

Map cells and fields to the DeCA model.
Create and update documents without duplication.
Support one or more legs, origins, destinations and goods lines.
Write the DeCA number, URLs, status and QR code back into Excel.
Adapt buttons and messages to the customer's workflow.

Request an adaptation quote

Requirements

Microsoft Excel desktop for Windows with macros enabled.
Internet access and HTTPS connectivity to deca.netsistemas.com.
A unique reference for each transport order.
A test API Key or the account holder's live key.

Excel for the web and mobile apps do not run these macros. They can display the workbook, but creation and updates must be performed in desktop Excel.