Spreadsheet mode lets you use an Excel, LibreOffice, or OpenDocument worksheet as the calculation engine behind the product. The plugin reads the mapped cells and applies the same logic on the product page.

Create a spreadsheet-based calculator

1. Create or open the WooCommerce product where the calculator will be used.
2. Open YourPlugins > Spreadsheet Calculator and create a new calculator.
3. Save the calculator once so the spreadsheet workspace can attach a file to it.
4. In the Fields tab, create the input and output fields you want to use.
5. In the Formula/Mapping tab, set Type = Spreadsheet.
6. Upload your xls, xlsx, or ods file.
7. Select the worksheet you want to use.
8. Map the relevant cells from the worksheet canvas.
9. If needed, map output fields to WooCommerce quantity and dimensions.
10. Assign products and categories in the Products tab.
11. Use the Preview tab to test the calculator before publishing.
12. Save the calculator.

Available mapping targets

• Input field: connects a worksheet cell to a customer input field.
• Output field: exposes the value of a worksheet cell on the frontend or in cart/order data. The product price is also a default output target.
• Error cell: if the mapped cell is not empty, the calculator shows an error for the related input field.
• Base price input: injects the WooCommerce product base price into the worksheet.
• Tax rate input: injects the WooCommerce tax rate so the worksheet can use it in its own formulas.
• SKU input: injects the WooCommerce product SKU for product-specific spreadsheet logic.

WooCommerce product mapping

When a worksheet output should update WooCommerce product data, use the WooCommerce Product Mapping section in the same tab. From there you can connect mapped output fields to:

• product quantity
• product weight
• product length
• product width
• product height