Free megger test report · Excel

Free Insulation Resistance Test Report

A megger test report that holds up at commissioning: 1-minute readings phase-to-ground and phase-to-phase, temperature correction, pass/fail against your minimum, PI and DAR, instrument calibration check and sign-off.

  • Equipment/cable ID, rating, DC test voltage
  • A–G, B–G, C–G and A–B, B–C, C–A readings (MΩ)
  • Temperature + your correction factor, lowest corrected reading
  • PASS / FAIL against the minimum you enter
  • PI (10 min / 1 min) and DAR (60 s / 30 s) sheet
  • Instrument serial, calibration date + expired-cal flag
  • Technician, witness and reviewer sign-off

Insulation Resistance Test Report

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

IR Test Report

Test conditions, instrument and calibration status, then one row per cable or equipment item with six 1-minute readings, temperature correction, minimum and result, plus a pass/fail summary.

02

PI & DAR

Timed readings at 30 s, 1 min and 10 min with DAR and PI calculated, compared to your minimums, and the very-high-IR caveat handled automatically.

03

Instructions

Safety and isolation, choosing the test voltage, temperature correction, reading the results, and what to do after the test.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

What goes on an insulation resistance test report?

The equipment or cable ID, its voltage rating, the DC test voltage, the 1-minute readings for each phase to ground and phase to phase, the temperature and correction factor, the minimum acceptable value and the result. It should also record the test instrument, its serial number and calibration date, the conditions, and who tested and witnessed it.

What test voltage should I use to megger 600 V cable?

Common practice for 600 V-rated cable and equipment is 1,000 V DC, and 500 V DC for 250 V-class equipment and low-voltage motor windings. Medium-voltage gear and cable get higher values. Always follow the project specification and the standard it references, such as NETA ATS or IEEE 43 for rotating machines.

How do you calculate polarization index and DAR?

Polarization index (PI) is the 10-minute reading divided by the 1-minute reading. Dielectric absorption ratio (DAR) is usually the 60-second reading divided by the 30-second reading. Healthy dry insulation keeps rising during the test, so the ratio is well above 1. IEEE 43 recommends a minimum PI of about 2.0 for modern Class B and higher windings; DAR minimums are a rule of thumb. The template calculates both.

Why do megger readings need temperature correction?

Insulation resistance falls as temperature rises — roughly halving for every 10 °C increase for many materials. Correcting every reading to one reference temperature lets you compare this test with the last one. NETA tables commonly use 20 °C for cables and apparatus; IEEE 43 uses 40 °C for rotating machines. You enter the correction factor from your standard or test set.

What is a passing megger reading?

There is no single number. The minimum comes from the project spec, the manufacturer, or the standard you test to, and it depends on voltage class and equipment type. The template compares the lowest corrected reading to the minimum you enter. Just as important: compare phases to each other and to prior tests — one phase much lower than the others is a problem even if it passes.

Megger it, correct it, sign it

An insulation resistance test is how you prove cable and equipment are safe to energize. This free Excel report records what owners, engineers and commissioning agents ask for: the test voltage, each phase-to-ground and phase-to-phase reading, the temperature and correction, the minimum you judged against, and who tested and witnessed it.

Minimum values and correction factors are your inputs — from the project spec, the manufacturer, or the standard you test to — so the report works for 600 V feeders, motor windings, transformers and switchgear alike. For how IEEE 43 approaches motor testing, see our insulation resistance testing guide.

Built by a licensed electrical contractor. Field PM files test reports, QC inspections and hold points against the job so turnover is ready when the work is.

The insulation resistance test, done right

A megger test is the cheapest insurance on an electrical job. Ten minutes with an insulation tester before energizing finds the nicked conductor at a fitting, the wet splice in a handhole, and the motor that sat in a flooded pit — before they become a fault, a tripped main, or an arc-flash event. The test only protects you if it's recorded properly, though. A reading scrawled on a cable tag won't satisfy a commissioning agent, and it can't be trended next year.

The free workbook above gives you a professional IR Test Report for cables and equipment, a PI & DAR sheet for motors, transformers and critical cable, and instructions for doing the test safely.

Before you connect the tester

  1. De-energize, lock out, and verify absence of voltage per NFPA 70E. An IR test is not a substitute for a voltage test. Our NFPA 70E approach boundaries chart and electrical JSA template help with the planning.
  2. Isolate what shouldn't see the test voltage: surge arresters and capacitors, VFDs and soft starters, electronic trip units, meters, control transformers, PT and CT secondaries. Megging through a drive can destroy it.
  3. Lift both ends of cable when you can. Testing a feeder with the panel landed tests the panel too — which is fine if you want that, but know which one you're reading.
  4. Clean and dry the terminations. Surface leakage across a dirty lug reads like bad insulation. Use the guard terminal to separate surface leakage from volume leakage on critical tests.
  5. Check the instrument. It must be in calibration — the report flags an expired calibration date.

