Home > Data > Sample > Work Orders

Work Order Sample Data for Excel

Debra Dalgleish - Contextures

This page has service department work orders sample data that you can download, to use for testing, Microsoft Excel training and demos, and other learning activities. See the dataset description below, and download the Excel file to get started!

service department work order sample data for testing

1) Work Orders Data

This sample file has work orders data for a fictional service company.

  • There are 22 columns of data, including 9 columns with a calculation.
  • There are 1000 rows of data in the work orders table.

Each row shows these 13 manual entry fields:

  • WO: unique work order ID
  • District: geographic area where work will be done
  • LeadTech: head technician at the work location
  • Service: type of work to be done - Assess, Deliver, Install, Repair, Replace
  • Rush: is this a rush job? Yes or blank
  • ReqDate: date the work order was entered in system
  • WokDate: date the work was completed
  • Techs: number of technicians required
  • WtyLbr: is labor under warranty? Yes or blank
  • WtyParts: are parts under warranty? Yes or blank
  • LbrHrs: for completed work orders - number of hours labour
  • PartsCost: cost of parts required to complete the work
  • Payment: type of payment customer will use - Account, C.O.D, Credit, P.O., Warranty

Each row shows these 9 calculated fields:

  • Wait: WorkDate - ReqDate
  • LbrRate: hourly rate lookup, based on number of technicians
  • LbrCost: LbrRate x LbrHrs
  • LbrFee: labor cost, if not under warranty
  • PartsFee: parts cost, if not under warranty
  • TotalCost: LbrCost + PartsCost
  • TotalFee: LbrFee +PartsFee
  • ReqDay: 3-letter weekday name, based on ReqDate
  • WorkDay: 3-letter weekday name, based on WorkDate

Note: This screen shot shows the first 8 columns in the Work Orders dataset table. There are 14 additional columns in the dataset, as described above.

Note: You many not resell this sample data, in whole or in part, or include it in paid products.

work order sample data for testing

2) Download the Sample Data

Work Orders: Click here to get the service department work orders data file.

The zipped Excel file is in xlsx format, and does not contain any macros.

3) Many More Sample Data Files

There are many more Excel files with sample data that you can download! Go to any of the pages listed below, and get more data sets for Excel practice.

food sales data

Office Supply Sales - This sample Excel file has office supply sales data, from a fictional stationery company. For details on this data, and to download the zipped Excel file, go to the Excel Sample Data for Practice page.

food sales data

Food Sales - This sample Excel file has food sales data, from a fictional food company. For details on this data, and to download the zipped Excel file, go to the Food Sales Sample Data page.

athlete data

Athlete Data - These sample Excel files have data for football players, and winter games athletes. For details on this data, and to download the zipped Excel file, go to the Athletes Sample Data page.

hockey player data

Hockey Player Data - This sample file has data from the 2018 Olympic Hockey teams, from Canada and the USA. For details on this data, and to download the sample file, go to the hockey player data analysis page.

Workplace Safety data

Workplace Safety Data: This sample file has data for workplace safety incidents. For details on this data, and to download the zipped Excel file, go to the Workplace Safety Sample Data page.

Insurance Policies data

Insurance Policies: This sample file has commercial insurance policy data for a fictional insurance company. For details on this data, and to download the zipped Excel file, go to the Insurance Policy Sample Data page.

Food Nutrients data

Food Nutrients: This sample file has food nutrient data for about 1000 food items. For details on this data, and to download the zipped Excel file, go to the Food Nutrients Sample Data page.

5) Where To Go Next

Here are a few of my tutorials on working with data in Excel, organizing it in tables, and summarizing the data in pivot tables. You can find new ideas for your Excel practice sessions, or for training examples.

-- Excel Sample Data

-- Excel Tables

-- Pivot Tables

-- Data Entry Tips

Get Monthly Excel Tips!

Be sure to get my monthly newsletter, with quick Excel tips, links, news, and a bit of fun. Just add your email, then click Sign Up.

 

 

Last updated: February 16, 2026 11:57 AM