Plans 💳 : Premium, Unlimited, Unlimited+
User Permissions 👥: Admins
Optional Add-ons: None
For legacy plans, please refer to the article here.
🧐📺 Looking for a visual deep dive of CSV Imports? Check out our Timely Academy page for fantastic overviews, in-depth demonstrations, and helpful context as you explore.
🔍 Overview
Managing data in Timely just got a whole lot easier! We’re excited to introduce Self-Service CSV Imports, a powerful new tool that helps workspace admins quickly add and update users, projects, and tags—without all the manual work.
If you’ve ever needed to onboard a large team, reorganize project structures, or clean up your workspace, you know how time-consuming it can be. With this new feature, you can upload your data in bulk using simple CSV files, making setup and ongoing management more efficient than ever.
We’ve built this feature from the ground up with flexibility in mind! You can map your data exactly where it needs to go, preview changes before they’re applied, and even catch errors before they cause any headaches. Plus, every import is logged, so you can track what’s been updated and make adjustments as needed.
This is all about giving you more control over your workspace—so you can spend less time on admin work and more time getting things done. Let’s dive in!
In this article we'll discuss:
❓FAQs
🚀 Getting Started
You’ll find the new CSV Imports section conveniently located in your Timely Settings, with the other admin options. From here, you'll see your workspace's import history and status at a glance, as well as the "+ New Import" button to begin a new import.
Using this process you can create new objects—such as projects, tags, or users—or modify existing data to better reflect changes in your workspace. Whether you’re building out your team structure, updating tag groupings, or populating client project lists, this feature is designed to streamline those tasks.
⚠️ Important Note: Any changes made through the CSV import process are permanent and cannot be automatically rolled back or reverted.
Please take extreme care to review the instructions and templates provided to ensure your data is accurate before proceeding.
Next up, we’ll cover how to navigate the CSV Import process step-by-step, including preparing your files, mapping data, and reviewing results. Let’s get started! 🚀
🛠️ Starting a New CSV Import
1️⃣ Download & Prepare Your Import Template File
While you can technically use any CSV file for your import process, and map each column to an existing data field in Timely, we've put together a standard template with all the required fields. This will make the import process a lot easier and reduce the risk of any errors.
Each template includes all the columns you’ll need. You'll want to ensure that you input your data into the rows of those templates exactly as laid out in the template instructions.
You can use any common spreadsheet app, like Google Sheets or Excel, or edit and manage these files.
2️⃣ Review & Upload
Once your CSV is ready:
1. Navigate to Settings > CSV Import in Timely.
2. Click the "+ New Import" button
2. Choose the type of data you’d like to import (Projects, Users, or Tags).
3. Upload your completed CSV file using the file selector.
After uploading, you'll be prompted to review the column matching and ensure everything aligns in the next steps.
3️⃣ Map Columns & Review Warnings
During this step, Timely will help you match the columns in your CSV file to the fields in Timely. This ensures your data is imported accurately.
Carefully review the CSV column options as taken from your spreadsheet and compare them closely to the required fields in the Timely section.
⚠️ If you use any other import file besides the provided templates, Timely will attempt match your columns to the Timely fields, but you will need to adjust the mapping to ensure fidelity.
⚠️ Look closely for any errors and adjust your mapping using the drop down selector to the right of each field.
Once everything looks good, click the "Continue and review mapping" button at the bottom to proceed.
4️⃣ Process Upload & Review Outcome
After mapping is complete, confirm your import:
In this next stage you'll want to perform a final quick review to ensure that the number of objects listed along the top matches what you expect from the import file.
⚠️ If anything doesn't appear correct, click the Edit Mapping button to go back to the last step and adjust your column mapping as needed.
⚠️ If there are data issues, you can click the Cancel button to stop the process, adjust and correct your import file as needed, and then start the process again at some other point.
If everything looks good, click the Create x objects button along the top to finalize this import.
Once the import is processed, a summary will display the number of successful entries and any that encountered issues.
⚠️ Important: If you run into a mapping error, you can update your import file and re-upload it before completing the import. Just click the “Replace” button in the top right corner to swap out your file.
💡 Best Practices, Tips & Tricks
• Double-Check Your Data: Mistakes can’t be undone! Be sure to review your CSV carefully before importing.
• Use Unique Identifiers: For updating existing data, make sure the data you've input into your import file matches exactly what is already within Timely. Be careful of trailing spaces "_" or other small character issues which may throw off an exact match.
• Start Small: For larger data sets, consider running a smaller test import first to catch any potential issues.
By following these steps, you’ll be able to efficiently import and manage your data within Timely. Ready to dive in? 💻
🖋️ CSV Import File Templates & Instructions
While you can use any CSV file of your choosing to kick off the import process, and map the columns to fields, we highly recommend utilizing one of our comprehensive import templates to ensure best results.
📂 Projects Import
Template Instructions
Template Instructions
Client Name (required): Name of the client. Any valid client name.
Project Name (required): Name of the project. Any valid project name.
User Hourly Rate: The hourly rate for the user assigned to the project. Enter numeric values only.
Project Color: The project’s color code. Enter a valid hex code (e.g., #c697c0).
Project Rate Type: Choose hourly rate type:
user
,project
(default), ornon-billable
.Project Budget: The total budget allocated to the project. Enter numeric values only. Default value is 0.
⚠️
Project Budget Type
must be set tomoney
orhours
in order to specify the budget amount.⚠️ If budget amount is not set, default value will be applied, which is
0
.
Project Budget Type: Select budget type:
hours
,money
, ornon-billable
(default).⚠️
Project Budget
must have a numerical value set ifbudget type
is set tohours
ormoney
.
Project Users: The users assigned to the project. Provide a list of email addresses (or secondary email address, verified in timely), external IDs separated by commas or
all
to add all workspace users to the project.⚠️ If no user is specified in the column, logged in user will be added to the project as the only user.
⚠️ In case of invalid user email, id or secondary email, the invalid values will be ignored. If all values are invalid, it will set logged in user as
Required Notes: Specify if notes are mandatory for time entries:
Y
(Yes) orN
(No -default).Project External ID: A unique identifier for external integrations. Enter an alphanumeric value up to 512 characters.
Project Teams: The teams associated with the project. Provide a list of team names separated by commas or
all
to add all workspace teams to the project ornone
to remove all teams from the project.⚠️ All teams added to project will assign users that are part of added teams, to the same project.
⚠️ If team name doesn't exist on the workspace, team won't be created, instead team value will be ignored.
⚠️ If team = none, all teams assigned to project will be removed, but all users added through teams will remain assigned on the project.
Enable Project Tags: Specifies how tags are used when logging time. Choose one:
all
,none
(default), orcustom
. When choosing custom provide the name of a tag list and/or tags separated by commas.⚠️ If enable project tags =
custom
, project tags must be specified.⚠️ If enable project tags =
all
, project tags cannot be specified.
Client External ID: A unique identifier for the client in external systems. Enter an alphanumeric value up to 512 characters.
Project Description: A brief description of the project. Enter up to 300 characters.
Require at least one tag: Require at least one tag to be added to an hour. Valid values are
N
(No) orY
(Yes), default isN
.⚠️ This will work if
Enable Project Tags
is set toall
orcustom
. Otherwise, it will throw an error.
Project Tags: List of tags to be added to the project. Comma-separated tag list names.
⚠️
Enable Project Tags
must be set tocustom
when specifying project tags.⚠️ All sub-tags (if any) from the tag list will be added to the project.
If tag doesn't exist it will be created as a tag list with no sub-tags.If project already has default tags set, project tags cannot be specified. Error will be thrown. To list the project tags, default tags have to be removed manually from the project first.
👥 Users Import
Template Instructions
Template Instructions
User Name (required): Name of the user. Only normal letters are allowed. Numbers or special chars will throw errors.
User Email (required): Email of the user used to sign in Timely. Only valid email addresses.
User Role: Role of the user in the workspace, can be
admin
,manager
oremployee
. Default isemployee
. This is an optional value.Hide Default Billable Rate: This will hide all the rate values from the user. Valid values are
N
(No) andY
(Yes). The default value isN
.Default Billable Rate: Default hour rate of the user, only numbers are valid. Default value is 0.
Deleted: Marks the user as deleted. Valid values are
N
(No) orY
(Yes). Default isN
.⚠️ If a user is marked as
deleted = Y
during import, user will be imported as deleted. User will also get removed from any teams previously added to.⚠️ If an existing deleted user is updated as
deleted = N
user will be activated.
Teams: Assigns user to specified teams. Values are team names or
all
(add user to all teams) ornone
(remove user from all teams).⚠️ If team name doesn't exist, new team will be created with all users added to it.
⚠️ A user added to team will be added to all team's projects, if any.
⚠️ A user which is removed from a team will continue to be part of previously assigned projects via team.
User External ID: References external resource IDs. Alphanumeric max 512 characters, must be unique.
User Cost Rate: Cost rate of the user. Only numbers are valid.
Team Lead: Marks the users as Lead for given team names.
🏷️ Tags Import
Template Instructions
Template Instructions
Name of Tag list (required): Tag list name. Any string.
Name of Tag: Sub tag name (related to the tag). Any string.
⚠️ Tag lists are a group of one or more tags, you would just add the name of the tag list - not each individual tag. You can specify only one sub-tag using import file.
🔍 Reviewing Previous CSV Imports
After an import has been completed you'll see it listed in the CSV Imports panel within your workspace settings. You can then click the See Mapping button for each import to look over how the columns and fields were aligned for this import, or click the Details button to see how many specific objects were successfully imported.
When you are done reviewing those items you can click the Done button to return to the previous screen.
If adjustments need to be made to these imported objects, it isn't possible to revert or roll back an import. You would need to manually adjust those items within Timely, or perform another CSV import to revise and update those objects as needed.
❓FAQs
What happens if I upload duplicate data?
If the system detects an existing record with one changed attribute, it will update the record instead of creating a duplicate.
Can I undo an import?
Unfortunately, imports cannot be reversed. We recommend carefully reviewing your data during the validation step before proceeding.
What do I do if I encounter validation errors?
Errors will be highlighted, and problematic rows will appear at the top of the preview list. Correct these errors in your file and re-upload to proceed.
How many rows can I import at once?
There is no strict limit, but larger files may take longer to process. For optimal performance, we recommend splitting files into manageable sizes if working with very large datasets.
I don't see the CSV Imports section in Timely settings?
This feature is available to admin level users of Premium, Unlimited, Unlimited+ plans.
Can I import other types of data?
Currently, the supported import types are Users, Projects, and Tags. If you need to import additional data types, let us know via feedback!
Need more help?
Click the chat icon at the bottom of your screen
or send an email to [email protected]
Article Files