Back to TidyBuild Guides

Set up Microsoft Project integration

This add-in is only available on Project plans 3 and 5, and Project Professional 2019. This add-in enables you to easily import resources from Tidy into Microsoft Project and export your projects and resources from Microsoft Project into Tidy.

Want to view this guide all at once?

Download PDF

Step 1.

First, log-in to Microsoft Project. Click on the project you would like to work on, then navigate to the Project tab, in the toolbar.

Step 2.

Once you are in the Project tab, click Get Add-ins.

Step 3.

This will then open the Office Add-ins box, where you will select the Tidy Add-in.

Step 4.

Search for Tidy in the search bar. You will then see Tidy Task Sync display.

Step 5.

Once you have found Tidy's add-in, click Add.

You will see a pop-up box display. Click Continue.

Step 6.

Tidy's Microsoft Project Add-in will appear, click Get Started.

Step 7.

Once you click Get Started, you will be presented with the Application Configuration screen.

This is where you connect your Tidy account with Microsoft Project. Or, if you do not yet have a Tidy account, you can start a free trial.

Step 8.

Input your API key into the API field, and your Application URL in the Application URL field.

To retrieve your Tidy API key, please navigate to Global Settings, click Users.

Step 9.

Click Edit on a user, then scroll to the bottom on the screen to find the Allow API Access section. If you do not see Allow API Access, please contact us.

Step 10.

Click Allow API Access. Once ticked, you will see your API key. Click Save. Copy your API Key, ready to paste it in the field in Microsoft Project.

Step 11.

Input your Company URL e.g.https:/yourcompany.tidywork.com/

Please input your project information into Microsoft Project before clicking Connect. The required fields are TaskName, Duration, Resource Names. You can add other information if necessary. Click Connect.

You will then be able to Import and Map Resources from your Tidy account into Microsoft Project. Please note, if you have not added any information to your project yet, both options will be greyed out not be able to be clicked. Click on Import & Map Resources.

Step 12.

The Resource names within your Project will then appear, and the TimeWriters within your Tidy account will automatically be able to be selected from the drop-down menu.

Step 13.

Click the drop down menu, and map the resource with the time writer in the drop-down menu.

Once you have completed all required mappings, click on Save Mappings.

Step 14.

If you have completed everything correctly, a success message will appear. If you receive an incomplete message, please retry and ensure you have correctly mapped the resources with time writers.

Once you have imported and mapped resources, you will then be able to create a project in your Tidy account. To do this, click Create Project in Tidy.

Step 15.

The Export Project screen will appear. Fill out all the required fields. These fields are:

  • Project Name
  • Project Code (click Auto if you want a project code automatically generated)
  • Project Description
  • Project Group
  • Project Manager
  • Customer
  • Tax Code
  • Start Date

Step 16.

Once you have filled out the required fields, click Go.

If you have filled in the information correctly, a success message will appear, and your project will now be available in your connect Tidy account.

Step 17.

Now, when you go into Projects in your Tidy account, you will see the corresponding project.

Related Guides

Want to learn more? Check out these related guides

All TidyBuild Written Guides

Setup

Set up your account in the global settings of Tidy

Inventory

Learn how to manage your inventory in your Tidy account
How to disable and delete a material
If you are no longer using certain material items, you can choose to disable them. To disable a material item, you first need to have the right permissions. Users with Purchaser, or System Administrator permission can disable material items.
How to clone a material
This guide explains how to easily clone materials and all of it’s details.

Projects

Learn how to complete projects within your Tidy account
How to run a report
There are many different types of reports that are available to run. The categories of these reports are: Project Reports, Time & Productivity Reports, Operational Reports, Sales Reports, Stock Reports, Administration Reports.
How to export data
This guide explains how to export project data.
How to export payroll
You can easily export payroll data from your Tidy account to a connected Payroll provider that Tidy offers. Tidy offers integrations with multiple Payroll providers. These are: Smart Payroll, iPayroll, IMS Payroll
How to add project adjustments to a project
In this module, learn how to add project adjustments to projects. These adjustments can be used to document 'variations' in the project that occur after the project has started, that were not taken into account in the original plan.
How to add time adjustments to a project
In this module, learn how to add time adjustments to projects. These adjustments can be used to document 'variations' in the project that occur after the project has started, that were not taken into account in the original plan.
How to create combined project invoices
Combined Project Invoices is only available on the Rocket plan of TidyWork, TidyBuild, and TidyEnterprise. With Combined Project Invoices enabled, Project items ready for invoicing on the Invoice Queue which have the same customer, can be combined onto one invoice.
How to use the project calendar
The Project calendar allows users to view Projects visually in a selected date range.
How to schedule resources and book time
If the Resource Scheduling feature is enabled for your organisation, your Project Managers will be able to write future booked time against your resources, and they will be able to see these allocations when adding time entries.
How to view a project
This module explains how to view all the details of a project, and takes you through the details of each section.
How to clone a project
This module explains how to clone the details of a project.
How to edit a project
This module explains how to edit the details of a project.
How to create a project
Tidy Work provides two ways to create a new project: quick project and new project.
How to approve materials
To Approve Material, you need to have the user role of Material Approver and be assigned to the project you are approving materials for.
How to enter materials
This guide explains how to enter materials for a project.
How to approve time
To Approve Time, you need to have the user role of Time Approver and be assigned to the project you are approving time for.
How to enter time
This guide explains how to enter time for a project.
How to approve expenses
In this module, learn how to approve expense entries once they have been submitted. Only users with approver permissions will be able to do this.
How to enter expenses
In this module, learn how to enter expenses against a project you have been assigned to.
How to view a quote
In this module, learn how to view a quote’s information.
How to edit a quote
In this module, learn how to edit a quote’s information.
How to clone a quote
In this module, learn how to clone a quote.
How to create a quote
Quotes allow you to present the estimated time, cost, material, tasks, etc. for a project.

Bulk Imports

Learn how to import data in bulk to your Tidy account
How to bulk import customers
This feature allows you to quickly import your customers in bulk.
How to bulk import materials
This feature allows you to bulk import your materials faster.
How to bulk import users
This feature allows you to quickly import your users in bulk.
How to bulk import suppliers
This feature allows you to bulk import your suppliers.