PROVIDER OFFICE GUIDE · CONTENT UPDATED 2026-11-01

Import Septic Maintenance Records from Excel

Move a maintenance book into a reviewable spreadsheet before importing it. Keep a copy of the original export, map each column and check a small sample before accepting a full import. A downloadable sample below shows the shape of the data; it is not a promise that every source format is supported.

1. Start with an unchanged source copy

   Save the original workbook or delimited export separately. Record where it came from and its export date. Work on a copy so you can compare row counts and return to the original if a mapping is wrong. A source-system label is not enough to prove compatibility: SAFE-specific exports still need validation against a real file.

2. Map columns without losing permit references

   Treat permit references, postcodes and phone numbers as text. A permit such as 001234 must not become 1234. Choose one date format, such as YYYY-MM-DD, and distinguish the last completed inspection from the contract start and end dates. System type and design flow should come from maintained records rather than guesses.

3. Review duplicates and missing values

   Compare property and permit together, then review possible duplicates manually. A repeated homeowner name can represent different sites; a changed owner can still refer to the same permit. Keep missing information visible. Do not replace an unknown inspection date with today just to get a deadline.

4. Try a small batch and reconcile totals

   Check a small, representative sample: a leading-zero permit, an address with a comma, a multi-line note, a renewed contract and an incomplete row. Compare source rows, accepted rows, rejected rows and duplicate decisions. Review the preview before accepting an import, then compare a few resulting records with the source.

5. What the sample file is for

   The sample CSV contains fictional records and column names for planning a mapping. It is not an export from a customer or from SAFE. Open it with import-as-text options where appropriate; spreadsheet applications can otherwise convert leading zeros. Ask for assistance through the founding-partner form when the available importer does not recognize your source.

Not legal advice. Verify the permit, contract and local requirements. This guide does not submit records, send notices or charge a homeowner.