Electrical Load List Excel Template: What to Include

How-to basics · Updated November 19, 2026

An electrical load list Excel template is a worksheet for recording each electrical load, its supply details, rated power, and calculated connected or demand load. In Excel for Microsoft 365, build one row per item, use formulas for repeatable calculations, and keep assumptions such as demand factors visible so a reviewer can check them.

What an electrical load list is for

An electrical load list, sometimes called a load schedule, gathers information about equipment that uses electricity in a building, plant, or other project. Engineers and designers use it to organize estimated or known loads and support decisions about distribution equipment, cables, transformers, generators, and other parts of the electrical system. It can also help a project team track changes as equipment selections become more definite.

The list is a calculation and coordination aid, not by itself a complete design or proof that an installation complies with applicable electrical codes. Required methods depend on the project, jurisdiction, equipment, and design criteria. The responsible electrical professional should establish the assumptions and verify the resulting design.

A useful spreadsheet distinguishes several quantities that are often confused:

  • Connected load: the sum of equipment ratings entered for the listed items, before any demand allowance is applied.
  • Demand load: a calculated or specified estimate of the load expected to operate at the same time, using documented project criteria.
  • Operating current: current calculated from power, voltage, and, where applicable, power factor and phase configuration.
  • Starting or inrush demand: a temporary condition that may matter for motors and other equipment but is not represented by a simple steady-state load total.

Columns to include in the template

Start with identifiers that make each row traceable to a drawing, equipment schedule, or supplier document. Then add electrical and calculation fields. A practical set of columns is:

  • Load ID, equipment tag, description, area, and drawing or document reference.
  • Quantity, equipment category, and status, such as proposed, confirmed, or omitted.
  • Supply phase, nominal voltage, frequency where relevant, and connection information.
  • Nameplate rating and its unit, such as kW, kVA, horsepower, or amperes.
  • Power factor where relevant, plus the source or basis for that value.
  • Connected load, demand factor or other approved adjustment, and resulting demand load.
  • Calculated current, circuit or panel designation, and notes about operating or starting conditions.

Keep units explicit in the column headings or a separate unit column. A value of 15 is ambiguous without a unit; 15 kW and 15 kVA do not mean the same thing. Likewise, identify whether a voltage is line-to-line or line-to-neutral when that distinction affects the calculation. Avoid putting multiple unrelated values in one cell, because they are harder to filter, validate, and calculate.

How to organize the workbook

For a small job, one well-labeled worksheet may be enough. For a larger project, separate the detailed load register from summary views, while keeping one authoritative source for the data. A workbook can include a load list, a panel or area summary, and an assumptions sheet that records the criteria used. Do not copy figures into multiple sheets by hand if formulas can link them; duplicated manual totals can drift apart.

Use one row per equipment item, or one row per group of genuinely identical items when quantity and rating are clear. If three identical pumps are listed together, record quantity as 3 and the per-unit rating separately. Do not combine equipment with different voltage, phase, operating mode, or demand basis just to shorten the list. Give each item a stable tag so revisions can be compared and comments can point to a specific row.

In Excel, keep the header row distinct and avoid merged cells in the data area. Select the range and use Insert > Table, or press Ctrl+T on Windows, to make it easier to sort, filter, and extend the list. On a Mac, the shortcut is Command+T. Freeze the header row if the register is long, and use data validation lists for fields such as phase or status if consistent entries matter. Record units and calculation assumptions in plain language rather than relying on color alone.

Basic formulas for connected and demand load

A simple row-based calculation can make arithmetic consistent. Suppose quantity is in D, rated kW per item is in E, connected kW is in F, demand factor is in G, and demand kW is in H. Enter demand factors as decimals: 75% is 0.75, not 75. For row 2, with quantity 3 and a rating of 2.4 kW per item, the connected load is 7.2 kW.

With quantity in D2 and per-item rating in E2, enter this in F2: =D2*E2. For the example values, the result is 7.2 kW. With connected load in F2 and the approved demand factor in G2, enter this in H2: =F2*G2. If G2 is 0.75, the result is 5.4 kW. These formulas assume the rating is per item and all quantities in that row share the same rating and demand basis.

Demand factors are not universal defaults. Use values specified by the project design criteria, governing requirements, or a qualified designer; do not select a factor merely because it makes the total smaller. Some loads may need to be treated individually, and some standards use other terms or calculation rules. Preserve the source of each factor in a notes or reference column.

Calculating current: phase, voltage, and power factor

Current cannot be inferred reliably from kW alone. For a simplified steady-state calculation, single-phase current is real power divided by voltage and power factor. For a balanced three-phase load using line-to-line voltage, current is real power divided by the square root of three, voltage, and power factor. These relationships assume compatible units and a representative power factor; equipment nameplate data and project methods take precedence.

For a single-phase example, assume demand kW is in H2, voltage in B2 is 230 V, and power factor in C2 is 0.90. Enter this formula in the current cell: =H2*1000/(B2*C2). With H2 equal to 5.4, the result is about 26.09 A. The factor of 1000 converts kW to watts.

