You can bring existing work into Hive from a spreadsheet or from another tool.
Open your photo or initials in the top right and choose Import tasks and projects. External and restricted members do not see this menu item.
The Bring your work into Hive dialog opens. To connect Asana, ClickUp, Jira, monday.com, Notion, Trello or Wrike, see Import a workspace with guided import.
Choose a source
Choose the tile that matches the tool or file you want to import.
Excel / CSV opens the task importer for CSV, XLS and XLSX files.
Asana lets you connect your account or choose Upload JSON. To get the JSON file, open the project menu in Asana and choose Export, then JSON.
Trello lets you connect your account or choose Upload JSON. To get the JSON file, open the board menu in Trello and choose More, then Print and Export, then Export JSON.
Smartsheet — XLSX. In Smartsheet, open Sheet Actions, choose Export, then Export to Excel.
Microsoft Project offers Upload XML for guided import and Upload MPP for an MPP file. With an MPP file, you can choose a parent project or leave the plan at the workspace level.
monday.com offers Use an API token to load your boards and choose which ones to import. To sign in with your monday.com account, select Connect monday.com and follow guided import.
Basecamp — connect your Basecamp 3 account and choose which accounts to import. This is not a file upload.
To create many projects at once instead of tasks, choose Projects spreadsheet. See Create projects in bulk from a spreadsheet.
Attach a file
For an Asana JSON file or a Microsoft Project MPP file, select Choose files, attach your exports, then select Import.
For a Trello JSON file, a Smartsheet XLSX file or a Microsoft Project XML file, choose one file, then follow the steps to select the work and fields to import.
Spreadsheet columns
Map your columns in the importer. Hive recognizes Title, Description, Assignee, Start Date, End Date, Status, Section, Phase, Milestone, Estimated Hours, Actual Hours, WBS, and Predecessors.
You can also choose Import to existing project.
A column header that does not match one of those fields can be mapped as a custom field.
On Match Columns, open Will become for that column and choose Custom field. Hive matches the column to a custom field with the same name.
For example, a Location column maps to a custom field named Location.
If that custom field already exists, the values go into it. If it does not, Hive creates a text custom field with that name.
Spreadsheet importer
Choosing Excel / CSV opens the spreadsheet importer. Its four steps are Upload file, Select header row, Match Columns, and Validate data.
1. Upload file
The screen shows the columns Hive expects, and a link labeled Click here to see an example CSV. You can rename or remove columns in the later steps. Click Select file and choose a .xlsx, .xls, or .csv file.
To add the rows to a project you already have, check Import to existing project? and choose the project. Leave it unchecked to create a new project.
2. Select header row
Pick the row that contains your column names.
3. Match Columns
Your table is the file you uploaded. Will become is the Hive field each column maps to. Use the X on a column to drop it. Unmapped columns become custom fields.
Choose Custom field in Will become to match the column to a custom field with the same name. If none exists, Hive creates a text custom field with that name.
4. Validate data
Dates must match the date format in your profile settings.
Assignees are email addresses. Separate more than one with a comma.
Estimated Hours and Actual Hours are numbers.
WBS is numbers joined by dots, such as 1.2.3, and each value must be unique.
Where the work lands
Asana: each project in the JSON becomes a Hive project. If you import it again, Hive reuses a copy you can access. If the only copy is private to someone else, Hive creates a separate project for you. The name keeps an [Asana] suffix. If a custom field in the file has the same name and type as one in your workspace, Hive reuses that field and does not make a duplicate.
Trello: each imported board becomes a project, and its cards become actions.
Monday.com: each selected board becomes one project.
Smartsheet: each selected sheet becomes a project.
Excel / CSV: a new project, or a project you already have.
Microsoft Project: XML imports the selected plan as a project. For an MPP file, you can choose a parent project.
Asana, ClickUp, Jira, monday.com, Notion, Trello, Wrike (guided import): see Import a workspace with guided import.
Sample CSV for Import: