Importing Data

Quickly import data into KPA EHS with a spreadsheet called a "dataload". Load employee profiles, training, assets, inspections, and more.

Dataload Overview

It can be tedious to add dozens (or thousands) of employee profiles, assets, or trainings to a website one-at-a-time. KPA EHS provides a "dataload" process where data can be bulk-loaded using properly formatted spreadsheets.

For example, a dataload for creating new employee profiles would be a spreadsheet with columns like FirstName, LastName, EmployeeNumber, JobTitle, etc. This spreadsheet is then uploaded to KPA EHS and the system will verify that it is in the correct format and give you a preview of what changes will be made.

Dataload Upload A Spreadsheet
Upload a dataload (spreadsheet) through the control panel
Dataload History
View the history of dataloads run by your team

Types of Data

The following types of data can be bulk-loaded with a spreadsheet:

  • Employees - create or update team member profiles and logins
  • Locations - create or update locations (aka project or field office)
  • Lines of Business - create or update lines of business
  • Companies - create or update the list of 3rd-party companies (aka clients, vendors, sub-contractors)
  • ClientLocations - update contact information for sub-contractors, vendors, clients
  • Job Titles - update your list of job titles
  • Training Topics - create or update training topics assigned to your team
  • Completed Trainings - upload historic training completion dates
  • Equipment - create or update asset profiles
  • Equipment Inspections - upload historic inspection dates for your assets
  • Data List Items - update data lists such as well sites, rigs, building numbers, etc
  • Resources - create resources like SDS sheets or SOPs
  • Resource Tags - create tags for resources


Within the control panel of your KPA EHS site, there is an in-depth documentation page explaining exactly how to format your dataload spreadsheet. This document includes column names, column descriptions, examples, and sample spreadsheets that you can download and use as a template.

Dataload Instructions
Detailed instructions on how to create a dataload file
Dataload Types Of Data
Load over a dozen types of data via spreadsheet
Dataload Columns And Sample
The dataload documentation explains columns & provides templates

Adapters & Automation

In some cases you might be pulling data from another system and would prefer not to convert it to the KPA EHS format each time. For an additional cost, the KPA EHS development team can create an "adapter" which will automatically convert your existing spreadsheet into a format that will be accepted by KPA EHS.

Dataload files can be loaded through the web application, but they can also be uploaded via the free KPA EHS API. This gives your IT group a free option for automating the process of loading employee profiles, assets, training information, etc.

If the API is not an option, the KPA EHS development team can also setup a secure FTP dropbox (for an additional cost). The KPA EHS system will automatically load data files from that dropbox as dataloads. You can also setup email notifications for failed and/or successful data loads.

Top Control Panel Features

Check out the Control Panel Overview or learn about specific features:


Employee Management »

Search and manage employees and view team member profiles including open tasks, training, recent reports, and more


Roles & Permissions »

Create your own roles and define choose from over 100 permissions for each role type


Scheduled Reports »

Schedule daily/weekly/monthly email reports to be sent to you and your team including recent reports, pending follow-ups, training status, inspection status, and more


Import Data »

Load large amounts of data through spreadsheets including employee profiles, training history, assets, inspection history, and more



The free KPA EHS API offers your IT group programmatic access to KPA EHS data



Change KPA EHS's default wording to match your preferences. For example, you may prefer 'Project' instead of 'Field Office'



See which employees have an upcoming hire date anniversary


Employee Settings

Setup custom fields, default timezones, default message settings, and configure the welcome email



Give other companies limited access to view your employees and/or asset inspection status


Data Lists

Create and update lists of information used in forms - such as well-sites, rigs, projects, etc


New-Hire Evaluations

Setup automatic evaluation schedules for new-hire employees


Audit Log

Research changes to your data throughout the KPA EHS application including change agent, date, and what was changed


Form Builder »

Build forms for your team to fill out including photos, signatures, and more


Training »

Setup your training requirements and let the system assign tasks and track status


Acknowledgments »

Send out acknowledgment tasks for your team members to sign off on


Assets & Inspections »

Schedule and assign asset inspections to your team

KPA EHS in 60 Seconds

Watch this quick overview of the KPA EHS system.

10 Minute Walk-through

Watch this walk-through of the KPA EHS system.