Docs  /  Pricing & Rules  /  Price Matrices from Excel/CSV

Price Matrices from Excel/CSV

Last updated: 01. January 2026

If your prices are in tabular form — e.g. width × height = price — you can import them directly as a CSV file. The configurator automatically reads the matching price from the table.

When Does a Price Matrix Make Sense?

Price matrices are ideal when your prices depend on two or more dimensions and cannot easily be expressed as a formula:

  • Sun protection / roller blinds: price depending on width × height
  • Windows & doors: price depending on width × height × frame material
  • Textile printing: price depending on quantity × format
  • Cut-to-size products: price depending on length × width

Preparing the File Format

CSV format

;80;100;120;140;160
100;29.90;34.90;39.90;44.90;49.90
120;34.90;39.90;44.90;49.90;54.90
140;39.90;44.90;49.90;54.90;59.90
160;44.90;49.90;54.90;59.90;64.90
  • First row: values of feature 2 (e.g. width)
  • First column: values of feature 1 (e.g. height)
  • Cells: prices

Importing a Price Matrix

Price lists appear as their own Price Lists section at the bottom of the structure tree in the left panel (Features tab). All matrices are listed there with the type Matrix.

Manually:

  1. Open the Price Lists section in the structure tree
  2. Add new price list
  3. Upload CSV
  4. Set the assignment: which feature represents the columns, which the rows?
  5. Save

Via AI agent: Open the AI assistant (+ New Chat bottom right) and upload the CSV directly in the chat:

"Here is my price list. Columns are the width in cm, rows are the height in cm."

The agent imports the table and assigns the features automatically.

Interpolation

If a customer enters a value not exactly in the table (e.g. width 95 cm, table only has 90 and 100), configento.app automatically calculates the price using linear interpolation.

Multiple Price Lists

You can store multiple price lists per component — e.g. one base price matrix and one fixed price list for accessories. In the structure tree all appear as separate entries in the Price Lists section.

Next Steps


← All articles Try free for 14 days