The Scenario
Your new client hands you a CSV from their old CRM on a Wednesday afternoon: 80 customer contacts, all the names and emails and country codes in neat columns, none of them in Lexoffice yet. The first invoices need to go out Friday. You open Lexoffice, click into the contact creation form, and immediately do the math: if each entry takes two minutes, that's two and a half hours of clicking before you can even think about the invoices.
The bad version:
- Open Lexoffice, navigate to Contacts, click Create, enter company name, email, country code, and set customer role — repeat for all 80 rows
- Lose your place around row 35 when you get a Slack message, re-enter three rows you're not sure about, and spend ten minutes cross-checking against the sheet
- Discover on row 61 that the country codes in the sheet are ISO 3166-1 alpha-3 format and Lexoffice expects alpha-2, meaning you need to go back and fix half the records you already created
The client's first invoice run is 48 hours away. You do not have a spare afternoon to spend in a contact creation form — you need to be reviewing the billing amounts, not entering data.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the data, understands the columns, and through its built-in Lexoffice integration it creates the contacts for you. No switching tabs, no reformatting.
Open the sheet with the 80 contacts and type:
Create a Lexoffice customer contact for every row in this sheet using columns A (company name), B (email), C (country code)
What You Get
- A Lexoffice customer contact created for each row, with company name, email address, and country code mapped correctly
- A new column written back into the sheet — Lexoffice contact ID for every row that succeeded, an error message for any that failed (so you know exactly which ones to investigate)
- No manual form entry, no tab-switching, no losing your place
What If the Data Is Not Quite Ready
Country codes are in the wrong format
For each row in this sheet, convert the country code in column C from alpha-3 to alpha-2 format and write the result into column D, then create a Lexoffice customer contact using company name in A, email in B, and the corrected country code in D
Some rows are vendors, not customers
Create Lexoffice contacts for all rows in this sheet — use the Type in column D to set each one as customer or vendor, with company name in A, email in B, and country code in C
The sheet has duplicates — same company name appears twice
Before creating any contacts, flag all rows in this sheet where the company name in column A appears more than once, write "duplicate" in column E, then create Lexoffice customer contacts for the remaining unique rows only
You need to do the whole cleanup and import in one shot
In this sheet: flag any rows where column C is blank as "missing country" in column E, skip them, convert any alpha-3 country codes to alpha-2 for the remaining rows, and create a Lexoffice customer contact for each valid row using company name in A, email in B, and the corrected country code — write the resulting Lexoffice contact ID into column F
One prompt handles the normalization and the import together. No intermediate steps.
Try It
Get the 7-day free trial of SheetXAI and open the sheet with your customer or vendor list — then ask it to create the Lexoffice contacts in one pass. You can also look at how to bulk-create invoices from a project billing sheet, or return to the full Lexoffice integration overview.