GAEB (.x83 / DA XML) to Excel (.xlsx) & JSON Converter – German Construction Tenders

Convert German construction tender files (GAEB DA XML 3.1, 3.2, 3.3 – .x83, .x81, .x84, .d83) into a clean, ready-to-calculate Excel spreadsheet (.xlsx) with pre-built formulas and structured JSON for n8n, Make.com, and ERP automation.

---

What Problem Does This Solve? (Deutsch & English)

In Germany, Austria, and Switzerland (DACH), construction companies, architects, civil engineers, and trades (Handwerk, SHK, Elektro, Rohbau, Trockenbau, Dachdecker) receive public and private invitations to tender (Ausschreibungen / Leistungsverzeichnisse) as cryptic .x83 GAEB files.

Without expensive legacy AVA software, you cannot open or calculate these files in Excel.

What This Actor Delivers in 2 Seconds:

1. Ready-to-Use Calculation Excel (GAEB_Kalkulation.xlsx):
   • Extracts all bill of quantities items (Ordnungszahl / OZ, Kurztext, Langtext, Menge, Einheit).
   • Automatically separates normal items (Normalpositionen) from contingency/optional items (Bedarfspositionen / Eventualpositionen) so optional items do not distort your net total!
   • Includes live Excel multiplication (Menge * Einheitspreis) and =SUM() formulas.
2. Structured JSON Output:
   • Perfect for automated tender analysis, AI pricing estimation, or ERP import via n8n, Make.com, or Zapier.

---

Ideal for n8n & Make.com Workflows

Connect your email inbox (IMAP / Outlook / Gmail): Whenever an architect or general contractor sends an email with a .x83 attachment, pass the XML content to this Actor and automatically send the finished Excel calculation sheet to your team via Email, Slack, Microsoft Teams, or OneDrive!

---

n8n Integration (Ready-to-Use Workflow)

You can import this complete workflow directly into your n8n instance. It includes a trigger, a sample GAEB XML test payload, and the HTTP Request node connected to this Apify Actor.

1. Copy the JSON code below.
2. Open n8n, click on Workflows -> Import from Clipboard (Strg + V).
3. Replace DEIN_APIFY_TOKEN_HIER_EINTRAGEN in the HTTP Request node with your personal Apify API Token (found in Settings -> Integrations).

{
  "name": "GAEB (.x83) Leistungsverzeichnis to Excel & JSON (via Apify)",
  "nodes": [
    {
      "parameters": {},
      "id": "2b3c4d5e-0002-0002-0002-000000000001",
      "name": "1. Klick auf Test Workflow",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [240, 300]
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "gaeb-field",
              "name": "gaebXmlContent",
              "value": "<?xml version=\"1.0\" encoding=\"UTF-8\"?><GAEB xmlns=\"http://www.gaeb.de/GAEB_DA_XML/DA83/3.3\"><PrjInfo><NamePrj>Sanierung Rathaus - Los Elektro</NamePrj><Cur>EUR</Cur></PrjInfo><Award><DP>83</DP><BoQ><BoQBody><BoQCtgy RNoPart=\"01\"><LblTx>Hauptverteilung</LblTx><BoQBody><Itemlist><Item RNoPart=\"0010\"><Qty>15.000</Qty><QU>St</QU><Description><CompleteText><OutlineText><OutlTxt><TextOutlTxt>FI/LS-Schutzschalter 16A B-Charakteristik</TextOutlTxt></OutlTxt></OutlineText></CompleteText></Description></Item></Itemlist></BoQBody></BoQCtgy></BoQBody></BoQ></Award></GAEB>",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "id": "2b3c4d5e-0002-0002-0002-000000000002",
      "name": "2. Beispiel GAEB X83 Datei",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [460, 300]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://api.apify.com/v2/acts/DACH_Automation_Tools~gaeb-x83-to-excel-json-converter/run-sync-get-dataset-items?token=DEIN_APIFY_TOKEN_HIER_EINTRAGEN",
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"gaebXmlContent\": {{ JSON.stringify($json.gaebXmlContent) }},\n  \"generateExcel\": true\n}",
        "options": {
          "timeout": 60000
        }
      },
      "id": "2b3c4d5e-0002-0002-0002-000000000003",
      "name": "3. Apify GAEB-zu-Excel Konverter",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [700, 300]
    }
  ],
  "connections": {
    "1. Klick auf Test Workflow": {
      "main": [
        [
          {
            "node": "2. Beispiel GAEB X83 Datei",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2. Beispiel GAEB X83 Datei": {
      "main": [
        [
          {
            "node": "3. Apify GAEB-zu-Excel Konverter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}