Plans 💳 : Everyone
User Permissions 👥: Everyone
For legacy plans, please refer to the article here.
Timely lets you create beautiful Shared Reports for clients and colleagues, as well as simply documenting Timely data for your own records. So it makes sense they can also be exported in Excel, PDF and CSV formats to suit different needs. Here's how to go about exporting! 📁
Create a Report
From the Reports page, create a custom report and select your desired filters from the options along the top. Once you've set your preferences and saved your report, click the “Export” option in the top right hand corner.
Before selecting your preferred file format, you need to select/deselect the columns you want to include in the report under the “included columns” section.
If you’re an admin user and would like to customize the order of those columns for an export, click the “manage column order” button at the very bottom. Any updates to this column order will apply to the entire workspace.
Note: When exporting data from a custom report, you'll want to double-check that the included columns selected are relevant and necessary to the report in question. For example, removing the hours data source in the report won't automatically uncheck the hours columns in the export. You'd want to uncheck those unneeded columns for a more concise export.
Export your Report
Once you've made your column selections, choose the file format you want (Excel, PDF or CSV) and save your report to your desktop:
There are three export formats available within Timely:
Each of these can serve or be used for different purposes depending on the type of work you do or the type of company you’re a part of.
Your .csv exports can be downloaded an opened in tools like Excel or Google Sheets with the raw data from the report you’re exporting. These are especially handy if you want to pipe your data into other tools to visualize your information. Likewise, if you already have templates built in Excel or Google Sheets, you can reference the cells, rows or columns to work with formulas you’ve already written to help you incorporate and present Timely data in a way that helps your team.
Downloading reports as .xls files can be great if you’re looking to slice and dice data in Excel via pivot tables and get going with the information right away. Simply having the numbers isn’t enough, so being able to break them down further with Excel’s extended suite of tools can help you make more accurate data-driven decisions faster!
Note: In order to display more relevant information in our .xls and .csv reports, we’ve added columns and reformatted the layout, which may affect any custom templates or formulas you’ve created that connect Timely data with other sources. To give you time to adjust the changes, legacy versions of our .xls and .csv exports will be available until April 1, 2021. All new workspaces created after December 1, 2020 will not have access to legacy reports.
PDFs are great in that they’re simple and clean. If you bill your hours, using a PDF export is a simple way to grab information for a client — either as an invoice or as proof of hours worked. If you don’t bill your hours, PDF exports can operate as simple timesheets to be used for internal tracking, 1:1 meetings or stakeholder updates for projects in progress.
Note: If Timely thinks your report is too large to download directly, it will send it to your Timely-registered email address within a few minutes. You'll see this notification:
Exporting timesheet reports
If you need to quickly create and export timesheets for yourself or your team, you can do so from the dedicated “Timesheets” tab within Reports as well. Simply set the date rate and select users, projects and tags to gather the info you need. Hit “Export” to download the report as an XLS, CSV or PDF file and you’re done!
Exporting Tasks reports
With the introduction of Timely's fantastic Tasks add-on feature came the need for more granular data on how time is being logged and the status of individual Tasks towards completion. With that in mind, you can now perform an export of that data and customize your export file to suit most any needs.
To get started, head on over to the Reports Dashboard in Timely and edit or create a fresh report for the desired date range and filters. From there, click the "Export" button in top right hand corner and then click the "Tasks" option from the menu. You can select the different columns to include the corresponding data points and click either the "Export as Excel" or "Export as CSV" option to generate your file. The file will then download just like your regular Hours exports.
Workspace level export options
Report Column Order
Workspace admin's have the ability to set the default order for report columns when creating files in the Excel and CSV file format. You'll just need to head over to the Settings section in Timely and click the "Workspace" header. Scroll down a bit and you'll see the various column titles available under the Hours and Tasks options, go ahead and click on the ::: dots icon to drag and drop those columns to suit your needs.
Note: Any changes to order here will affect the entire workspace, not just your individual user account.
Export multiple Timestamps
We know some folks love taking a deep dive into their data and getting a birds-eye view of their operations. With that in mind, we now offer the ability to export the individual time stamps from entries where applicable.
Enabling this option does affect the default columns in the export file for Excel or CSV, so just keep that in mind if you use any macros, automations, or formulas with these files regularly.
Important note - Once this workspace wide feature is enabled, it is permanent and can not be rolled back.
Workspace admins have the option in how they would like unselected columns to display when exporting.
For those that have complex macros or workflows that require the persistent presence of a column, regardless of data, they can choose to have that column be "included as blank". Meaning the column will still show up in the export, but the data will not.
For those that may like a clean and streamlined spreadsheet, you also have the option to "remove entirely" so that the column is hidden in the resulting file.
Workspace admins can also choose the default behavior for the handling of Tag lists in Excel or CSV export files. You can elect to display both the individual Tags and the overall Tag list they are associated with, just the individual Tags, or just the overall Tag list name.