Valve schedule importer
Upload a CSV or Excel file to build a BOM and add items to your cart
Drop your valve schedule here
Supports .csv, .xlsx, .xls
Choose a match
How it works
How it works
1. Upload. Drag your .csv, .xlsx or .xls file onto the upload box, or click Browse files. Not sure how to set it up? Download a sample file and paste your rows in.
2. Map columns. Choose "Part or assembly number" if each row has one part number, or "Separate valve and actuator" if they're in two columns. We pre-select your columns; check them against the preview and click Look up products.
3. Review. Each row shows its matched product, your price and stock status. Rows marked as needing attention have a fix on the row: Confirm match, Did you mean, Choose alternative or Search manually.
4. Add to cart. Click Add to cart to add every ready row with its tag, clip setting, setup position and notes. Unresolved rows are left out, so nothing is ordered by mistake.
Setting up your file
Setting up your file
Put your column headers in the first row of the first sheet, with one part per row below. If your schedule has a title block above the headers, delete those rows before uploading.
- Part Number (required): the full part or assembly number, such as Z2050QPT-B+CQB24-SR-R. Or use two columns: Valve Part Number and Actuator Part Number, such as B212 and TFRB24-SR.
- Quantity (required): a whole number, such as 2.
- Tag (optional, Belimo only): the engraving tag, up to 20 characters, such as CHW-1-1.
- Clip (optional, Belimo only): the clip setting, such as 4+. Leave it blank for no clip.
- Setup Position (optional, Belimo only): setup notes such as NO/FO.
- Notes (optional): anything else for that line, up to 200 characters.
Easiest start: download the part/assembly sample or the valve + actuator sample from the upload box and paste your rows in.