- Using SafetyCulture
- Reports
- Inspection CSV and Excel export header guide
Inspection CSV and Excel export header guide
Gain an overview of key headers and their descriptions in inspection CSV, CSV with media, and Excel exports.
This article outlines the data structure of inspection exports in CSV, CSV with media, and Excel formats via the web app. If you exported your inspections to CSV using the SafetyCulture Exporter, you can learn more about its CSV data structure in our developer portal.
Format limitations
"Signature" response type questions and "Media" attachments are included only in CSV with media format.
Attachments in "Instruction" and "Annotation" response type questions aren't included.
Actions created in inspections are not included.
Excel and CSV export format
The column headers for the type of responses in the table below are question labels, which can be customized in the template editor. For example, "Conducted On" of column header "Title Page_Conducted On" is the question name or label.
Column header | Type of response | Description |
|---|---|---|
auditID | N/A | The unique identifier of an inspection. |
auditName | N/A | The name or title of an inspection. Learn how to create naming conventions for your inspections. |
templateID | N/A | The unique identifier of an inspection's template. |
templateName | N/A | The title of an inspection's template. |
author | N/A | The last user who edited an inspection. |
owner | N/A | The owner of an inspection. The owner can be changed or reassigned. |
Title Page_Site Conducted_Location | N/A | The selected site of an inspection. |
Title Page_Site Conducted_Area | N/A | The selected site area of an inspection. |
Title Page_Site Conducted_Region | N/A | The selected site region of an inspection. |
Title Page_Site Conducted_State | N/A | The selected site state of an inspection. |
Title Page_Site Conducted_Country | N/A | The selected site country of an inspection. |
Title Page_Conducted On | Inspection date | The selected date and time of an "Inspection date" response question, displayed in the Coordinated Universal Time (UTC). For example, "29/07/21 03:57 am". |
Title Page_Prepared By | Person | The person who conducted an inspection. This field pre-populates the name of the user who started the inspection but can be modified. For example, "John Smith". |
Title Page_Document ID | Document number | The document number of an inspection. For example, "DOC000012". |
Title Page_Location | Inspection location | The location address and coordinates of an inspection. For example, "2 Lacey Street, Surry Hills, NSW 2010, Australia "(-33.8851769713,151.211334728)". |
Title Page_Asset | Assets | The selected asset of an inspection. For example, "5RJU09 Truck". |
All response types_Text Question | Text answer | The short answer or paragraph response of a question. For example, "Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.". |
All response types_ Number Question | Number | The number or temperature response of a question. For example, "123456". |
All response types_Checkbox | Checkbox | The checkbox response of a question. For example, "Checked = TRUE, "Unchecked = False". |
All response types_Multiple Choice | Response sets | The selected responses of a multiple-choice question. For example, "Pass or Fail". |
All response types_Multiple Choice-comment | All response types | The notes of a question. |
All response types_Date and Time | N/A | The selected date and time of a "Date & Time" response question, displayed in the Coordinated Universal Time (UTC). For example, "20/3/2023 1:00:00 pm". |
start | N/A | The date and time that an inspection was started, displayed in the Coordinated Universal Time (UTC). For example, "21/3/2023 8:30:51 am". |
lastUpdate | N/A | The date and time that an inspection was last modified or edited, displayed in the Coordinated Universal Time (UTC). For example, "21/3/2023 8:35:14 am". |
completed | N/A | The date and time that an inspection was completed, displayed in the Coordinated Universal Time (UTC). For example, "21/3/2023 8:40:00 am". |
score | N/A | The achieved score of an inspection. For example, "8". |
totalScore | N/A | The maximum achievable score of an inspection. For example, "10". |
The date and time format in your exported CSV or Excel file will appear according to the settings on your device. You can customize this data with your preferred format via the app or software you’re using to view the file.
CSV with media format
The CSV file is divided into two sections: the template and inspection details, and the inspection questions and responses in which the latter can be customized in the template editor.
Template and inspection details
Row header | Type of response | Description |
|---|---|---|
template_id | N/A | The unique identifier of an inspection's template. |
template_name | N/A | The title of an inspection's template. |
audit_id | N/A | The unique identifier of an inspection. |
audit_started | N/A | The date and time that an inspection was started, displayed in Unix Time. For example, "1741589659". |
audit_completed | N/A | The date and time that an inspection was completed, displayed in Unix Time. For example, "1741589687". |
audit_duration | N/A | The inspection duration, displayed in seconds. For example, "5294" which equates to roughly 1 hour and 28 minutes. |
audit_title | N/A | The name or title of an inspection. Learn how to create naming conventions for your inspections. |
audit_preparedby | N/A | The owner of an inspection. The owner can be changed or reassigned. |
audit_location | Inspection location | The location address and coordinates of an inspection. For example, "2 Lacey Street Surry Hills NSW 2010 Australia "(-33.8851769713, 151.211334728)" |
audit_latitude | N/A | The latitude of the inspection location. For example, "151.211334728". |
audit_longitude | N/A | The longitude of the inspection location. For example, "-33.8851769713". |
audit_site | Site | The selected site of an inspection. |
audit_area | Site | The selected site area of an inspection. |
audit_region | Site | The selected site region of an inspection. |
audit_score | N/A | The achieved score of an inspection. For example, "8". |
audit_total | N/A | The maximum achievable score of an inspection. For example, "10". |
audit_percentage | N/A | The score of an inspection in percentage. For example, "80%". |
Inspection responses
Column | Description |
|---|---|
ID | The unique identifier of a question. |
Type | The response type of a question. |
Label | The label of a question as entered in the template editor. |
Options | The responses available for a question. |
Parent | The unique identifier of a page or section where a question is located. |
Primary | The response entered or selected for the question. |
Secondary | Additional information for a response entered or selected for Location (location text and coordinates) and Signature (response time displayed in Unix format) response questions. |
Media | The unique identifier of the media attached to the question. |
Note | The notes of a question. |
Export file structure
The files are organized and nested in the following way:
Excel and CSV
If inspections from different templates are exported together, multiple worksheets will be available in a single Excel file.
Each inspection Excel file is named in the format of "audit_excel_YYYYMMDDhhmmssTTT.xlsx". For example, "audit_excel_20230321111352UTC".
CSV with media
If inspections from different templates are exported together, separate CSV files will be placed in folders along with their respective media.
Each CSV file is named after the inspection ID.
Frequently asked questions
Every question will have the page name and if applicable, the section name included as the header. For example, the question "Has the paint been applied already?" on the "External Check" page, nested within the "Veranda" section, it would show as:
CSV: "External Check_Veranda_Has the paint been applied already?".
Excel: "All response types_External Check_Veranda_Has the paint been applied already?"
In CSV with media, the "Parent" column contains the unique identifier of the page or question where the question is located. For example, "f3245d39-ea77-11e1-aff1-0800200c9a66".
As the CSV export option exports all raw data from inspections, this means all questions are exported, regardless of whether they are answered or not, including un-triggered logic field questions.
No, that is not possible. The CSV and Excel export options exports all data from inspections.
For CSV export, multiple versions of templates are not supported. Bulk exporting inspection reports in CSV will fail if there are inspections conducted with templates that have been edited in the past. For Excel export, multiple versions of templates are supported.
This usually happens because of the regional settings in your spreadsheet program. To fix it, set the delimiter to a comma so the values are correctly separated into columns. You can follow the Microsoft Excel guide or the Google Sheets guide to adjust your settings.
Was this page helpful?
Thank you for letting us know.