Skip to main content

How do I export timesheets to CSV on the dashboard?

You can download timesheets from the Assignar dashboard as a CSV file to open in a spreadsheet or load into payroll.

You can download timesheets from the Assignar dashboard as a CSV file to open in a spreadsheet or load into payroll. There are three CSV exports: activities from the Condensed list, your chosen columns from the Expanded list, and a week of coded time from the Weekly Summary. You need Timesheets and Dockets in your User Access settings, plus Manage Payroll for the Weekly Summary.

Your company can rename some words in Assignar, so you might see different words for Timesheet, Worker, Activity or Allowance.

Video (3:26): Exporting timesheets to CSV.

Export activities from the Condensed list

To export a CSV with one row per activity on the Assignar dashboard:

  1. Go to Field Data > Timesheets, on Full View > Condensed.

  2. Set the date range, By Status and any search or filters. The export includes exactly the timesheets the list shows.

  3. Click Export. The dashboard shows "Exporting into your browser, just a moment!", then "Timesheet(s) successfully exported! Check your Browser for the export!".

The file has these columns: Fieldworker Name, Employee ID, Date, Activity, Start Time, End Time, Duration, Job Description, WO, Client, External Client ID, Project, External Project ID, Role, External Role ID and Status. If your company uses overtime rules, it also has Pay Category and Timesheet Code, so you can see overtime split out. Duration is in decimal hours (for example 7.50), dates are like 2026-10-26 and times like 2026-10-26 07:00.

This export doesn't include comments, allowances or Office Use Only notes. Use the Expanded export for those.

Export your chosen columns from the Expanded list

To export the columns you choose on the Assignar dashboard:

  1. On Full View, click Expanded.

  2. Click Columns and show the columns you want, for example Timesheet Comment, Office Use Only, Allowances, Allowances Quantity, Pay Items, Captured Docket, Pay Category and Timesheet Code. See How do I use the expanded timesheet list and attach dockets on the dashboard?.

  3. Set the date range, status and filters.

  4. Click Export.

The CSV has one row per timesheet with the columns you're showing, in the same order.

Export a week with Assignar Generic

To export a week of coded time from the Weekly Summary on the Assignar dashboard:

  1. Go to Field Data > Timesheets > Weekly Summary and choose the week.

  2. Click Export. The Select Payroll Template window opens.

  3. Tick Include Allowances if you want allowances as extra rows.

  4. Click Assignar Generic ("Or select Assignar Generic to export your workers' Submitted and Approved Timesheets. Useful if you want to use the data for other than Payroll.").

  5. Answer any warning (see below). The file downloads.

The file has the same columns as the activities export, including Pay Category (Regular Time, Overtime or Second Overtime) and, with overtime rules, Timesheet Code. With Include Allowances, each allowance is a row with Activity set to "Allowance", Duration as the quantity, and the allowance's name and code.

Warnings before a Weekly Summary export

  • "There are 3 Timesheets that haven't been Approved." and "Do you want to go back and approve them first? As we'll only show you Approved Timesheets in the exported file." Click Go Back to approve them, or Continue Export.

  • "You have not run Overtime Rules for all Timesheets in this week." and "These Timesheets will not be included in the export." Click Cancel and run the rules, or Export.

  • "You have not applied Timesheet Codes to all Timesheets in this week" and "Uncoded Timesheets will be included in the export." Confirm or go back.

If the export doesn't download

If you see "Timesheet(s) failed to export, try again." or "File download was cancelled", try again. Check that your browser allows downloads from the Assignar dashboard. Export is greyed out when the list is empty.

Related articles

Did this answer your question?