The CSV export option allows users to export up to 10,000 inspections in bulk, from either single or multiple templates. This can be very useful if you want to perform a "data dump" of your organization's inspection data, or simply wish to assess results in bulk. As you would be working with raw data when exporting inspections to CSV, we understand that it can be difficult to interpret the data in some cases.

This article helps explain the data structure of inspection CSV exports, by outlining column headers you may see and what each header means.

Before you begin

Please note that this article outlines the data structure for inspection CSVs exported from the iAuditor web app. If you exported your inspections to CSV using the iAuditor Exporter tool, you can learn about its CSV export column headers in the installation guide.

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 HeaderType of ResponseDescription
audit_template_idN/AThe unique identifier of the inspection template
audit_idN/AThe unique identifier of the inspection.
audit_ownerN/AThe owner of the inspection. The owner can be changed or reassigned.
audit_authorN/AThe user who started the inspection.
audit_siteN/AThe selected site of the inspection.
audit_areaN/AThe selected site area of the inspection.
audit_regionN/AThe selected site region of the inspection.
Title Page_Conducted OnInspection dateThe selected date and time of the Inspection date question, displayed in the ISO 8601 format and in Coordinated Universal Time (UTC). For example, “2019-10-24T01:30:25.000Z”.
Title Page_Prepared ByPersonThe person who conducted the inspection. The field pre-populates the username of the inspection author at the start of inspections but can be modified. For example, “John Smith”.
Title Page_Document IDDocument numberThe document number of the inspection. For example, “DOC000012”.
Title Page_MapInspection locationThe location address of the inspection. For example, “2 Lacey Street, Surry Hills, NSW 2010, Australia”.
Title Page_Map-coordinatesInspection locationThe location coordinates of the inspection. For example, “-33.8851769713,151.211334728”.
Inspection_Text QuestionText answerThe short answer or paragraph response of the question. For example, “Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Aenean commodo ligula eget dolor.”
Inspection_ Number QuestionNumberThe number or temperature response of the question. For example, “123456”.
Inspection_CheckboxCheckboxThe checkbox response of the question. For example, “1 = checked/true, 0 = unchecked/false”.
Inspection_MediaPhotoThe unique identifier of the uploaded or attached images. For example, “1725f620-f904-11e9-b8ed-3d7265bf7515”. The cell displays empty if the image is not captured.
Inspection_AnnotateAnnotationThe unique identifier of the annotated image. For example, “194084d0-f91c-11e9-bffa-85b03b222693”. The cell displays empty if the image is not annotated.
Inspection_Multiple ChoiceResponse setsThe selected response(s) of the multiple-choice question. For example, “Pass or Fail”.
Inspection_Multiple Choice-commentResponse setsThe notes of the question. The cell displays empty if no notes are entered.
Inspection_Sign HereSignatureThe unique identifier of the signature image. For example, “088e7fa0-f905-11e9-b8ed-3d7265bf7515”. The cell displays empty if the signature is not captured.
Inspection_Sign Here-nameSignatureThe name response of the signature question. For example, “John Smith”.
Inspection_Sign Here-dateSignatureThe timestamp of the signature, displayed in the ISO 8601 format and in Coordinated Universal Time (UTC). For example, “2019-10-27T21:59:23.732Z”. The cell displays empty if the signature is not captured.
meta_date_canonicalN/AThe selected date and time of the Inspection date question, displayed in the ISO 8601 format and in Coordinated Universal Time (UTC). For example, “2019-10-24T01:30:25.000Z”.
meta_date_completedN/AThe date and time that the inspection was completed, displayed in the ISO 8601 format and in Coordinated Universal Time (UTC). For example, “2019-10-27T21:59:25.211Z”. The cell displays “-1” if the inspection is incomplete is not captured.
meta_date_modifiedN/AThe date and time that the inspection was last modified or edited, displayed in the ISO 8601 format, and in Coordinated Universal Time (UTC). For example, “2019-10-27T21:59:25.215Z”.
meta_date_startedN/AThe date and time that the inspection was started, displayed in the ISO 8601 format and in Coordinated Universal Time (UTC). For example, “2019-10-25T03:32:22.000Z”. This is a systematic timestamp and cannot be edited.
meta_nameN/AThe name of the inspection. Learn how to create naming conventions for your inspections.
meta_scoreN/AThe achieved score of the inspection. For example, “8”.
meta_total_scoreN/AThe maximum achievable score of the inspection. For example, “10”.

CSV export file structure

The files are organized and nested in the following manner.

  • Each CSV export is downloaded into a compressed ZIP file, in the format of “audits_csv_[datetime].zip”. For example, “audits_csv_2019.12.18-00.13.17+0000.zip”.
  • If inspections from different templates are exported to CSV together, a folder would be created within the ZIP file, in the format of “audits_csv_[datetime]”. For example, “audits_csv_2019.12.18-00.13.17+0000”.
  • Each inspection CSV file is named in the format of “[template_id].csv”. For example, “template_3e8583a325fe4d00bdedada210ff03e2.csv”.

FAQs

How do I know which page and section the question is from?

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, would show as “External Check_Veranda_Has the paint been applied already?”.

Why are my unanswered questions also showing?

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.

Can I export selected pages or sections of data?

No, that is not possible. The CSV export option exports all raw data from inspections.

Was this article helpful?

We love your feedback. Please tell us what you think.


Yes No
Care to share a bit more so we can continue to make improvements for you? Care to share a bit more so we can make this article even better for you? Thanks for your feedback!