Merge Excel Files

Overview

The 'Merge Excel Files' flow action merges up to 1,000 Microsoft Excel files (and related formats) provided in a JSON array to a single file. 

This action takes all worksheets contained in multiple Excel files and places them as separate worksheets within a single Excel file. To illustrate:

INPUT

Excel 1
  - Tab a
  - Tab b
Excel 2
  - Tab c

OUTUT

Merged Excel
  - Tab a
  - Tab b
  - Tab c

To merge multiple worksheets into a single worksheet, please refer to our Merge Excel Rows action.  

Input File Types

The following file types are supported for files to be merged:

• XLSX
• XLSB
• XLST
• XLSM
• XLS
• CSV
• tabdelimited
• ODS
• spreadsheetml
• TSV

Output File Types

The merged output can be saved in any of the following file formats:

• PDF
• CSV
• TIFF
• XLSX
• XLS
• XLSB
• XLSM

Example Flows

Please refer to the following article showcasing the 'Merge Excel Files' action

• Merge Excel and CSV Files with Power Automate

Power Automate Templates

• Merge Excel files in a SharePoint Folder

Credit Count

This action consumes 1 credit per operation.

Note, different Encodian actions can consume different number credits. Please always check the action specific documentation and read What is an Encodian Action for a full description of how credits are consumed.

Default Parameters

The default 'Merge Excel Files' flow action parameters are detailed below:

• Filename: The filename of the output excel file
• Output Format: The format of the output excel file
• Documents: The array of files to be processed

As a manually entered array:

• Filename: The filename of the source file (including the file extension)
• File Content: The file content of the source file
• Sort Position: Set the sort position for the document within the array, lowest number first.
• Worksheets to Merge: Specify which worksheets from the source file should be included within the output

As an array object:

Documents - JSON Schema 

The JSON provided within the documents parameter should conform to the following schema:

{
 "fileName": "<Filename including extension>",
 "fileContent": "<File contents (Base 64 string)>",
 "sortPosition": <Optional - Sort position number>,
 "worksheetsToMerge": [<Optional - int array>]
}

Return Parameters

The 'Merge Excel Files' flow action returns the following data. 

Action Specific Return Values

• File Content - The processed file (Base64)

Standard Return Values

• OperationId - The unique ID assigned to this operation.
• HttpStatusCode - The HTTP Status code for the response.
• HttpStatusMessage - The HTTP Status message for the response.
• Errors - An array of error messages should an error occur.
• Operation Status - Indicates whether the operation has completed, has been queued or has failed.