Choosing the test voltage

Pick the DC test voltage from the equipment's rating and the project specification. Typical practice:

Equipment ratingTypical DC test voltage
250 V-class (120/208 V panels, small equipment)500 V DC
600 V cable and equipment1,000 V DC
Low-voltage motor windings (below 1,000 V)500 V DC (IEEE 43 guidance)
Medium voltage (5 kV, 15 kV)Per project spec / NETA ATS — typically several kV

Higher is not better. Hitting old insulation with more voltage than it needs can fail it. Record the voltage you actually used.

Recording readings: phase to ground and phase to phase

For three-phase cable and equipment, the report takes six 1-minute readings: A–G, B–G, C–G (each phase to ground with the other phases grounded) and A–B, B–C, C–A. The sheet finds the lowest reading, applies the temperature correction, and compares it to the minimum you enter. Look at the phases against each other, too: in the example on the template, a motor branch reads 850 and 900 MΩ on A and B but 45 MΩ on C — C fails, and the note says where to look (the pull, and the fittings where the insulation can be nicked).

If the tester shows over-range (">5 GΩ"), enter its full-scale value as a number and note it. Text entries are ignored by the formulas.

Temperature correction

Insulation resistance drops as temperature goes up — for many insulation systems it roughly halves for every 10 °C rise. A cable that reads 2,000 MΩ on a cold morning might read 1,000 MΩ on a hot afternoon with nothing wrong. To compare tests, every reading is corrected to a reference temperature:

  • NETA ATS tables commonly correct to 20 °C for cables and electrical apparatus.
  • IEEE 43 corrects rotating machine windings to 40 °C.

You enter the correction factor (a multiplier) for the recorded temperature from your standard's table or your test set's built-in correction. If you leave it blank, the sheet uses 1.0 and marks the result "(no temp corr.)" so nobody mistakes it for a corrected value. See our IEEE 43 insulation resistance testing guide for a worked example.

Polarization index and dielectric absorption ratio

A single 1-minute number tells you about surface moisture and contamination. Timed readings tell you about the insulation itself. When DC voltage is applied, good insulation keeps absorbing charge and the resistance keeps climbing for minutes; wet or contaminated insulation flattens out almost immediately.

  • Polarization index (PI) = 10-minute reading ÷ 1-minute reading. IEEE 43 recommends a minimum around 2.0 for modern Class B and higher windings.
  • Dielectric absorption ratio (DAR) = 60-second reading ÷ 30-second reading. A quick screen when a 10-minute test isn't practical; minimums are a rule of thumb, not a standard.

One catch: when the 1-minute reading is very high (on the order of 5,000 MΩ), IEEE 43 notes the PI may not mean much — the current is so small the ratio is noise. The PI & DAR sheet switches to "PASS on IR" above the threshold you set. The example flooded motor reads 10, 12 and 15 MΩ — PI 1.25 — and fails: clean it, dry it out, and retest.

What makes a test report hold up

  • Instrument, serial number, calibration date and due date on every page.
  • Test voltage and duration for every reading.
  • Temperature and humidity — without them, nobody can trend the result.
  • What was connected during the test (both ends lifted? motor leads disconnected?).
  • The minimum you judged against, and where it came from (spec section, manufacturer, standard).
  • Signatures — the technician, the witness (owner or commissioning agent), and the reviewer.

After the test

Ground and discharge every item for at least as long as the test voltage was applied — longer after a 10-minute PI. Windings and long cables hold a charge that can hurt someone. Re-land the conductors, torque the terminations, and update the status on your cable schedule. Failed items get tagged out and stay off until they're repaired and retested. The completed reports go in the closeout package — see the project closeout checklist.

Keep test records with the job, not in a folder

Field PM's QA/QC module ties test reports, inspections and hold-point sign-offs to the project, so the turnover package is ready when the work is. Built by a licensed electrical contractor. Start a free 30-day trial — no credit card required.

This template is a field test record, not engineering advice. Acceptance criteria come from the project specification, the equipment manufacturer and the standards you test to (IEEE 43, ANSI/NETA ATS and MTS), which are referenced here in our own words — use the current editions. All testing must follow NFPA 70E and your company's electrical safety program.

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice