How to Create a BOM Using MS Excel

Written by tricia goss Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Create a BOM Using MS Excel
Explain costs with a BOM. (building materials image by Greg Pickens from

A BOM is a bill of materials, which lists in detail the materials, components and quantities of materials that go into a specific job or end product. A BOM helps you to determine the final bill and to explain cost disbursement to your customers. You can create a thorough bill of materials using Microsoft Excel without extensive effort by downloading a BOM template.

Skill level:
Moderately Easy

Things you need

  • MS Excel 2003 or 2007
  • Internet connection

Show MoreHide


  1. 1

    Start Excel by double-clicking the Excel icon on your taskbar or desktop, or click "Start," point to "Programs" or "All Programs" and select "Microsoft Excel."

  2. 2

    Go to the "File" menu in Excel 2003 and select "New" or click the "Office Button" in Excel 2007 and select "New."

  3. 3

    Type "bill of materials" into the "Search Office Online" under "Templates." Click "Go" or press "Enter."

  4. 4

    Select the BOM template you want to use. Click "Download." The template opens as a new Excel worksheet. Go to the "File" menu in Excel 2003 or the "Office Button" in Excel 2007 and click "Save As." Enter a name for the worksheet and save the file in your desired location.

  5. 5

    Enter the job name, material descriptions, costs and quantities and dates purchased or used. Save the file again before closing and print as needed.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.