Excel in GAEB
Convert Excel to GAEB
With GAEB-Online 2021 you can easily convert Excel© tables into GAEB files!
Many users create service specifications with Excel©. But what do you do if you need these data in a GAEB format? With GAEB-Online 2021, data from Excel© or OpenOffice can be converted into a GAEB format.
- Excel service specifications of architects and planners to be converted into GAEB D81 or GAEB D83.
- Excel product descriptions from construction product manufacturers to be converted into GAEB D81.
- Excel article lists in the building materials trade to be converted into GAEB D81 or GAEB D83.
- Excel calculations whose prices are to be converted into GAEB D84 as a quotation.
- Excel alternative offers that are to be converted into GAEB D85 as secondary offers, for example.
- Excel order confirmations that are to be converted into GAEB D86 orders, for example.
Excel© or OpenOffice©
GAEB-Online 2021 converts an Excel or OpenOffice table into a GAEB file and displays it as a GAEB XML file in X80 format. From there, the file can be saved via GAEB-Online 2021 in any other required GAEB format of the exchange phases D81 to D86, as GAEB 90, GAEB 2000 or GAEB DA XML.
Besides Excel©, files from OpenOffice or LibreOffice in *.ods format can of course also be converted into a GAEB format.
Simple conversionfrom Excel to GAEB
When converting data, the user is supported by an import assistant in GAEB-Online 2021. It allows to import the data from Excel© with different options in three steps. The conversion into the GAEB format is done automatically by GAEB-Online 2021.
Data from Excel©
The Excel file or OpenOffice file needs a fixed column structure. During installation, a sample Excel file is installed on your computer. You can simply use this sample file as a template for your data.
- Short text
- Long text
GAEB-Online 2021 supports the following structures and item types when converting from Excel©:
- Area groups
- Note texts
- Standard items
- Requirement items without BP
- Requirement items with BP
- Basic positions
- Optional/alternative items
Optionsfor the conversion
When converting from Excel to GAEB, GAEB-Online 2021 offers various options, such as renumbering the GAEB specifications after the import, defining unit price shares for the items of the specifications or defining time unitsand time approaches.
Datafor the conversion from Excel to GAEB
The conversion from Excel to GAEB can be done from different data formats.
- Excel© as of 2007 (*.xlsx)
- Excel© 93 to 2003 (*.xls)
- OpenOffice© (*.ods)
- LibreOffice (*.ods)
- CSV files (*.csv)
To save you a lot of time, an Excel sample file is installed on your computer when you install GAEB-Online 2021. With this file you can try out the functions and you can also use this sample file as a template file for your data. The file is available for Excel© in *.xlsx format and for Openoffice in *.ods format.
You can order GAEB-Online 2021 for only 95.20 EUROincl. VAT as a single user licence via a secure page directly here. The single user licence is bound to one computer via an activation key. The licence can be transferred by the user to another computer.
This offer is exclusively addressed to entrepreneurs, dealers or traders who are acting in the exercise of their commercial or self-employed activity when making the purchase.
If you have purchased a licence of the current software generation - currently GAEB-Online 2021 - all updates for this software generation are free of charge. If there is an upgrade to a new software generation, you can purchase it at a reduced upgrade price.The purchase process and the delivery of the products purchased by you are handled by MyCommerce Share-it - Digital River GmbH, Scheidtweilerstr. 4, 50933 Cologne. MyCommerce Share-it - Digital River GmbH is the seller and your contractual partner.