The Scenario
You're the accountant setting up Zoho Books for a new client. The old billing system export has 150 service items — name, description, rate, tax identifier, and account code — sitting in an Excel workbook. The client needs to start invoicing on Monday. It's Friday morning.
The client asked if you could have the items in by end of today. You told them probably. You're now looking at 150 rows and doing the mental arithmetic on how long it will take to enter them manually.
The bad version:
- Open Zoho Books, navigate to Items, click New Item.
- Enter the name, description, rate, select the tax from the dropdown, select the account from the dropdown.
- Save. Open the workbook, find row 2, check the values, go back to Zoho Books.
- At item 40, realise the tax ID in column D doesn't match the tax name in Zoho Books and you need to build a translation table before you can continue.
One hundred and fifty service items. Five fields each. The dropdown for tax involves scrolling through a list every time. "Probably" is starting to feel optimistic.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the product list and creates every item in Zoho Books directly — skipping duplicates, writing the returned item ID back to column F.
Bulk-create 150 service items in Zoho Books from my Excel product list using the column headers as field names; skip duplicates and flag them in column G
What You Get
- 150 service items created in Zoho Books.
- Returned item ID written into column F for each successfully created row.
- Duplicate detection: existing items are skipped and flagged DUPLICATE in column G.
- Rows with missing names skipped and flagged in column G.
What If the Data Is Not Quite Ready
The tax column contains tax names, not Zoho Books tax IDs
Bulk-create Zoho Books items from this workbook; look up each tax name in column D against the Zoho Books tax list to get the tax ID before creating; write item ID into column F and the resolved tax ID into column D
Some duplicates should be updated rather than skipped
For each row in this workbook, check if a Zoho Books item with the same name already exists; if it does, update the rate and description rather than creating a duplicate; write item ID into column F and CREATED or UPDATED into column G
The account codes in column E are account names
Bulk-create Zoho Books items from this workbook; look up each account name in column E in the Zoho Books chart of accounts to resolve the account code before creating; write item ID into column F
Full legacy catalogue migration in one shot
For each row in this workbook, look up the tax name in column D in the Zoho Books tax list, look up the account name in column E in the chart of accounts, then create or update the item using name from column A, description from column B, and rate from column C; write item ID into column F, CREATED or UPDATED into column G, and flag any lookup failure in column H
The pattern: ask for both lookups, the upsert logic, and the error flags in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your product-catalogue Excel workbook, then ask it to seed all 150 service items into Zoho Books before the client starts invoicing Monday. See also how to bulk-create invoices from a billing schedule or return to the Zoho Books integration overview.