Skip to main content
  • Solutions
      • Compliance Management
      • Audits and Inspections
      • Compliance Obligations
      • Document Management
      • Incident Management
      • Management of Change
      • Risk Register
      • Pipeline Safety
      • Task Tracking
      • Training
      • Environmental
      • Air Quality
      • ISO 14001
      • EPA RMP
      • LDAR
      • SPCC
      • Stormwater
      • TSCA PCB Management
      • Waste Management
      • Water Quality
      • Health and Safety
      • ISO 45001
      • Asbestos
      • Chemical Management
      • Emergency Planning
      • Industrial Hygiene
      • Hazard Analysis
      • Process Safety Management
      • Other
      • ISO 9001
      • Contractor Management
      • Customer Management
      • Data Management
      • Land Management
      • Oil and Gas
      • Preventive Maintenance
      • EHS Dashboard
      • Mobile EHS App
  • Industries
      • Mining
      • Oil and Gas
      • Manufacturing
      • Food and Beverage
      • Higher Education
      • Healthcare
      • Construction
      • Municipalities
      • Utilities/Power
      • Transportation
      • Petrochemicals
      • Chemicals
  • About
      • Accessibility
      • Security
      • AI Features
      • System Status
      • Release Notes
      • Support
      • Why Ecesis
      • About EDS
      • Frequently Asked Questions
      • Join Our Team
      • Pricing
      • EHS Resources/Tools
      • EHS Compliance Calendars
      • EHS Calculators
      • EHS Inspections
      • EHS Program Audits
      • EHS Blog
Ecesis EHS Software
  • Ecesis EHS Software on LinkedIn
  • Ecesis EHS Software on Facebook

EDD Import
Laboratory Data Made Easy

The ability to import Electronic Data Deliverable (EDD) files from analytical laboratories is the single most impactful feature in water quality software. It eliminates the largest source of errors in environmental data management — manual transcription of lab results — and transforms a multi-hour data entry task into a process that takes minutes.

The Cost of Manual Lab Data Entry

Without EDD import capability, environmental staff must manually transfer results from laboratory reports into spreadsheets or databases. This process is slow, tedious, and error-prone:

Transposed digits (e.g., 0.15 entered as 0.51) go unnoticed until audits
Laboratory qualifiers (U, J, B flags) missed or entered incorrectly
Detection limits not captured, making compliance determinations unreliable
Results assigned to wrong sample locations or collection dates
Hours spent re-entering data that already exists in digital format
No audit trail showing where the data came from or who entered it

What Is an EDD?

An Electronic Data Deliverable is a structured data file produced by an analytical laboratory containing all the information from a Certificate of Analysis (COA) in a machine-readable format. A typical EDD includes:

  • Sample identification — Your sample IDs, lab sample IDs, and sample matrix
  • Collection and analysis dates — Used for holding time verification
  • Analytical method — EPA method number used for each analysis
  • Results — Measured concentration values with units
  • Detection limits — MDL, PQL, and reporting limits per analyte
  • Qualifiers — Laboratory data flags (U for non-detect, J for estimated, B for blank contamination)
  • QA/QC data — Duplicate results, blank results, spike recoveries

How EDD Import Works in Ecesis

One-Time Format Configuration

Each laboratory has its own EDD format — different column orders, naming conventions, and file types. During setup, the import mapping is configured once per laboratory: which columns contain sample IDs, results, units, qualifiers, and detection limits. All subsequent imports from that lab use the same mapping automatically.

Automatic Parameter Mapping

Laboratory parameter names often differ from your internal parameter names (e.g., “Total Suspended Solids” vs. “TSS” vs. “Residue, Non-Filterable”). The software maintains a parameter alias table that maps laboratory names to your standardized parameters. New aliases are added as they are encountered.

Import Validation

Before data is committed to the database, the software validates the EDD file and reports any issues: unrecognized sample locations, unmapped parameter names, missing required fields, duplicate records, or unit mismatches. Users review and resolve issues in a preview screen before finalizing the import.

Automatic QA/QC on Import

