How-to · 26 Oct
How-to · 3 min read
How to move your Excel price list into a quoting tool
Contractors, suppliers and shops who keep their prices in an Excel sheet often retype the same items into every new quotation by hand. The sheet has years of materials, labor rates and item codes in it, and it is the one file nobody wants to touch. Every quote means opening it, finding the row, copying the price and hoping it is the current one. You want those prices to live somewhere that fills them in for you, without rebuilding the list from zero.
01
Why it's hard
Most quoting tools expect you to add products one at a time, which is fine for twenty items and hopeless for two thousand. Bulk imports in other tools often run blind, so a column that slipped by one place quietly writes unit prices into the quantity field and you only find out when a customer questions a total. Spreadsheets also drift, because each estimator keeps a slightly different copy and nobody is sure which one has the new supplier rates. And once you overwrite an old price, there is no record of what you charged last year.
This part describes the usual way. It makes no claims about BEQ — Build Estimate Quote, so nothing is quoted here.
02
How BEQ — Build Estimate Quote does it
BEQ lets you upload the Excel or CSV file you already maintain and turn it into a reusable price library. Before anything is saved, it shows which items will be added and which existing items will be updated, so you confirm the changes instead of trusting a blind import. Each import takes up to 5,000 rows, and when an imported price changes an existing item, the old price stays in the price history. From then on you pick items from the library when building an estimate, and the prices are already there.
03
Step by step
- 1Download the official template and match your sheet's columns to it.
- 2Clean up the file: one row per item, with unit, cost price and item code.
- 3Upload the .xlsx, .xls or CSV file from your computer.
- 4Read the preview of new and updated items, and fix the sheet if a column looks wrong.
- 5Confirm the import, then build your next estimate by selecting items from the library.
- 6When supplier rates change, upload the updated file again rather than editing items one by one.
04
Tips
Start from the template rather than your own layout. Matching the expected columns first saves you from fixing a long preview full of misread fields.
Download the official template if you want to match the expected columns.Quoted from beq.ae
If your list is longer than one import allows, split it by trade or category, for example electrical in one file and finishes in another. Smaller files are also easier to check in the preview, and a mistake in one trade does not hold up the rest of your list.
Up to 5,000 rows per importQuoted from beq.ae
Pick one person to own the master file after the first import. Once the library is in BEQ, a fix to one item updates it everywhere it is used, so the old habit of private spreadsheet copies can stop.
Edit an item once and it is corrected everywhere it is used.Quoted from beq.ae
Keep cost prices in the library even if you never show them. Your internal costs feed the estimate, while the customer only sees the finished quotation, so an honest cost column does not leak your margin.
Your customers see the quotation, not your cost breakdownQuoted from beq.ae
05
Questions
Which file types can I import?
Excel (.xlsx and .xls) and CSV files. You upload them from your computer.
Upload an Excel (.xlsx, .xls) or CSV fileQuoted from beq.ae
Will an import overwrite my old prices without a trace?
No. When an imported price changes an existing item, the earlier price is kept in the price history.
Price history is kept whenever an imported price changes an existing item.Quoted from beq.ae
Can I try it before paying?
Yes. Creating an account is free and includes one free quotation PDF download, and a subscription covers further PDF downloads.
Every new account gets exactly one free quotation PDF downloadQuoted from beq.ae