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.
Meisterplan + Excel
Easily Import and Export Project Data with Excel
A simple copy and paste import and accessible export brings your Meisterplan data to and from Excel.
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.
Export Just the Data You Need with our New Excel Export (Beta)
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 (Beta) 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 into Meisterplan in 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!
How to Use the New Excel Export (Beta)
- To export only the data you really need, first select the date range, scenario and portfolio.
- Then, in the Portfolio Designer's toolbar, click Import and Export and select New Excel Export (Beta) from the dropdown.
- Select the data you need.
- 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.
What Customers Love About Meisterplan
“This tool gives us the invaluable insight we need to make important decisions about when to start projects and when to hire. It can help you align your hiring needs with your sales pipeline. It's the only tool in its class that provides capacity planning and projections to coordinate hiring and sales leads.”
“Meisterplan filled a significant gap for us in understanding how we are utilizing our capacity. We now have a much better idea when we need to either say no to new projects or adjust timelines and team members assigned to projects. No other tool gave us this high-level view. It brought our stress level down.”
“Meisterplan simplified our resource management. Great too to streamline your complete resource management which will save you lots of planning hours and avoid misunderstandings. You always see the current allocation of your resources and with simple drag-and-drop you move projects and recognize the changes for your resources and financials.”
“Meisterplan helps us deliver our projects on time, within the agreed budget, and in top quality.”
“With Meisterplan we were productive in just a few hours without extensive training. It offers the chance to use our own project management method which makes it quite simple to roll out. And it's well done for project portfolio management. Project Portfolio Management and Project Management Processes become simple and fast.”
“With Meisterplan, our resource utilization is more transparent. Due to the seamless integration into our existing processes, we can increase the satisfaction of both our customers and employees.”
“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.”
“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.”
“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!”
“State of the art resource planning. We manage more than 100 projects and change requests every year. Meisterplan helps us maximize our resources and keep track of our projects. The operation is simple, so no training is required for the application. For me, Meisterplan is the best resource planning tool currently available.”
“Meisterplan opened our eyes to resource bottlenecks and new portfolio solutions.”
“With Meisterplan, we can always see what exactly the impact of doing any project is – and it´s really simple to use.”
“Meisterplan is an excellent Resource Management tool. The visual interface makes the software intuitive to understand and use. I have found few other tools that can match its capabilities. Definitely love the scenario comparison function. It's pretty easy to get up and running, but you can get more complex as you get more comfortable.”
“I give Meisterplan an A+ for the experience of modifying the project timeline and resourcing. Consider this model if you’ve struggled to forecast resource capacity using spreadsheets or large commercial tools.”