For a balanced three-phase example, assume H2 is 5.4 kW, B2 is 400 V line-to-line, and C2 is 0.90. Enter: =H2*1000/(SQRT(3)*B2*C2). The result is about 8.66 A. The same kW therefore gives different current at different voltage and phase configurations. These examples illustrate spreadsheet arithmetic; they are not a substitute for selecting conductors or protective devices under the applicable rules.

If a nameplate gives kVA rather than kW, do not treat its number as kW or apply power factor twice. For an idealized apparent-power calculation, current is based on VA and voltage; real equipment and code-based sizing may require additional factors. Label the rating type, retain the nameplate value, and have the calculation method checked before using the result for design.

Worked example and useful summaries

Suppose a register has three identical 2.4 kW single-phase units, a documented demand factor of 0.75, and a 230 V supply. The connected total is 3 × 2.4 = 7.2 kW, and the demand total is 7.2 × 0.75 = 5.4 kW. At an assumed power factor of 0.90, the illustrative steady-state current is approximately 26.09 A. The example demonstrates how quantity, rating, demand, and current connect; the chosen demand factor and power factor must come from appropriate project information.

At the bottom of a simple list, a connected-load total can be calculated from F2 through F100 with =SUM(F2:F100); if those cells contain 7.2 kW and otherwise blank cells, the result is 7.2 kW. A separate sum of demand loads in H2:H100 would use =SUM(H2:H100). Keep totals separated by meaningful categories, such as supply voltage, phase, or panel, rather than presenting one grand number that hides incompatible loads. A grand total can be useful as a check, but it should not replace the breakdown used for design decisions.

Checks that prevent spreadsheet errors

Load lists commonly fail through inconsistent units, stale inputs, or assumptions that are not visible. A spreadsheet can look polished and still be wrong if a rating was copied into the wrong unit column. Build checks into the review process:

  • Check that every included item has a unique tag, a description, and a traceable rating source.
  • Scan for missing phase, voltage, rating units, or power factor where the calculation needs them.
  • Check that demand factors are numeric decimals and that formulas reference the intended row.
  • Compare the calculated connected total with an independent check or source schedule.
  • Filter by status and confirm that excluded, spare, or future loads are not accidentally included in an active total.
  • Review formula cells after sorting, inserting rows, or pasting data, especially if the workbook uses manually copied formulas.

Conditional formatting can help draw attention to blanks or unusual values, but it does not validate engineering assumptions. Protecting formula cells may reduce accidental edits, yet users should still keep a revision history and identify who changed inputs. Add a revision date and a short change note when equipment ratings or project criteria change.

Common limitations and safety considerations

A load list is usually a snapshot of documented equipment, not a guarantee of actual simultaneous consumption. It may omit temporary loads, future expansion, harmonics, motor starting effects, nonlinear loads, or site-specific operating patterns unless those are deliberately captured. A steady-state current formula also does not determine breaker size, conductor ampacity, voltage drop, fault protection, or generator transient performance by itself.

Do not use an unreviewed template to authorize energization or make installation decisions. Electrical work and design can present shock, fire, and equipment-damage hazards. A qualified electrical designer should verify data, assumptions, calculations, and coordination with the applicable code and project requirements. Where the load list is used for procurement or equipment sizing, confirm ratings against current supplier documentation and the final operating conditions.

When to use a template or another tool

An Excel template is useful when a project needs a transparent, editable register, moderate-sized data sets, and familiar review workflows. It is easy to adapt for tags, areas, and project-specific fields, but it relies on disciplined version control and careful formula management. For large or frequently changing projects, a database, engineering design platform, or asset-management system may handle permissions, linked drawings, and revision control more reliably.

For a very small installation, a professionally prepared schedule or a simple table may be more appropriate than a complex workbook. Whichever format is used, the important qualities are traceable inputs, explicit units, documented calculation rules, and review by the responsible person. A spreadsheet is a container for the information and calculations, not the source of engineering judgment.

Frequently Asked Questions

Where can I get an electrical load list Excel template?
Look for a template from a reputable engineering, electrical-design, or project source that explains its assumptions. Before using it, check that its units, phase fields, rating types, and demand calculations match your project. A generic blank workbook is often safer than an unexplained file with hidden formulas.

What is the difference between connected load and demand load?
Connected load totals the listed equipment ratings. Demand load applies an approved method to estimate the load expected under the relevant operating conditions. The two values can differ, but a demand factor should have a documented basis rather than being chosen arbitrarily.

Can Excel calculate three-phase current from kW?
Yes, Excel can calculate an illustrative balanced three-phase current when you provide real power in kW, line-to-line voltage, and power factor. The result does not by itself establish code-compliant conductor, breaker, or equipment sizing.

Should motors be listed by horsepower or kW?
Record the nameplate rating and its original unit so the source remains clear. If the workbook converts horsepower to another unit, make the conversion explicit and verify the motor data, efficiency, voltage, and applicable sizing method. Do not assume a simple power conversion alone gives the design current.

Does an electrical load list replace a panel schedule?
No. A load list summarizes equipment and project load information; a panel schedule organizes circuits and related distribution details. They may share data, but each serves a different purpose and should be coordinated with the complete electrical design.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.