Export Guide
Export your clients using the Time59 Export menu, then manually capture your Projects list. Combine both into a single CSV and use the CaseClock CSV Normalizer to prepare it for import.
← All export guidesWhat to export
Clients via Export menu and Projects via manual copy from the list view
Estimated time
~15 minutes
Difficulty
ModeratePart 1
Time59 includes a built-in Export menu for client records. This is the cleanest export available in the application.
Log in to Time59.
Go to the Export section in the main navigation or Settings menu.
Select Export to Excel.
Choose Clients as the data type to export.
Click Export and download the file.
Open the downloaded Excel file and review the columns — you should see client names, client IDs (if your firm uses them), email addresses, and any other client details stored in Time59.
Save the file as CSV (File → Save As → CSV).
Part 2
Time59 does not include a direct export for the Projects list. Use the copy-and-paste method below to capture this data.
Open your Projects list in Time59. This is the list of all active and closed matters/files.
Select all projects visible in the list (use Ctrl+A or Cmd+A if available, or select all rows manually).
Copy the selected data to your clipboard.
Open a blank Excel spreadsheet and paste the data.
Add a header row if one is not pasted automatically — at minimum include: project name, client name or ID, and any matter identifiers visible in the list.
Review and clean the pasted data, removing any extra rows or formatting artifacts.
Save the spreadsheet as CSV.
Combining the two files
Once you have both CSVs — one for clients and one for projects — you can combine them in Excel using VLOOKUP or INDEX/MATCH to join client names from the clients file into the projects file by client ID. Alternatively, upload both files to the CaseClock CSV Normalizer, which supports multi-file imports.
Column reference
| CaseClock field | Time59 source |
|---|---|
| client_id | Client ID from the Clients export, if your firm uses client IDs in Time59 |
| client_name | Client name from the Clients export |
| matter_id | Project/matter ID from the Projects list, if visible |
| matter_name | Project name from the Projects list |
| practice_area | Not typically included in Time59 exports — add manually if needed |
| billing_lawyer | Not typically included in Time59 exports — add manually if needed |
| jurisdiction | Not included — add manually if needed |
| billing_rate | Not typically included in Time59 exports — add manually if needed |
Time59's exports include fewer columns than more full-featured practice management systems. Fields like practice area, billing lawyer, and billing rate may need to be added manually in Excel before importing.
Software interfaces change over time
If these steps don't match what you see in Time59, the vendor may have updated their interface since this guide was written. Our support team is happy to walk you through it.
Contact support →Next step
Run your exported CSV through the free CaseClock CSV Normalizer to map your columns to CaseClock format. It runs entirely in your browser — nothing is uploaded or stored.
Start your 45-day free trial. No credit card required. If you have questions about your setup, book a support call.
45-day free trial. No credit card. Cancel anytime.
