The Scenario
Your agency is going live on Lexoffice next week. Contracts are signed, contacts are migrated, the chart of accounts is set up. The last remaining gap: the service catalog. All 60 billable services — consulting tiers, design packages, development sprints, QA retainers — live in an Excel workbook that your old billing tool used as its source. Until those articles are in Lexoffice, no invoice can reference a catalog item. The launch is in five days.
The bad version:
- Open Lexoffice, navigate to Products and Services, click Add Article, enter the title, choose SERVICE, enter the net price, pick the VAT rate — and repeat for all 60 rows
- Discover after 25 entries that you've been reading prices from the wrong column — the workbook has both gross and net prices and you've been entering the gross amounts, which will produce incorrect invoices
- Fix the 25 wrong entries, finish the remaining 35, and realize the launch has been delayed two days because the catalog wasn't ready in time
The service catalog is the only thing standing between you and the first invoice.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the service catalog and creates each Lexoffice article from the row data — no form fatigue, no column confusion.
Open the service catalog workbook and type:
Create a Lexoffice article for each row in this workbook using column A (title), B (type: PRODUCT or SERVICE), C (net price), D (VAT rate)
What You Get
- A Lexoffice article created for each row, with the correct type, net price, and VAT rate applied
- The Lexoffice article ID written back into column E for each successful creation
- Error notes for any rows that failed — so you know which ones to investigate before the launch date
What If the Data Is Not Quite Ready
All rows are services and the workbook has no type column
Create a Lexoffice article for each row using title in column A, net price in column B, and VAT rate in column C — set the type to SERVICE for all rows
Prices in the workbook are gross and Lexoffice requires net
For each row, calculate the net price from the gross in column C using the VAT rate in column D, then create a Lexoffice SERVICE article using title in column A and the calculated net price
Only active catalog rows should be imported
Add all rows where Catalog in column E is "active" as Lexoffice service articles using title in column A, net price in column B, and VAT rate in column C
Full catalog migration in one shot
In this workbook: skip rows where Catalog in column E is "inactive", convert gross prices in column C to net using VAT rate in column D, then create a Lexoffice article for each remaining row using title in column A, the normalized net price, and VAT rate — write the resulting article ID into column F
One prompt migrates the entire catalog before the launch deadline.
Try It
Get the 7-day free trial of SheetXAI and open the service catalog workbook — ask it to populate the Lexoffice article catalog and you can send the first invoice on day one. You can also look at how to bulk-create invoices from the billing workbook, or return to the full Lexoffice integration overview.