The following setup requires a Premium Subscription with SafetyCulture.
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.
- 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:
pip install safetyculture-sdk-python
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.
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.
|ItemType||String||Item Type as selected in the template editor. This can be a
|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
|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
|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
|AuditScorePercentage||Number||The percentage score of this audit. Calculated as
|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.
|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/|