How to get all sheets from an excel file

Questions
1

Describe the problem/error/question

When I download an excel file (xls, xlsx, xlsm, …) I only get the first sheet.
How to get all sheets in an excel file ?

Please share your workflow

Share the output returned by the last node

I only get the first sheet data.

Information on your n8n setup

  • n8n version: 1.115.2
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system:
2

To get all sheets from an Excel file in n8n, you’ll need to use the **Extract from File** node with a specific configuration. Set the “File Format” to “Spreadsheet” and enable the “Read All Sheets” option in the node settings - this will extract data from every sheet in your Excel file instead of just the first one.

If you’re using an older version of n8n or don’t see this option, you can alternatively:

• Use the **Spreadsheet File** node and loop through sheet names

• Extract the file first, then use a loop to process each sheet individually

• Check that your Excel file isn’t corrupted and all sheets contain readable data

The Extract from File node is the most straightforward approach for handling multiple sheets in modern n8n versions.