Select Section...

Note: The following setup requires a Premium Subscription with SafetyCulture.

Overview

SafetyCulture has developed the SafetyCulture Exporter, which can export audits directly to a CSV file on your computer. The SafetyCulture Exporter can be run in looping mode to automatically export newly completed audits.

There are other available methods to export audits in CSV format via the iAuditor website, and iAuditor app. The SafetyCulture Exporter in CSV mode improves upon these options with:

  • Improved compatibility with spreadsheet software and business intelligence tools.
  • Automatic exporting of newly completed Audits.
  • Improved format that effectively conveys complex audit data like dynamic fields, list of images, and quoted text.
  • A more flexible format that gracefully handles templates that change over time. Templates that change over time disrupt the expected audit structure.
  • A more predictable format for easy parsing, database importing, and data analytics.

There is one other method to export audits in tabular format using Zapier that readers may be interested in. This method is completely automated after initial setup, runs no software on your system, and saves your audit data directly to cloud spreadsheet software like Google Sheets, or Excel Online.

See an example Zap setup here: Exporting audit data to an online spreadsheet using Zapier.

Installation and Guide

The SafetyCulture Exporter is part of the SafetyCulture Python SDK package which is available for download. To install, setup, and start exporting audits in CSV format, paste the following instructions into the terminal:

  1. pip install safetyculture-sdk-python
  2. iauditor_exporter --setup
  3. cd iauditor_exports_folder
  4. iauditor_exporter --format csv

A guide to using the SafetyCulture Exporter in CSV mode can be found here.

For existing users, update instruction can be found here.

Limitations

The SafetyCulture CSV Exporter is limited in scope.

  • Cannot restrict the CSV export to specific item types. All items are exported for each audit.
  • Cannot restrict what information is exported for each item. All information is exported for every item.
  • Cannot restrict which audits export using a template filter. In bulk export mode, all audits are exported.
  • In bulk export mode, a CSV file is created for each unique template. Audits are appended to an existing CSV file, if one exists for the audit template. If the CSV file for the audit template does not exist, a new file is created..
  • Cannot limit the CSV Exporter to only selected templates
  • If you update an Audit that has already been exported, it will be appended to the CSV file a second time

SafetyCulture customers create an enormous amount of data in the form of audits. Customers have found some amazing ways to leverage their audit data by creating visualizations, extracting key insights, identifying data trends, and more. To leverage audit data customers use spreadsheet applications (Excel, Google Sheets, etc.), Business Intelligence tools (Tableau, PowerBI, etc.), SQL databases, and more. The SafetyCulture CSV Exporter was developed with these tools in mind. It will help you get the most out of your audit data by maximizing compatibility with such tools and automating your workflow all in a format that does the heavy lifting for you.

Format

Column Header

Item Type

Description

ItemType String Item Type as selected in the template editor. This can be a question, signature, location, etc.
Label String The prompt written in the template editor. For a question item, this column contains the question itself.
Response String / Number / Boolean The item response selected in the audit.
Comment String The comment associated with this item, if a comment was added in the audit.
MediaHypertextReference String If this item contains an image, this column holds the HREF to access the media file. For more information, see https://developer.safetyculture.io/#get-media
Latitude Number If this item contains location data, this column holds the latitude of the location
Longitude Number If this item contains location data, this column holds the longitude of the location
ItemScore Number The score of this item
ItemMaxScore Number The maximum possible score associated with this item
ItemScorePercentage Number The percentage score of this item. Calculated as Item Score / Item Max Score
Mandatory Boolean True if this item is set to mandatory in the template. If not, this column is False. For more information about mandatory fields, see https://support.safetyculture.com/templates/mandatory-items/
FailedResponse Boolean Treu if the response selected for this item is selected as a failed response in the template. For more information, see https://support.safetyculture.com/analytics/failed-responses/
Inactive Boolean True if the item is made inactive by a smart field. For more information about smart fields, see https://support.safetyculture.com/templates/smart-fields/
ItemID String Unique UUID of this item. This can be used to identify like items over different audits, even if the item label changes over time.
ResponseID String Unique UUID of the response selected. This can be used to identify like responses over different audits, even if the response text changes over time.
ParentID String Unique item ID of the item this item is nested under in the template editor.
AuditOwner String The full name of the user that created this audit
AuditAuthor String The full name of the user that last edited this audit
AuditName String The name of the Audit. This is the response to the Audit Title field
AuditScore Number The score of this audit. This is the sum of the audits item scores
AuditMaxScore Number The maximum possible score of this audit. This is the sum of the audits Item Max Score values
AuditScorePercentage Number The percentage score of this audit. Calculated as Audit Score / Audit Max Score
AuditDuration Number (seconds) The number of seconds this audit took to conduct. This is measured when the Audit is conducted on a device using the iAuditor application
DateStarted String The Coordinated Universal Time (UTC) this audit was started. Format is YYYY/MM/DD HH:MM:SS
DateCompleted String The Coordinated Universal Time (UTC) this audit was completed. Format is YYYY/MM/DD HH:MM:SS
DateModified String The Coordinated Universal Time (UTC) this audit was modified. Format is YYYY/MM/DD HH:MM:SS
AuditID String The unique UUID of this audit.
TemplateID String The unique UUID of the template this audit is built on
TemplateName String The name of the template this audit is built on
TemplateAuthor String The full name of the author of the template this audit was built on
ItemCategory String The label of the Section or Category this item is nested under in the template.
DocumentNo Number The Document number of this audit. The document number is a header field. For more information about header fields, see https://support.safetyculture.com/templates/header-fields/
ConductedOn String The date and time this audit was conducted. Conducted On in Coordinated Universal Time (UTC). This is a header field. For more information about header fields, see https://support.safetyculture.com/templates/header-fields/
PreparedBy String Response to the “Prepared By” header field. For more information about header fields, see https://support.safetyculture.com/templates/header-fields/
Location String Respnse to the “Location” header field. For more information about header fields, see https://support.safetyculture.com/templates/header-fields/
Personnel String Response to the “Personnel” header field. For more information about header fields, see https://support.safetyculture.com/templates/header-fields/
ClientSite String Response to the “Client/Site” header field. For more information about header fields, see https://support.safetyculture.com/templates/header-fields/