AI-assisted Price Book Import

Bring the price book you already use

Your Excel spreadsheet, turned into a pricing template

You spent years getting your pricing spreadsheet right. Upload it, and Ardovia's AI reads every sheet — formulas included — and drafts a complete pricing template: catalog items, sections, inputs, and translated formulas. You review each step, and nothing is created until you say so.

Book a Demo
Pricing / Templates / Price Book Import
2
3
4
5
6

Pool Pricing 2026.xlsx

5 sheets · 447 rows · 304 formulas

Gunite CalcCalculator
EquipmentPrice list
Tile & CopingOptions
RatesLookup table
2024 Prices (old)Outdated

Notes for the AI

Markup is applied on the Rates tab. Skip the 2024 sheet.

Analyzing is freeExtract template

Six steps from spreadsheet to template

The AI does the heavy lifting. You check every step.

1
You

Upload

Drop in the workbook you price from today — .xlsx, .xlsm, .xlsb, .xls, or .csv.

2
You + AI

Analyze

Every sheet is classified. Switch off outputs or old tabs and add notes about how it works.

3
AI

Extract

AI drafts your catalog, sections, inputs, and translated formulas from the live workbook.

4
You

Catalog

Check prices, merge duplicates, and match rows to items you already have.

5
You

Structure

Review each section, object, and formula before anything is saved.

6
Ardovia

Build

Your template is created as a Draft, ready to test before your team ever sees it.

Formulas, not just prices

Your calculations come with it

Most imports stop at a list of items and prices. Ardovia reads the logic too: the calculator that turns a pool's size into cubic yards, the lookup table of tiered rates, the cross-sheet references to your markup tab. Each one becomes an input, a calculated value, or a product quantity formula in your template — with the source cell shown so you can check it.

  • Excel formulas translated into template formulas
  • Size- and quantity-driven calculators become inputs
  • Tiered and lookup-table rates carried over as logic
  • Source cell and confidence shown on every item
Price Book Import / Structure
5
6
Shell› GuniteHigh confidence

From your spreadsheet · Gunite Calc!F12

=ROUNDUP((B4*B5+B6)*B8/27, 0)

In your template

ceil(({surfaceArea} * {wallFactor} + {floorArea}) * {shellThickness} / 27)

6

Inputs

4

Calculated

9

Products

You stay in control

The AI drafts. You decide.

Review the catalog before a single item is saved: check prices, merge duplicates, and match rows to products you already carry. Then walk through each section, object, and formula. The finished template lands as a Draft, so you can test it on a real job before your team ever quotes from it.

  • Existing catalog items flagged to avoid duplicates
  • Edit, merge, or leave out any row
  • Created as a Draft — publish when you're ready
  • Leave and come back; progress is saved in Import history
Price Book Import / Catalog
4
5
6

Variable-speed pump 1.5 HP

Equipment!B14

Matches existing

Cartridge filter 420 sq ft

Equipment!B19

New item

Waterline tile (per LF)

Tile & Coping!C6

New item

Travertine coping (per LF)

Tile & Coping!C21

Possible duplicate
Edit prices, merge duplicates, or match rows to items you already have.

What it understands

Works with simple price lists and complex, multi-sheet calculators.

Price lists

Item, cost, and price columns become catalog items.

Calculators

Size- and quantity-driven sheets become inputs and formulas.

Lookup tables

Tiered and size-based rates carry over as formula logic.

Options & upgrades

Pick-one choices like finishes and equipment become selections.

Your existing catalog

Items you already have are flagged, so you don't create duplicates.

Multiple sheets

Each tab is read in context, including cross-sheet references.

No spreadsheet? No problem

Or start from an industry demo template

Your first visit to Pricing Templates offers three ways to start. If you don't price from a spreadsheet, begin with a complete, working demo template built by Ardovia for your industry and match its products and selections to your own. It's available for pool builders today — a gunite and shotcrete template — with more industries coming. Or start from scratch with the template builder.

  • Demo templates for pool builders, more industries coming
  • Swap in your own products, selections, and phases
  • Created as a Draft you can re-price before publishing
Explore the Pricing Tool
Pricing / Templates

Set up your first pricing template

Pick how you want to start. You can always add more later.

Import my Excel price book

AI drafts a template from the workbook you use today.

Recommended

Start from an Ardovia demo

A complete, working template for your industry.

Pool builders

Start from scratch

Build sections, inputs, and formulas yourself.

Frequently asked questions

What file types can I upload?

Excel workbooks (.xlsx, .xlsm, .xlsb, .xls) and .csv files. Upload the live workbook you price from rather than a copy with values pasted over, because the import reads your formulas directly.

What does the import create?

A complete pricing template: catalog items, selections, sections and objects, inputs, calculated values, and products with quantity formulas translated from your spreadsheet. It also adds standard Miscellaneous, Allowances, and Discounts objects and a proposal and contract layout you can edit.

Will it publish anything without me checking?

No. The AI drafts and you decide. You review the sheets, then every catalog item, section, and formula, with the source cell shown for each. The finished template is created as a Draft, so your team never sees it until you test it and publish.

What if an item is already in my catalog?

The Catalog step flags rows that match items you already have, so you can link them instead of creating duplicates, merge duplicates within the workbook, edit prices, or leave rows out.

How much does it cost?

Each account's first 10 imports are free, and you don't need to turn anything on to use them. After that, someone with billing access turns on Price Book Import under Billing → AI Tools, and each import is a flat $20, whatever the size of the spreadsheet, billed on your next monthly invoice. Analyzing a workbook is always free; you're only charged when an extraction finishes.

What if I don't have a spreadsheet?

Start from an Ardovia demo pricing template built for your industry — pool builders get a complete gunite and shotcrete template, with more industries coming — and match its products and selections to your own. Or build a template from scratch with the template builder.

Your price book, ready to quote from

Upload the spreadsheet you price from today and review a working pricing template in minutes.

Book a Demo

14-day free trial • Cancel anytime