Once the data is loaded, automated validation checks run immediately: permit limit comparison, holding time verification, cation/anion balance, outlier detection, and detection limit flagging. Results that need review are queued for the data manager.

Supported Formats: Ecesis supports configurable EDD import from CSV, Excel (.xlsx, .xls), and fixed-width text files. The import engine can handle EDDs from any analytical laboratory — no custom development is needed to add a new lab. If your lab can produce a digital file, Ecesis can import it.

What Data Flows Downstream from EDD Import

Once lab data is imported and validated, it flows automatically into every downstream process:

  • DMR calculations — Monthly averages, daily maximums, and loading rates are computed from imported results
  • Trend analysis — New data points appear on time-series charts immediately
  • Permit compliance — Exceedance reports update in real time as data is loaded
  • Statistical analysis — Running statistics incorporate new results automatically
  • Dashboards — Compliance dashboards reflect the latest data as soon as it is approved
Bottom Line: EDD import is the foundation of efficient water quality data management. It eliminates transcription errors, saves hours of staff time per lab report, and ensures that every data point flows cleanly into your compliance reporting workflow. If you are still manually entering lab results, this is the single highest-impact improvement you can make. Ecesis water quality data management software.

Frequently Asked Questions

What is an Electronic Data Deliverable (EDD)?

An Electronic Data Deliverable is a structured file from an analytical laboratory containing sample results, detection limits, qualifiers, collection dates, analysis dates, and method information in a standardized format. Common formats include CSV, Excel, and fixed-width text files with fields defined by the laboratory or a standard such as EPA Region EDD formats.

Why is EDD import better than manual data entry?

Manual data entry from laboratory reports is the single largest source of errors in water quality data management. Transcription mistakes, transposed digits, missed qualifiers, and incorrect parameter assignments are common. EDD import eliminates these errors by loading data directly from the laboratory file without human re-keying.

What EDD formats does Ecesis support?

Ecesis supports configurable EDD import that can be mapped to any laboratory format including CSV, Excel, and fixed-width text files. The import mapping is configured once per laboratory and applied to all subsequent imports from that lab.

What happens if the EDD file contains errors?

The software validates the EDD file during import and reports any issues: unrecognized sample locations, unmapped parameters, missing required fields, duplicate records, or values outside expected ranges. Users can review and resolve issues before committing the data to the database.

Related Ecesis Solutions

Water Quality Software

Lab imports, data validation, permit tracking and DMR reporting.

Environmental Data

Sensor integration, statistical analysis and trend visualization.

Compliance Obligations

Track all regulatory obligations and recurring deadlines.

Inspections & Audits

Mobile field inspections with corrective action tracking.

Stormwater Compliance

Stormwater permits, inspections and BMP tracking.

Document Control

Manage COAs, SOPs, and compliance documents.

Related Resources

Water Quality Software Data Validation Detection Limits (MDL, PQL, RDL) Trend Analysis PCA Analysis Mass Loading Calculations NPDES Permit Compliance Composite vs Grab Sampling Chain of Custody Sampling Plan & QAPP Wastewater Treatment Selecting Water Quality Software

Ready to Eliminate Manual Lab Data Entry?

Call (720) 547-5102 or click below to see EDD import in action.

What Is Ecesis?

Ecesis is a leading EHS Software Solution that has been helping companies around the world reach their EHS goals since 1993.

About Us

Why Ecesis Join Our Team Pricing Resources EHS Blog

Get in Touch

1499 West 120th Avenue
Suite 110
Westminster, CO 80234
(720) 547-5102 (866) 733-6912 Click To Email Us

Connect With Us

EHS Software on LinkedIn EHS Software on Facebook EHS Blog

Copyright © 2026 EnviroData Solutions, Inc.

Terms of Use    Privacy Statement    Cookies

×

Please complete the form below or call us at (720) 547-5102 to learn more about Ecesis.

Enter Your Name


Enter Your Phone Number


Let Us Know How We Can Help You


Enter Your E-mail


Please check the reCAPTCHA box.