Free tool · GAEB converter

Convert Excel to GAEB

In goes an Excel or CSV table with item numbers, short texts, quantities and units, out comes a bill of quantities as GAEB X83 or X81. You map the columns, the converter builds the sections from the item numbers and marks every row it has a problem with.

Drop an Excel or CSV file here

orXLSX or CSV · up to 50 MB
  • Your files stay in your browser
  • Writes GAEB DA XML 3.3 to the official schemas
  • Free, no sign-up

How it works

How to convert Excel to GAEB

01

Download the Excel template or use your own sheet: one row per section and item, item numbers with dots (01.02.0010).

02

Drop the file into the converter and check the column mapping.

03

Fix the rows the preview marks as errors, for example duplicate item numbers or quantities that are not numbers.

04

Choose X83 or X81 and download the GAEB file.

What changes

What the sheet needs

Item number and a short or long text are required; quantity, unit and unit price are optional. Units have at most four characters in GAEB, so longer ones are shortened (Stück → St). An X83 holds no prices; unit prices are only written to an X81. Rows without an item number are added to the item above or become notes.

FAQ

Questions about converting GAEB files.

Open the sheet in the converter, check the column mapping and the preview, then download the X83 or X81. The converter writes GAEB DA XML 3.3.

One row per section and item with columns for item number, short text, long text, quantity, unit and, optionally, unit price. Rows with a shorter item number and no quantity become sections.

XLSX and CSV. Save old .xls files as .xlsx in Excel first.

The preview marks them with the reason. Errors such as duplicate item numbers stop the download until they are fixed; notes such as a shortened unit do not.

Yes, in an X81. An X83 is the bill of quantities without prices, so the converter leaves them out there and says so in its report.

Book a demo

See Mercura on

your own tenders.

Bring a real GAEB file. We’ll show you how Mercura reads it and matches every item to your catalog.

Book a demo

See Mercura on

your own tenders.

Bring a real GAEB file. We’ll show you how Mercura reads it and matches every item to your catalog.

Book a demo

See Mercura on

your own tenders.

Bring a real GAEB file. We’ll show you how Mercura reads it and matches every item to your catalog.