Spreadsheet Calculator for WooCommerce lets you create product calculators that calculate the final WooCommerce price from customer inputs, formulas, or spreadsheet cells.
It is useful when a simple fixed price is not enough: made-to-measure products, printing products, custom cuts, configurable items, services, B2B products, or any product where customers enter dimensions, quantities, materials, or options before the final price is known.
Already using Excel or a spreadsheet to calculate quotes? This plugin helps you turn that pricing logic into a WooCommerce product calculator.
The workflow is simple:
- Create the fields your customer needs to fill in.
- Build a formula or map those fields to cells in a spreadsheet.
- Assign the calculator to a WooCommerce product.
- Let customers configure the product and add it to the cart with the calculated price.
The calculated price is used by WooCommerce in the cart, checkout and order details, so the store owner and customer can review the selected configuration after purchase.
This plugin is not affiliated with, endorsed by or sponsored by WooCommerce or Automattic.
What you can build with Spreadsheet Calculator:
- Create product calculator fields for numbers, text and picklists.
- Use formulas to calculate a WooCommerce product price.
- Upload a spreadsheet and map input and output cells.
- Show calculated results to customers on the product page.
- Assign a calculator to a WooCommerce product.
- Reorder fields so the product form is easy to follow.
- Mark fields as required and show clear validation messages.
- Keep customer selections visible in the cart, checkout, emails and order details.
- Review calculator values inside WooCommerce order screens.
- Show calculator data in WooCommerce Cart Blocks.
- Export and import calculator configurations when you need to move or back up a setup.
Example use cases:
- Online printing: flyers, labels, posters, banners and business cards.
- Made-to-measure products: panels, covers, furniture parts and custom cuts.
- Products priced by area, length, weight, quantity or material.
- Custom services that need customer inputs before the final price is known.
- B2B products where a spreadsheet is already used internally to calculate the quote.
Useful links:
- Plugin information: https://yourplugins.com/product/your-spreadsheet-calculator
- Documentation: https://yourplugins.com/your-spreadsheet-calculator-documentation
Development Source
The non-minified JavaScript source files for this release are available in this source archive:
https://yourplugins.com/wp-content/uploads/sources/yps-spreadsheet-calculator-3.0.6-source.zip
Build instructions:
- Run
npm install - Run
npm run build
Getting Started
- Choose a product that needs a calculated price.
- List the customer inputs needed to calculate that price, such as width, height, quantity, material or options.
- Create those inputs as calculator fields.
- Use a formula when the price rule is simple.
- Use spreadsheet mapping when your pricing table or quote logic is easier to maintain in a worksheet.
- Assign the calculator to a WooCommerce product and test it before publishing.
Screenshots
Spreadsheet pricing logic used to calculate a custom product quote.
Calculator fields for customer inputs such as dimensions, material and finishing.
Spreadsheet mapping between calculator fields and worksheet cells.
WooCommerce product assignment for the calculator.
Admin preview of the calculator with a calculated product price.
WooCommerce product page with calculator fields and calculated price.
Cart page showing the configured product and calculated total.
Checkout page with the configured product in the order summary.
Order received page with the calculated order total.
WooCommerce admin order screen with the submitted calculator values.