Extract Excel worksheets

Extract Excel worksheets pulls specific sheets out of a multi-sheet Excel workbook so downstream transforms can process them independently. You choose which sheets to extract by name, or extract all sheets in the workbook.

Availability: GA

What it does

• Input: one or more files (Excel workbooks).
• Output: one file per extracted worksheet.
• The transform reads the workbook's sheet structure and produces a separate output for each sheet you request.

When to use it

• A vendor sends a single workbook with multiple sheets, but you only need one or two of them.
• You need to process each sheet through a different downstream path (for example, different validation rules per sheet).
• Workbooks sometimes include extra sheets you want to ignore, such as instructions or hidden helper tabs.

How to configure it

In the MFF builder, add an Extract Excel worksheets node after the node that produces the Excel file.

Settings

Example

Input

An Excel workbook with sheets named Summary, January, February, and March (hidden).

Output

With Sheet names set to January, February and Include hidden sheets off, two files are produced: one for January and one for February.

Troubleshooting

"Sheet not found" error

• Double-check the sheet name spelling and casing.
• Enable Skip missing sheets if some workbooks in your feed may not include every sheet.

Hidden sheet is not extracted

• Enable Include hidden sheets.

Dates look wrong in the output

• Enable Full date format to standardize how dates are written in the output.

See also

• Extract data
• Extract PDF data
• Convert to Unicode (UTF-8)