Skip to main content
Importing Tasks from CSV

Learn how to import tasks using the Tasks CSV template.

Updated over a week ago

Importing tasks into Productive simplifies your workflow, allowing you to organize your projects more efficiently.

From using the import feature to resolving errors, we'll go over everything you need to know to effectively import tasks into your projects.

Let's get started!

Importing Tasks

In addition to importing contacts, companies, entitlements, expenses, rate cards, time-off bookings, users, and time entries, Productive allows you to import tasks to individual task lists using CSV templates.

To begin, open your project and navigate to the task list's three-dot menu. From there, select "Import tasks from CSV".

It's important to note that importing tasks is only available from the Board and List task layouts.

Downloading and Filling Out the Template

Once you've initiated the import process, you'll be prompted to download the CSV template and enter the relevant task information.

Refrain from deleting any columns in the template, as this could cause the document to be unrecognized by the importer.

The CSV template contains six columns (only the title is obligatory!):

Title

Provide a descriptive title for the task.

Description

Include a brief overview or details about the task.

Assignee

Specify the email address of the individual responsible for the task.

Due Date

Indicate the deadline or due date for the task. The date format is YYYY-MM-DD.

Initial Estimate

Estimate the initial time required to complete the task, measured in minutes.

Workflow Status

Choose between "Open" or "Closed" if you haven't customized your task workflow.
Alternatively, select from the available statuses in the custom workflow you've added to the project.
You may also leave this field blank if necessary. If you've implemented a custom workflow and don't alter the status from "Open," Productive will automatically adjust it based on your custom settings.

Uploading the Template and Fixing Errors

After filling out the template, drag and drop it into the upload box or manually upload the document.

Productive will automatically check for errors during the upload process. If any errors are detected, you'll be able to identify and address them promptly.

For example, if an error arises due to an unrecognized assignee email, you can update the email in the CSV file or edit the information directly from the pop-up screen using inline editing.

Any data marked with the warning symbol (⚠️) in the upload contains an error.

Hovering over these symbols will reveal specific problem areas!

Completing the Import

Once all errors have been resolved, proceed with the import by clicking "Proceed to import" and then "Import" on the subsequent screen.

Useful Tips

  • Only the task title information is obligatory when filling out the CSV, meaning you can leave fields such as due date, initial estimate, and assignee blank if they're not needed for a task or if you want to modify them at a later date.

  • When specifying initial estimates, remember that values should be entered in minutes. For instance, if you wish to set the estimate to 1 hour and 20 minutes, input "80".

  • Ensure that the date format in the CSV file is YYYY-MM-DD (or YYYY-M-D) to avoid parsing errors during the import.

  • Do not delete or remove any columns from the CSV file template. If certain fields are not applicable, such as a description or allocation in hours, simply leave those columns empty without deleting them. Maintaining the integrity of the template structure ensures smooth data import processes!

  • Take advantage of the inline editing feature to fix any errors in the imported file efficiently.

Did this answer your question?