# Exporting hours for a single employee

## Instructions for exporting time and attendance records for a single employee over a custom or extended date range.

_Last updated_ - _Apr 17, 2024 at 10:45AM_

Follow these steps to export timehseet hours for a custom date range and for a single employee:

01. In your TimeDock web dashboard, navigate to _Setup > Employees_.

02. Find the employee that you want to export hours for and click on the _Edit_ button at the right-hand end of the record row.

If the employee has previously been deleted/archived, you will first need to temporarily [restore](/content/help/advanced/employees/restore-deleted/index.html) the employee.

03. Enter a temporary _unique_ value into the employee _Department_ textbox and click _Save_.

Append the employee's unique _Payroll ID_ with a hyphen e.g. _WAREHOUSE-014_. This will make it easy to revert the department code back to the original value after you've completed your export.

04. Navigate to _EXPORT > Custom CSV_.

05. Use the _From_ and _To_ fields to select your date range.

The maximum date range is 3 months. If you want to export hours for a larger range than this, you'll need to download multiple export files, adjusting the _From_ and _To_ fields each time. See _step 9_ below for how to consolidate data from multiple export files into a single file.

06. In the _Department_ dropdown box, select the unique department code you entered for the employee in _step 3_.

07. Select the data columns and consolidation type you want to use, or select from an existing template. See [Custom CSV export](/content/help/advanced/custom-export/index.html) for more info.

08. Click on the _Export to CSV_ button to download the hours for your selected date range.

09. If you're performing multiple exports for _more than a 3 month period_, follow these steps to consolidate into a single export file:

1. Open a new Excel Spreadsheet.
   2. Open each of your CSV export files in Excel.
   3. Copy the rows from each CSV export file and paste into your new Excel spreadsheet. Ensure to do this in the appropriate date range order.
   4. Save the Excel file.
   5. You now have a single Excel file for your desired date range.
10. Repeat _steps 1 to 3_ above to revert the employee's department code back to its original value.