We understand that from time to time, you may need to export the data your team has captured on iAuditor, including actions. Either to be imported into another platform or simply for record-keeping purposes.
This article shows you how to export actions to CSV (Excel) on the web app and outlines the columns of data that are included in the exports.
Before you begin
Keep in mind that you can only export actions to CSV on the web app.
Please note that only up to 10,000 actions can be exported at once. If you have more than 10,000 actions to export, we recommend filtering your actions list to export in smaller batches.
Export actions to CSV (Excel)
- Log in to the iAuditor web app.
- Select “Actions” from the menu on the left-hand side.
- Filter the actions list to show only the actions you wish to export.
- Click the 3 vertical dots on the upper-right corner of the actions list and select “Download CSV”.
- This exports all action results, following any applied filters, to CSV.
- Open the CSV file in Excel or the spreadsheet reader of your choice.
- Repeat from step 3 for any other actions you wish to export.
CSV column headers
Please note that the “Inspection” and “Inspection item” columns of an action will not be populated in the CSV file if the relevant action is linked to an inspection that is now archived.
|Action ID||The unique identifier of the action.|
|Title||The action title.|
|Status||The action status.|
|Site||The action site.|
|Priority||The action priority.|
|Due date||The due date and time of the action, following the timezone of your computer system setting.|
|Assignee||The action assignee.|
|Inspection||The title of the linked inspection. This is not applicable for standalone actions.|
|Inspection ID||The unique identifier of the linked inspection. This is not applicable for standalone actions.|
|Inspection item||The relevant question label of the linked inspection. This is not applicable for standalone actions.|
|Created by||The user who created the action.|
|Created||The date and time the action was created at, following the timezone of your computer system setting.|
|Last updated||The date and time that the action was last updated at, following the timezone of your computer system setting.|
|Template ID||The unique identifier of the template used for the linked inspection. This is not applicable for standalone actions.|
|Description||The action description|