Skip to main content
The bulk import tool lets you create multiple client and site records at once by uploading a spreadsheet. Each row in the file represents one site — company details are repeated on each row for any sites belonging to the same client. To start an import, go to the Clients page, click the ··· menu in the top-right, and select Import Clients.

Step 1: Upload file

Drag and drop your file into the upload area, or click Browse to select it from your computer. Accepted formats: .xlsx, .csv
The import supports a statement of values format — one row per site, with company-level fields (name, address, currency, etc.) repeated on each row for sites belonging to the same client. TruRisk will group rows by company name and create the client and site records accordingly.

Step 2: Map fields

TruRisk automatically attempts to match your file’s column headers to the corresponding fields in the platform. The mapping screen shows three columns: For each field you want to import, click the ✓ (tick) button to confirm the mapping. Only confirmed mappings are imported — any field left unconfirmed is ignored, even if it was auto-matched. Required fields (marked with *) must be confirmed before you can proceed. The required fields are: The remaining fields are optional — confirm any that you want to include in the import.
If a column in your file doesn’t auto-match, use the Header dropdown for that field to select the correct column manually.

Step 3: Preview import

Review the records that will be created before committing. This step shows a summary of the clients and sites TruRisk has parsed from your file, along with any warnings about rows that couldn’t be matched or mapped.

Step 4: Review results

After the import runs, a results screen shows which records were created successfully and which (if any) failed, along with the reason for each failure. To fix errors, correct the relevant rows in your file and re-run the import. Only clients and sites that were not successfully imported previously will be created — records that already exist in TruRisk are ignored, so re-importing won’t create duplicates.
The import only creates new records. It does not update existing clients or sites. If a client or site with the same name already exists, that row will be skipped.

Supported fields

Company fields

Sector values

The Company Sector value must match one of the following exactly, including spacing and punctuation. These are the same options as the Sector field when editing a client.
Sector is optional on import so that a client isn’t rejected just because its sector isn’t on the list. If the sector is left blank, or the value doesn’t match one on the list, the row still imports and the client is created without a sector. Sector is required on the Edit Client form, though, so you’ll need to choose one the next time you edit the client’s details.
  • Accountant
  • Agricultural
  • Agriculture
  • Agrifood
  • Aquaculture
  • Architect
  • Association
  • Auctioneer and Valuer
  • Bio-Tech
  • Bluewater Operators
  • Building Contractors inc D & C
  • Car Dealerships
  • Care
  • Care Home Corporate
  • Charity
  • Chemical Industry
  • Chemicals
  • Chemicals & Plastics
  • Chicken Processing
  • Civil Work
  • Commercial Fishing Operations
  • Computing and IT Consultants
  • Construction
  • Construction - Miscellaneous
  • Construction Services
  • Consultant - General
  • Dairy Producer
  • Doctors Surgery
  • Domiciliary Care
  • Domiciliary Care Corporate
  • Downstream
  • Dredging / Wet Construction
  • Education
  • Egg Processing
  • Energy Management
  • Engineer - Civil
  • Engineer - Consultant
  • Engineer - Electrical
  • Engineer - Mechanical
  • Engineer - Multi discipline
  • Engineer - Structural
  • Equestrian Bloodstock
  • Factory
  • Financial Adviser
  • Financial Services
  • Fine Art & Antique Dealers
  • Fuel Storage
  • Fund Manager
  • Garden/Landscape
  • Government
  • Gym Sector
  • Health and Leisure Club
  • Health and Safety Consultant
  • High Technology
  • Hog Producer
  • Hospitality
  • Hotel
  • Hydro Power
  • Inland River Tug & Barge Operations
  • Ins. Company
  • Interior Designer
  • Investment Fund or Trust
  • Laboratories - Asbestos
  • Laboratories - Other
  • Large Business
  • Legal Consultant
  • Leisure
  • Livestock
  • Luxury Goods
  • Management Consultant
  • Manufacturing
  • Manufacturing - Electronics
  • Manufacturing - Food & Drink
  • Manufacturing - General
  • Manufacturing - Health Food & Drink
  • Manufacturing - Metal Forming
  • Manufacturing - Plastics
  • Meat Processing
  • Media and Advertising
  • Media Marketing
  • Medical Devices
  • Medical Profession
  • Micro Care Home
  • Micro Doctors Surgery
  • Micro Domiciliary Care
  • Midstream
  • Mining
  • Misc. Profession - Commercial
  • Misc. Profession - Other
  • Mitigation
  • Motor Trader
  • Museum
  • Natural Resources
  • Not For Profit Company
  • Not In Employment
  • Office
  • Offshore Supply Vessels & Workboats
  • Other
  • Pharmaceutical
  • Plant Hires
  • Port Authorities
  • Ports
  • Power & Energy
  • Printer - Copying Services
  • Printer - General
  • Printer - Imaging Centre
  • Property Consultants
  • Property Developers / Construction
  • Property Owners
  • Property Services - Miscellaneous
  • Public Entity
  • Public House
  • Publisher
  • Pubs & Restaurants
  • Pulp & Paper
  • Real Estate
  • Recruitment Consultant
  • Renewables
  • Restaurant
  • Retail
  • Retail, Distribution & Logistics
  • Retail Shop
  • Retired
  • Scheme
  • Shippers and Packers
  • Shops (Various including food)
  • SME
  • Solicitors
  • Space (pre-launch)
  • Specialty
  • Sport and Wellness
  • Sports
  • Sports Club or Association
  • Sports & Leisure
  • Sports - Professional
  • Steel
  • Stockbroker
  • Surveyor and Valuation
  • Taxi
  • Technology - Other
  • Telecoms
  • Textiles
  • Transportation Systems
  • Transport - Logistics
  • Travel & Tourism
  • Trustee and Trust Company
  • Upstream
  • Utilities
  • Vessel & Offshore Construction
  • Waste Recycling
  • Wholesale
  • Woodworkers

Site fields