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
Kilowatts in A1, DC voltage in B1. Example: 2.5 kW in A1, 48 in B1 → 52.08 A.
Single-Phase AC Formula
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
Uses line-to-line voltage in B1. Example: 15 kW, 400 V, PF 0.86 → 25.18 A.
Breaker Size Formula (125% Rule)
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.