How to convert DOC, XLS, PPT documents to DOCX, XLSX, PPTX respectively using Microsoft Flow

In this article, you will find out how you can easily convert older formats of Microsoft Office documents into modern ones in bulk with the help of Microsoft Flow and Plumsail Documents. Since Microsoft developed new extensions, sooner or later everyone faces a necessity to convert DOC to DOCX, XLS to XLSX and PPT to PPTX. Benefits of new formats are obvious, useful features were added and files weight less so it’s easier to use them online.

Imagine, you have a SharePoint library (or files storage in any other system) full of DOC, XLS, PPT files which you need to convert to modern extensions.

lib1_lib2

In this article we’ll show how you can do it massively using actions from Plumsail Documents connector for Microsoft Flow:

Convert DOC to DOCX

Let’s begin with the most common case – converting DOC to DOCX. First, open Microsoft Flow. In 'My flows' create a new one and select 'Manually trigger a flow' as a trigger. At the end, the flow will look like this.

wholeflow

Here is a step-by-step description.

Get files (properties only)

After setting a manual trigger for the flow, add 'A new action' – for it, search for a SharePoint Connector and the ‘Get files’ action.

Navigate to the SharePoint library you want to convert documents from. To get only DOC files from there, use a very convenient tool like an ODATA filter (in advanced options). Here you can read about its syntax and find some examples how to apply it to query concrete parameters.

In our case, you need to set a value for the files format. SharePoint libraries have a column with extensions. Its name is File_x0020_Type. So the query will be File_x0020_Type equals (eq in ODATA syntax) 'doc' (value should be put between single quotes).

ODATA_filter

For the next steps set up Control ‘Apply to each’ and in the first field you’ll be asked to select an output from the previous step. Choose Value from a dynamic content.

Get file content

Assign the ‘Get file content’ action for a SharePoint connector. It takes content of the specified files from a document library. Now you need to set a dynamic content Identifier.

identifier

Convert DOC to DOCX

After that, use a Plumsail Documents connector and the Convert DOC to DOCX action. When you add an action for the first time, you’ll be asked for ''Connection Name'' and ''Access Key''. You can type any name for the connection. For example, ''Plumsail Documents''.

Then create an API key in your Plumsail Account page, copy and paste it to ''Access Key'' field.

Document content will be the result of the ‘Get file content’ step.

convert_doc_to_docx

Create file

The final part is saving your DOCX files into a separate folder. Add an action, search for the SharePoint ‘Create file’. Fill in all required fields like in the image.

saving_docx

The flow is ready, run it and check the target SharePoint library.

Convert XLS to XLSX

To convert all your XLS files into XLSX just build the same flow, but type in File_x0020_Type eq 'xls' in the ODATA filter query field to get all XLS files from the SharePoint library.

query_xls

Assign Convert XLS to XLSX instead of ‘DOC to DOCX’ in the Plumsail Documents action. And save the result files with .xlsx extension.

saving_xls

Convert PPT to PPTX

The same flow works for converting PPT to PPTX. Query all PPT files by using ODATA filter just the same way, but the file type equals PPT – fill in a field with File_x0020_Type eq 'ppt'.

query_ppt

Assign Convert PPT to PPTX in Plumsail Documents step. Save the result files with .pptx extension.

saving_ppt

Now you know how to use Plumsail Documents to convert DOC to DOCX, XLS to XLSX, PPT to PPTX. If you haven’t tried it yet, feel free to press Start trial and see the documentation for details. You will find a lot of useful Microsoft Flow examples which will help you to automate your operational processes. It is quite easy to get started.