The Scenario
You're a digital goods seller setting up Quaderno for the first time. Your entire product catalog — 90 SKUs — is already in an Excel workbook from the previous billing system: column A is SKU, column B is product name, column C is unit price in USD, column D is the tax code. Before you can issue a single invoice in Quaderno, every product needs to exist in the system so it can be referenced by line item. You'd rather spend the afternoon configuring your first invoice template than creating products one at a time.
The bad version:
- Open Quaderno, click Products, click New, enter the SKU into the code field, type the product name, set the price, select the tax code from a dropdown, click Save, copy the returned product ID, switch back to the workbook, paste it into column E
- Repeat 89 more times
- Discover partway through that your tax codes don't match Quaderno's expected values — some of your rows say DIGITAL but Quaderno wants digital_goods_ebooks — and now you have to go back and fix the ones you've already created
You have a catalog to load, not a taxonomy to learn.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your product data and creates the Quaderno products for you.
Read all 90 product rows (SKU in A, name in B, price in C, currency in D) and create each as a Quaderno product, then paste the Quaderno product IDs back into column E
What You Get
- One Quaderno product is created per row using the SKU, name, price, and currency from that row
- The returned Quaderno product ID writes to column E as each product completes
- Products with unrecognized tax codes are flagged in column F rather than failing silently
- After the run, every SKU in the workbook maps to a Quaderno product ID in column E, ready for line item reference
What If the Data Is Not Quite Ready
The tax code column needs to be included — it's in column D and I have prices in column C
Create a Quaderno product for each row — SKU in A, name in B, price in C, tax code in D — write the product ID to column E
The tax codes in my workbook don't match Quaderno's taxonomy
For each row, map the tax code in column D to the closest Quaderno tax code (column D values are: DIGITAL, PHYSICAL, SERVICE), create the Quaderno product using SKU from A, name from B, price from C, and the mapped code — write the product ID to column E and the mapped tax code to column F
Some SKUs already exist in Quaderno and I don't want to create duplicates
For each row in this workbook, check if a Quaderno product already exists with the SKU in column A — if yes, write the existing product ID to column E and skip creation; if no, create the product using columns A through D and write the new ID to column E
Clean up tax codes, create all products, and flag any that need review in one pass
For each row: map the tax code in column D to a valid Quaderno code and update column D; then create the Quaderno product using SKU from A, name from B, price from C, and the corrected tax code — write the product ID to column E; if the mapping was ambiguous, write Needs Review to column F
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your product catalog lives, then ask it to push all 90 products into Quaderno before you start invoicing. Also see: bulk creating invoices from an Excel workbook, and the hub overview of all Quaderno connection methods.