Import projects from CSV

Turn your spreadsheet into a full-fledged project plan with Hive’s import function.

Erin Gouveia avatar
Written by Erin Gouveia
Updated over a week ago

Overview

You can easily import tasks from a CSV file into a Hive project. To begin, download a sample CSV by going to your profile dropdown, then Import tasks, and selecting Import CSV. Then, fill out the following columns with your project details.

Column Descriptions

WBS: Work Breakdown Structure (WBS)

Title: This corresponds to your action card title. Please note that this field is required while all others are optional.

Start Date: The start date of the action in MM/DD/YYYY format.

End Date: The deadline of your action in MM/DD/YYYY format.

*Note: See below to learn how to import in DD/MM/YYYY format.

Predecessors: Creates a dependency between actions. If adding Predecessors, you will need to number the actions in the WBS column and reference those WBS values to indicate your predecessors.

Assignee: The email address of the person responsible for completing the action. If there are multiple assignees, please separate each email address using commas.

Description: Maps to the action card description.

Status: Will default to Unstarted if left blank.

Phase: Maps to the project phase.

Milestone: If listed as "TRUE" or "FALSE", the action in that row will become a milestone.

Note: Any columns you create that do not match one of the above fields will create an Action Card custom field in the project.

Once you’ve completed your CSV file:

  1. Name it with your desired project title.

  2. Go to your profile dropdown menu, then Import tasks, and select Import CSV.

  3. Click the link to attach your file, then click Upload files, and you’re all set.

What is WBS?

Work Breakdown Structure (WBS) breaks down a project into manageable chunks and allows project managers to define and organize the scope of their project in an organized manner. You can learn more in this article.

How do I import a file with DD/MM/YYYY format?

To import a file in DD/MM/YYYY, you'll need to change your Date Format in your profile to DD/MM/YYYY. Once the date format is updated, the importer will accept DD/MM/YYYY format.

Need an example CSV file?

You can download our sample CSV file here:

Attachment icon
Did this answer your question?