How to read and preserve completely blank rows in Excel using Spreadsheet File node in n8n?

Questions
1

Hi ,

I am receiving Excel files as binary attachments and using the Spreadsheet File node in n8n to parse these files into JSON rows. I have enabled the includeEmptyCells option, but I noticed that rows that are entirely blank (i.e., all cells empty in a row) are filtered out by the Spreadsheet File node and do not appear in the output.

Since some of these blank rows lie between rows with data, I want to preserve them in the output so the row order and structure exactly matches the original sheet—including blank rows.

Is there any way to configure the Spreadsheet File node to read and output these completely blank rows? Or is there a recommended workaround within n8n to detect and re-insert blank rows in their original positions after reading?

Also, how can I find out the total number of rows (including blank rows) in the Excel sheet from within n8n to help reconstruct the missing rows?

Thanks for your help!

2

@Muskan_Gangwani welcome to the community

To keep blank rows in your Excel data, try using a Function node to detect and re insert them after parsing the file with the Spreadsheet File node.

Let me know if this helps

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.