mpp to excel

Convert MS Project file to Excel with C# .NET.

Microsoft Project (MPP) is a widely used format for managing and tracking project timelines, resources, and tasks. It is ideal for comprehensive project planning, but often limits flexibility when it comes to data analysis or sharing with stakeholders who don’t use MS Project. On the other hand, Excel (XLS/XLSX) is a more versatile and universally accepted format, offering powerful data manipulation, visualization, and sharing options. Converting MPP files to Excel enables project managers to export their project data into a format that is easier to analyze, report, and collaborate on.

REST API for MPP to Excel Conversion

GroupDocs.Conversion Cloud SDK for .NET SDK provides a comprehensive set of features that streamline the conversion process, ensuring accurate and reliable output in both XLS and XLSX formats. With easy integration into your .NET applications, you can automate the conversion of complex Microsoft Project files, preserving all critical project data such as tasks, timelines, and resource allocations.

The first step in this approach is to install it by searching GroupDocs.Conversion-Cloud in NuGet package manager and click the Install button. Another option is to execute the following command in package manager console.

NuGet\Install-Package GroupDocs.Conversion-Cloud -Version 24.2.0

Once the installation is completed, please obtain your personalized API credentials(i.e. Client ID and Client Secret). You may visit this short tutorial explaining the details on how to get the API credentials.

Export MPP to Excel in C#

Let’s explore the code snippet that simplifies the transition from MPP to Excel, enhancing data accessibility and facilitating in-depth project analysis and reporting.

  1. Firstly, create an instance of Configuration class where we pass client credentials as arguments.
var configurations = new Configuration(clientId, clientSecret1);
  1. Secondly, initialize the ConvertApi where we pass Configuration object as an input argument.
var apiInstance = new ConvertApi(configurations);
  1. Now, upload the input MS Project file to the cloud storage.
fileUpload.UploadFile(new UploadFileRequest("Home move plan.mpp", stream));
  1. Create an instance ConvertSettings where we specify the name for input MPP, resultant format as xls and the name of the resultant Excel workbook as arguments.
var settings = new ConvertSettings{...}
  1. Lastly, call the ConvertDocumentRequest API to convert MPP to Excel and save the resultant Excel worksheet to the cloud storage.
var response = apiInstance.ConvertDocument(new ConvertDocumentRequest(settings));
mpp to excel

Image:- Preview of MS Project to Excel conversion.

The input MS Project file used in the above example can be downloaded from Home move plan.mpp.

Convert MS Project to XLSX using cURL Commands

Converting MPP to XLSX using GroupDocs.Conversion Cloud and cURL commands provides a straightforward and flexible method for handling project file transformations. The simplicity of cURL combined with the powerful capabilities of the GroupDocs.Conversion Cloud ensures that your project data is accurately and efficiently transformed into a widely accessible Excel format, facilitating better data management and analysis.

The first step in this approach is to generate a JWT access token and then, execute the following cURL command to develop Microsoft project viewer online by export MS Project file to PDF format. After successful conversion, the resultant PDF file is stored in the cloud storage.

curl -v "https://api.groupdocs.cloud/v2.0/conversion" \
-X POST \
-H "accept: application/json" \
-H "authorization: Bearer {accessToken}" \
-H "Content-Type: application/json" \
-d "{  \"StorageName\": \"default\",  \"FilePath\": \"{inputMPP}\",  \"Format\": \"xls\",  \"OutputPath\": \"{resultantXLS}\"}"

Please replace inputMPP with the name of input MS Project file, resultantXLS with the name of resultant Excel workbook and accessToken with a personalized JWT access token.

  • In order to export MS project to Excel and save the resultant file on local drive, then please try using the following cURL command:
curl -v "https://api.groupdocs.cloud/v2.0/conversion" \
-X POST \
-H "accept: application/json" \
-H "authorization: Bearer {accessToken}" \
-H "Content-Type: application/json" \
-d "{  \"StorageName\": \"default\",  \"FilePath\": \"{sourceFile}\",  \"Format\": \"xls\"}" \
-o "output.xls"

Free MPP to XLS Converter

Our free and lightweight MPP to Excel Converter App enables you to explore the unique capabilities of GroupDocs.Conversion Cloud within a web browser.

mpp to xls conversion app

Conclusion

In conclusion, converting MS Project (MPP) files to Excel (XLS/XLSX) format offers significant benefits in terms of data accessibility, analysis, and reporting. Both the approaches discussed in this article provide effective solutions for transforming complex project data into a more manageable and versatile format. We encourage you to explore our APIs to experience the seamless conversion process and optimize your project data handling.

We highly recommend visiting the following links to learn more about: