Meisterplan + Excel
Easily Import and Export Project 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 the various data sources. Replace those numerous spreadsheets by loading your existing data in Meisterplan to experience quality portfolio planning.
From Chaos in Excel to an Integrated Project Portfolio
Meisterplan is a resource-based, interactive PPM software. You can use easily use your existing Excel data for the initial setup in Meisterplan.
- Consolidate your data with Meisterplan, even if it comes from multiple Microsoft Excel sources. This will give you a comprehensive view of your project portfolio.
- Use the imported content of your project portfolio to simulate different scenarios including changes to prioritization, financing, scheduling of projects and changes to resource capacities – all within Meisterplan.
- Communicate plan changes. You can even export the new plan to your familiar Excel structure.
- Access a pivot export with all allocations, and export all your data as a complete package to Excel.
How to Use Excel Import/Export
- In the main menu, you will find the option to load your plan data directly from Excel into Meisterplan.
- There are two Excel import modes:
Keep and Update – this mode lets you keep all of your plan data, update it, and add new elements.
Delete and Replace – this mode lets you delete the existing data in Meisterplan and replace it with the newly imported projects, resources, and roles. - The Meisterplan Reporting API enables you to query Meisterplan data directly from Excel and to load the reporting data into an Excel file.
What Customers Love 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.
“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.”