Multi-circuit batch CSV wire sizing tool
Paste CSV rows, upload a .csv file, or load a sample panel schedule to compute wire gauge, voltage drop %, conduit size, EGC, and breaker rating in your browser.
CSV input and schedule defaults
Paste CSV rows or click “Load Sample Panel Schedule” to calculate all circuits.
- Passing circuits
- —
- Drop-upsized rows
- —
- Worst voltage drop
- —
- Row errors / parallel
- —
Computed circuit schedule
| Circuit | Load | Volts / φ | Length | Wire gauge | Drop % | Breaker | EGC | Conduit | Status | Inspect |
|---|
IEC mode interprets lengths in meters and ambient temperatures in °C, sizes conductors in mm² using conservative AWG ampacity equivalents, and computes voltage drop from IEC 60228 resistance.
Supported CSV column schema and defaults
Each row in your CSV represents one branch circuit or feeder. Column order matches the header line; you can include only the first four columns or all eleven columns. Quoted strings (such as "Garage, West Wall") and Excel-exported .csv files are supported automatically.
Circuit (required)Circuit label or panel space ID
Amps (required)Connected load current (0.1–2000 A)
Volts (required)Circuit voltage (1–1000 V)
Length (required)One-way run (ftm)
Phase (optional)1, 3, or dc (default 1)Material (optional)cu or al (uses default)Continuous (optional)1/yes (125%) or 0/noMaxVD (optional)Drop target % (uses default)
Conduit (optional)emt, pvc40, pvc80, or rmcCCC (optional)Current-carrying wires (default 3)
Ambient (optional)Ambient temp (°F°C)
How each row is computed: Design ampacity applies 1.25× when Continuous=1, checks 90 °C THHN adjusted ampacity per NEC 310.15(B) & (C), enforces 75 °C or 60 °C terminal limits per 110.14(C), and enforces NEC 240.4(D) small-conductor OCPD caps. The gauge is then stepped up until voltage drop stays at or below MaxVD%. Conduit sizing includes 2 hots (1φ/DC) or 3 hots (3φ) plus 1 EGC sized per NEC 250.122 and 250.122(B) upsizing.
Three worked batch schedule examples
Example 1: Minimal 4-column residential takeoff CSV
When estimating quickly, paste only the four required columns (Circuit,Amps,Volts,Length) and let the Schedule Defaults panel supply single-phase copper EMT at 3% max drop:
Circuit,Amps,Volts,Length
Kitchen Small Appliance 1,16,120,55
Bathroom GFCI,15,120,45
Heat Pump Condenser,28,240,65
Detached Shop Feeder,75,240,160
The batch calculator assigns 12 AWG Cu (20 A) for the 120 V circuits, 10 AWG Cu (30 A) for the 28 A non-continuous condenser, and automatically steps the 160 ft 75 A shop feeder up to 2 AWG Cu (2.11% drop) with a 6 AWG Cu EGC (upsized per 250.122(B)) in 1-1/4" EMT.
Example 2: Mixed commercial 208 V / 480 V 3-phase schedule with continuous loads
Commercial panel schedules often mix 120 V lighting, 208 V 3-phase HVAC, and 480 V aluminum feeders in the same spreadsheet:
Circuit,Amps,Volts,Length,Phase,Material,Continuous,MaxVD,Conduit,CCC,Ambient
LED Lighting Bay A,14,277,140,1,cu,1,3,emt,6,86
RTU-1 Rooftop Unit,42,480,180,3,cu,1,3,emt,3,104
Subpanel LP-2 Feeder,150,208,110,3,al,0,2,pvc40,3,86
Row 1 applies the 0.80 bundling factor for 6 CCC and 1.25× continuous load (17.5 A → 12 AWG Cu on 20 A breaker, 2.26% drop). Row 2 applies both 104 °F (40 °C) ambient derating (0.91) and 1.25× continuous load (52.5 A → 6 AWG Cu on 60 A breaker). Row 3 sizes the 150 A aluminum feeder in PVC Sch 40 at 3/0 AWG Al (155 A @ 75 °C, 1.73% drop ≤ 2%) with a 6 AWG Al EGC in 2" PVC Sch 40.
Example 3: Identifying voltage-drop-upsized circuits and 250.122(B) EGC bumps
Use the Drop upsized filter above the computed schedule to isolate long runs where wire gauge had to increase beyond thermal ampacity—such as a 20 A 120 V parking-lot post light 240 ft from the panel:
Parking Light Pole 4,16,120,240,1,cu,1,3,pvc40,3,86
→ Ampacity minimum: 12 AWG Cu (20 A) | 12 AWG drop at 240 ft = 12.67% (FAIL)
→ Voltage drop minimum: 6 AWG Cu (2 × 16 × 0.491 × 0.240 / 120 = 3.14% → steps to 4 AWG Cu = 1.97%)
→ EGC upsizing (250.122(B)): 12 AWG base × (41,740 / 6,530) = 26,681 cmil → 4 AWG Cu EGC
Exporting the completed CSV puts the exact upsized conductor (4 AWG), proportional EGC (4 AWG), 20 A breaker, and 1" PVC Sch 40 raceway directly into your takeoff spreadsheet.