Thursday, August 16, 2012

Exporting Timecards To Excel

Virtual TimeClock allows you to export your time clock data to a text file for analysis with your favorite text editor or spreadsheet software. Employee hours can also be imported directly into several popular payroll programs that allow time clock integration using a specially formatted export file.

Let's talk about exporting timecard reports into Excel. There are a couple of ways you can open the reports in Excel, depending on the file format you choose when exporting the data.



If it's a tab separated export file
When you right mouse click on the text file, choose Open With and then Microsoft Excel. If Excel is not a choice then you will need to select Choose Program and pick Microsoft Excel from the list.

If it's a comma separated export file
When you right mouse click on the file, choose Rename and then change the .txt extension to .csv. When you double-click the file it should open right up in Excel.

Jeff
Technical Support Team
Redcort Software, Inc.

No comments: