Excel

Easily Import and Export Project Data with Excel

Excel Logo

Bring Your Meisterplan Data to and from Excel

Many businesses manage detailed project data in multiple Excel spreadsheets. This provides good support for the implementation of individual projects, but to make strategic project portfolio decisions, you need to have integrated data with an overview of all information from various data sources. Replace those numerous spreadsheets by loading your existing data in Meisterplan to experience quality portfolio planning.

Easily Get Your Data from Excel to Meisterplan with Quick Import

Our Quick Import is an easy copy and paste import to move your data from spreadsheets to Meisterplan within minutes. 

  • Copy and paste data from any Excel spreadsheet.
  • Use our sample spreadsheets to ensure all of the necessary information is included in your spreadsheet.
  • Update data just as quickly with the same copy and paste import.
Quick Import Overview
Excel Export and Quick Import with Meisterplan

Export Just the Data You Need with our New Excel Export

Clearly define the data you want to export, and use it for reporting, sharing with colleagues or use it with our Quick Import to edit and update data in Meisterplan fast.

  • Select your date range, portfolio and scenario to export just the data you need.
  • The new easy-to-read format means you can share the data with colleagues or they can maintain and export their own data based on their user rights.
  • The new Excel Export is designed to work with our Quick Import, making updating data simple.

How to Use Quick Import

  • Collect the data that you want to import using any spreadsheet (MS Excel, Google Sheets, etc.).
  • Use our sample spreadsheet to ensure you prepare the right data.
  • Copy and paste your data from the spreadsheet into Meisterplan.
  • Match your column names to the appropriate fields in Meisterplan (if the names are the same, this happens automatically).
  • Validate your data and correct any errors.
  • Click import and done!

Learn More about Quick Import in Our Help Center

How to Use the New Excel Export

  • To export only the data you really need, first select the date range, scenario and portfolio.
  • Click Import and Export in the sidebar and select the data you would like to export in the list on the right of the page.
  • Save the exported Excel file and use it to import data into another tool.
  • Or update the data in Excel and import it into Meisterplan using copy and paste through the Quick Import.

Learn More about the New Excel Export in Our Help Center

What Derek Loves About Meisterplan

I believe in the solution and see how it can benefit any company that manages multiple projects simultaneously. Which I think is just about EVERY company!

New Product Development Manager | Bard Manufacturing Company | open_in_new

Derek Walz

What Måns Loves About Meisterplan

Meisterplan helps us deliver our projects on time, within the agreed budget, and in top quality.

Executive Producer | Important Looking Pirates | open_in_new

Måns Björklund

What Thomas Loves About Meisterplan

Everyday is a Meisterplan Day. Thanks to the simplicity of the product and its excellent usability the Project Portfolio Process PPM was holistically optimized and strategic decisions for projects ensured. Eager to further enhance maturity of PPM with future releases of the product.

CEO | Stadtwerk Winterthur | open_in_new

Thomas Wetterwald

Darrin McLaughlin

What Darrin Loves About Meisterplan

There is no other product that does what Meisterplan does in terms of portfolio management and resource management without unessential extra features. If there were another product that does what Meisterplan does, I would have found it, because I tried them all.

Senior Vice President/Technology Officer | Interra Credit Union | open_in_new

Darrin McLaughlin

Portrait of Matthias Graf

What Matthias Loves About Meisterplan

Before Meisterplan was introduced, our resource management was a game of Excel bingo: time-consuming, cumbersome, and error-prone.

Chief Project Portfolio & Resource Management | Flughafen München GmbH | open_in_new

Matthias Graf

What Marzio Loves About Meisterplan

Meisterplan is now a key element of  our portfolio planning. It helps us to make sure that our portfolio is realistic and that we create plans that really work.

Head of Project Management | Trafag AG | open_in_new

Marzio Locatelli

What Carly Loves About Meisterplan

Without Meisterplan, portfolio decisions during crises like this are not well-informed and have unpredictable outcomes.

Initiative Portfolio Manager | Bayer UK | open_in_new

Carly Santer

clear