Guide

Training Records Software for Audits: Inspect the Exports

To evaluate training records software for audits, inspect the exported rows and the original evidence separately. In TrainGrid, a matrix CSV shows a selected view, an Employee Transcript follows one employee, and an Assignments Report covers filtered records. Check the column lists, access permissions and export limits before treating a file as complete.

Updated November 14, 20266 min read
A plant's loading docks lit at dusk, the yard wet after rain.

For a manufacturing training review, start with the evidence request: which employees, courses, versions and dates need to be covered? Then choose the output that answers that request. A status grid, a record list and a supporting document answer different questions.

Primary sources, accessed November 13, 2026: US federal OSHA's powered industrial truck certification requirements and lockout/tagout training certification requirements. These illustrate why the required evidence depends on the work: the former calls for operator identity, training and evaluation dates, and trainer or evaluator identity; the latter calls for employee names and training dates. These are US general-industry examples, not worldwide rules or legal advice.

Choose the output that answers the request

These are separate outputs in TrainGrid. CSV export depends on permission, and access to records remains limited by your workspace permissions and location scope. Where available, printing has its own permission.

Scroll the table sideways to compare all columns.

OutputUse it to inspectScope and limits
Matrix CSVThe course or week view shown on the matrix.Visible employees and columns only. Filters and row or course-column limits can make this a partial view.
Employee TranscriptOne employee's course versions, training dates, results and assessment fields.The selected employee's accessible records. The CSV does not include the employee identity block shown on screen and in print.
Assignments ReportRecords across employees and courses, including incomplete work.The selected view, filters and location scope; at most 5,000 rows. Date filters apply to the due date.
Audit-log CSVRecorded changes, including actor and before-and-after values.Audit-log access and CSV export permission are both required. At most the most recent 5,000 matching entries.
Original attachmentsThe supporting file attached to a training record.Open or download each file separately with authorized access. Files are not embedded in any of these CSVs.

Use the reports guide to find the report you need. Keep a note of the employee or filters selected and when you exported the file. Do not assume the CSV itself contains every label shown around the on-screen report.

Inspect the exact CSV column lists

The lists below reproduce TrainGrid's export headers in column order, checked November 14, 2026. They are a field reference, not a sample export of anyone's records. Course and week headers in the matrix are generated from the selected view.

Matrix CSV: by course

Column order: Employee, Employee #, Department, one column for each visible course, Completed, Assigned, Overdue.

Each course header is its code followed by its title, with (v<version>) appended when a version is present. Course cells follow the selected Training, Competency or Qualification view. The Completed, Assigned and Overdue totals remain training totals; they are not counts of practical qualifications.

Matrix CSV: by week

Column order: Employee, Employee #, Department, one column for each displayed week label.

Week cells contain completed-of-total counts. Both matrix layouts include Employee # after Employee.

Employee Transcript CSV

Columns: Course code, Course, Version, Category, Status, Due date, Completed on, Grade %, Instructor, Recorded by, Certificate expires, Competency, Qualification, Assessor, Assessed on.

The employee's name and number appear in the report header, not as CSV columns. Keep the file associated with the selected employee. The Version field identifies the course version attached to the record. Competency and Qualification are blank when the course has no competency requirement.

Assignments Report CSV

Columns: Employee, Employee #, Course, Course code, Version, Department, Location, Due date, Status, Completed on, Grade, Training hours, Instructor, Certificate expiry, Competency, Qualification, Training source, Waive reason, Notes.

The export follows the selected view, search, course, department, location, training source and archived-employee setting. It carries the selected sort. The From and To dates filter Due date, not Completed on. Check that distinction before requesting a period of completed training.

Audit-log CSV

Columns: Timestamp, Actor, Action, Entity, Record, Record ID, Before, After.

Action, entity and date filters carry into this export. Timestamps and date boundaries use the workspace time zone. Before and After contain the recorded values for the change; they are not copies of the supporting files. See the administration guide for audit-log access.

Check completeness before handing over a file

  • Matrix: filters, hidden course columns or a capped employee list produce a filename marked -partial. A row or column cap also prompts a warning before export. Narrow the filters or use the Assignments Report for the requested record list; check that report's limits too.
  • Transcript: select the intended employee, including archived staff when needed. Records are fetched across pages. If the report reaches its retrieval ceiling, it errors rather than handing back a silently truncated transcript.
  • Assignments: an export above 5,000 matching rows is capped, marked -partial and accompanied by a warning. Divide the request into smaller filter sets and check each result.
  • Audit log: the export stops at the most recent 5,000 matching entries and warns when older matches were omitted. Narrow the date range to obtain an earlier slice. Do not describe one capped file as the entire change history.
  • Permissions: confirm the reviewer can access the required records and files. An absent row may reflect a filter, a limit or access scope; it is not proof that training never happened.

Open the original evidence separately

From a training record's View details panel, use the download control beside the attached file. TrainGrid opens a temporary signed download URL. Save and open the original file as needed; do not use that temporary URL as a permanent public evidence link.

Compare the file with the record: the course and version, completion date, instructor and any assessment evidence. Then inspect the relevant audit-log entry when a correction needs explanation. These checks are a review process, not a one-click audit bundle or ZIP.

  1. Write down the requested population, courses, versions and period.
  2. Export the appropriate rows and check the headers, row count, filters and any partial warning.
  3. Open the original attachment separately and confirm it supports the selected record.
  4. Keep training completion separate from assessment and qualification.
  5. Review a correction's actor and before-and-after values, recording any unresolved gap.

Keep the export's meaning within its limits

A current matrix is not an automatically reconstructed picture of compliance on a past date. An audit-log CSV helps explain recorded changes; it does not validate a digital signature or create a signed audit dossier. TrainGrid does not provide 21 CFR Part 11 validation, and an export does not guarantee that an audit will pass.

For the wider buying decision, use our training records software checklist. The audit preparation guide covers the evidence process, while the matrix audit checklist covers reviewing requirements and gaps. This page is the export field and limit reference.

Set retention requirements for the work using the retention guide, and review the security information and current plans before choosing a system.

Frequently asked questions

Does a training records CSV include the attached evidence?

No. TrainGrid's matrix, transcript, assignments and audit-log CSVs contain rows and fields, not the original attachments. Download attached files separately from the training record. A temporary download URL is not a permanent public evidence link.

Does Export CSV include every training record?

The scope depends on the output and your access. A matrix CSV contains its visible, filtered view. An Employee Transcript covers the selected employee. Assignments exports follow the filters and stop at 5,000 rows; audit-log exports contain at most the most recent 5,000 matching entries. Check the scope and any partial-export warning before relying on a file.

What does the audit-log export prove?

It helps review recorded application changes using the actor, action, record and before-and-after values. It does not automatically reconstruct past compliance or validate a digital signature. Compare the change history with the training record and original evidence; no export guarantees audit acceptance.

See it on your own training data

Add one employee and one course, then assign a due date to see its status. You can also explore with sample data before adding your own records.

Start a free trial
Keep reading