⚡ VoltEdge

kW to Amps Excel Formula

Copy-paste spreadsheet formulas for every circuit type.

Download Excel Calculator (.xlsx)

Free spreadsheet — enter kW, voltage and PF; get DC, 1-phase, 3-phase amps and breaker size.

Copy-Paste Formulas

Replace A1 with the cell holding kilowatts, B1 with volts, and C1 with power factor. Paste into Excel, Google Sheets, LibreOffice, or Apple Numbers — the syntax is identical.

DC Formula

=A1*1000/B1

Kilowatts in A1, DC voltage in B1. Example: 2.5 kW in A1, 48 in B1 → 52.08 A.

Single-Phase AC Formula

=A1*1000/(B1*C1)

Power factor in C1 (use 1 for heaters, ~0.85 for motors). Example: 3 kW, 230 V, PF 0.85 → 15.34 A.

Three-Phase AC Formula

=A1*1000/(SQRT(3)*B1*C1)

Uses line-to-line voltage in B1. Example: 15 kW, 400 V, PF 0.86 → 25.18 A.

Breaker Size Formula (125% Rule)

=CEILING(A1*1000/(B1*C1)*1.25, 5)

Calculates amps, applies the NEC 125% continuous-load factor, and rounds up to the next standard 5 A increment. For the 15 kW example above: 25.18 × 1.25 = 31.5 → 35 A breaker.

Building a Conversion Table

To generate a full kW-to-amps table: list kW ratings down column A (1, 2, 3 …), put voltage in B1 and PF in C1 as fixed references, then fill the three-phase formula down column B using absolute references: =A2*1000/(SQRT(3)*$B$1*$C$1). Drag down and the whole table computes instantly.

Frequently Asked Questions

Does SQRT(3) work in Google Sheets?
Yes — SQRT(3) works identically in Excel, Google Sheets, LibreOffice Calc, and Apple Numbers.
How do I handle power factor as a percentage?
Either enter it as a decimal (0.85) or divide the percentage cell by 100 in the formula: =A1*1000/(B1*(C1/100)).