Download this ready-to-use Excel sheet for calculating the quantity of bricks and mortar required for any type of brickwork. Simply input wall dimensions, and the sheet will estimate the number of bricks, volume of mortar, and material requirements with accuracy. This tool is perfect for civil engineers, contractors, and students for fast and reliable estimations on-site or during planning.
What This Excel Sheet Calculates
This brick quantity calculator automates the most time-consuming part of brickwork estimation. It handles:
- Number of bricks required based on wall length, height, and thickness
- Mortar volume — both bed and perpend joints accounted for
- Wastage allowance — typically 5–10% built into the formula
- Material cost estimation when unit prices are entered
How to Use the Brick Quantity Calculator
Using the sheet is straightforward. Enter the following inputs:
- Wall length (m or ft)
- Wall height (m or ft)
- Wall thickness — single leaf (half brick), one brick, or cavity
- Brick dimensions (standard or custom)
- Mortar joint thickness (typically 10 mm)
The sheet instantly outputs total brick count and mortar volume. No manual formula manipulation required.
Standard Brick Sizes and Mortar Ratios Used
The calculator supports standard brick dimensions used globally. Common UK bricks measure 215 × 102.5 × 65 mm with a 10 mm mortar joint, giving a coordinating size of 225 × 112.5 × 75 mm. In metric countries, the standard varies slightly but the sheet can be adapted to any input dimensions.
Mortar mix ratios typically range from 1:3 to 1:6 (cement:sand) depending on the application — the sheet assumes a standard 1:4 mix by default but allows override.
Who Should Use This Tool
This Excel sheet is designed for:
- Civil and structural engineers preparing material schedules
- Quantity surveyors estimating project costs
- Site supervisors and contractors placing material orders
- Students learning construction estimation methods
Download the free Excel sheet below and speed up your next brickwork estimation job.
Download the Free Brick Quantity Calculator
This tool is regularly updated to ensure compatibility with standard brick and mortar specifications. Whether you are estimating a single garden wall or a multi-storey masonry building, it delivers fast, consistent results that you can include directly in your material schedule or cost estimate. Download the free Excel sheet below and streamline your brickwork quantity takeoff process.
