How to Create and Format a Product Database Excel File for MeasureSquare 8
How to Create a Product Database Excel File for MeasureSquare 8
This article explains how to format an Excel (.xlsx) file so that your product catalog imports correctly into MeasureSquare 8. The file uses separate sheets for each product type, and each row of data represents one product. Following the exact column structure and header comments described below is required for a successful import.
File Structure Overview
The Excel file must contain the following sheets, named exactly as shown:
Roll — Roll goods (carpet, sheet vinyl, etc.)
Tile — Tile products (ceramic, porcelain, LVT, etc.)
Wood — Plank products (hardwood, laminate, SPC, etc.)
Area — Area-measured materials and labor (underlayment, adhesive, etc.)
Linear — Linear products (transitions, wall base, stair nose, etc.)
Count — Count-based products (sold by unit/each)
General — General products (labor, miscellaneous services)
Volume — Volume-based products (grout, leveler, etc.)
add-on — Defines which add-on products (materials or labor) are automatically associated with a parent product
Important: Each sheet must have a header row in Row 1 with the exact column names listed below. Each column header must also carry the corresponding cell comment (the internal field mapping used during import). Every product entry occupies one row starting in Row 2.Column Header Comments
Each column header in Row 1 must have a cell comment containing the internal field mapping string. In Excel, right-click the header cell and select New Comment, then enter the comment text exactly as shown in the tables below. These comments tell MeasureSquare 8 how to map each column to its internal database field.
Sheet 1: Roll
Use this sheet for all roll goods products (roll carpet, sheet vinyl, etc.).
Required columns:
Notes specific to Roll:
Width and Length define the roll dimensions. Enter values with units (e.g., 3.66 M).
Width Margin and Length Margin define the cutting margins added to each seam/edge.
Horizontal Repeat, Horizontal Drop, Vertical Repeat, Vertical Drop define the pattern repeat dimensions. Enter 0.00 M for products with no pattern.
Roll goods do not use a BoxName or Units per Box column. Box pricing (BoxSalesPrice, BoxCostPrice) is used for roll goods sold by a fixed roll length.
Sheet 2: Tile
Use this sheet for tile products such as ceramic, porcelain, stone tile, and LVT.
Required columns:
Notes specific to Tile:
Calc Method controls how waste is calculated (e.g., Waste Add-on).
Tile Shape defines the tile geometry (e.g., Rectangle, Hexagon).
Waste Addon is a decimal representing the additional waste percentage (e.g., in the format 5.35%).
Minimum Waste sets the floor for calculated waste.
Width and Length are the tile face dimensions.
Sheet 3: Wood
Use this sheet for plank products such as hardwood, laminate, and LVP.
The Wood sheet contains all of the same columns as the Tile sheet, plus two additional columns for plank length range:
Required columns:
Note specific to Wood: MaxLength and MinLength define the range of plank lengths in a box for random-length plank products.
Sheet 4: Area
Use this sheet for products calculated by area that are not roll goods or tile — for example, underlayment, adhesive, and area-based labor.
Required columns:
Note specific to Area: IsAddon flags this product as an add-on item (enter Yes or No). Add-on products can be automatically linked to a parent product via the add-on sheet.
Sheet 5: Linear
Use this sheet for products measured by length: transitions, wall base, stair nose, reducer strips, etc.
Required columns:
Notes specific to Linear:
Width and Length define the strip dimensions (e.g., width of the transition piece and length of one piece).
No Piecing Together controls whether MeasureSquare 8 avoids joining multiple pieces end-to-end to fill a run (enter Yes or No).
Sheet 6: Count
Use this sheet for products sold by unit (each), such as floor vents, thresholds, or other discrete items.
The Count sheet uses the same columns as the Area sheet, with the same internal field prefix changed to CountProduct:
Required columns:
Sheet 7: General
Use this sheet for general products — most commonly labor services (installation, removal, etc.) and miscellaneous charges.
The General sheet is identical to the Area and Count sheets, with one additional column (BoxRounding) and the GeneralProduct field prefix:
Required columns:
Note specific to General products: BoxRounding controls whether the box quantity rounds up to the next whole box (enter Yes or No).
Sheet 8: Volume
Use this sheet for volume-based products such as grout, self-leveling compound, and similar materials sold by the gallon or bag.
The Volume sheet is identical to the Area and Count sheets, with one additional column (GroutCoverage) and the VolumeProduct field prefix:
Required columns:
Note specific to Volume: GroutCoverage defines the coverage rate of the product (e.g., how many square feet one unit covers), which MeasureSquare 8 uses to calculate the required quantity automatically.
Sheet 9: add-on
Use this sheet to define automatic add-on associations — for example, specifying that every carpet product should automatically include a pad, or that every laminate product should include foam underlayment.
This sheet does not use a standard header row. Instead, each association is entered as a pair of rows:
Column A — Enter the No./SKU of the parent product (the primary flooring material).
Column B (next row, same group) — Enter the No./SKU of the add-on product to associate.
Column C (same row as Column B) — Enter the quantity method (e.g., Original Quantity).
Example layout:
Notes:
A parent product can have multiple add-on rows (one per add-on product). List each add-on on its own row beneath the parent SKU row.
The add-on product referenced in Column B must exist in one of the other sheets (Area, Linear, Count, General, or Volume) in the same file.
Original Quantity is the most common quantity method and instructs MeasureSquare 8 to calculate the add-on quantity using the same area/length as the parent product.
Common Column Reference
The following columns appear on most or all sheets and behave the same way regardless of product type:
No./SKU — Unique product identifier. Must be unique within the file.
Color — Display color swatch (optional).
Path — Category path used to organize products in the MeasureSquare 8 product catalog. Use backslashes to define subfolders (e.g., Carpet\Broadloom).
Type — Product type label (e.g., Carpet, Tile, Labor).
Description — Optional product description displayed on estimates and worksheets.
Trade — Trade category (e.g., Carpet, Tile, HardWood, Labor).
Unit — Unit of measure (e.g., SY, SF, LF, EA, Gal).
SalesPrice / CostPrice — Per-unit sell price and cost.
BoxSalesPrice / BoxCostPrice — Per-box sell price and cost.
IsBoxPricesLinked — Enter Yes if box prices should stay linked proportionally to unit prices; otherwise No.
BoxName — Label for the box (e.g., Box, Carton, Bundle).
Units per Box — Number of units in one box (e.g., number of tiles or planks).
SellByBox — Enter Yes to sell this product in whole-box increments only; otherwise No.
WorksheetByBox — Enter Yes to display box quantities on the worksheet; otherwise No.
IsTaxable — Enter Yes if the product is subject to sales tax; otherwise No.
IsAddon — Enter Yes if this product is an add-on item that can be linked to a primary product; otherwise No. (Not present on Roll sheet.)
Vendor — Vendor/distributor name.
VendorSku — Vendor's SKU or item number for this product.
Manufacturer — Manufacturer or brand name.
Cost Code — Accounting cost code.
Style Code — Manufacturer's style code.
Style Name — Manufacturer's style name.
Color Code — Manufacturer's color code.
Color Name — Manufacturer's color name.
Note: If you need further assistance, contact MeasureSquare Customer Support at +1-626-683-9188 select Option 3, or email support@measuresquare.com.
Related Articles
How to export product database to an Excel file in MeasureSquare 8?
This article will explain how to export your product database from your MeasureSquare 8 software to an Excel file format. This article applies to MeasureSquare 8. When working with a large amount of products, it can get tedious updating product ...How do I Map or Import a 3rd party Excel File to My MeasureSquare Database?
In this article, you will learn how to use import products from a custom or 3rd-party Excel file into your product database in MeasureSquare 8. This applies to MeasureSquare 8, Build 8941.How do I sync, view, search and manipulate the Product Database in MeasureSquare Mobile for Android Tablet?
You will learn how to some basic operations of Product Database by reading this article. In this video we will show you how to toggle the database view from list to folder, create a new folder, and how to create and sync a new database. This article ...How Do I Create and Share a Database With Another User in MeasureSquare 8 using MeasureSquare Cloud?
In this article we will show you how to create a new database, and share that database (or an existing) database with other users through the MeasureSquare Cloud. Step 1: Open Product Catalog window Step 2: Create new database Step 3: Name database ...How to Create a Linear Product on MeasureSquare 8
In this article we will covering how to create a linear product item on MeasureSquare 8. This article applies to Build 8941 and newer. Step 1: Select the '+' in the top left of the 'Product/Services' Step 2: From the 'New Product' window include your ...