Error: Output Data (1286): Number of records exceeds the Excel maximum (1048575)

I have been running into this error and am unclear as to why.

I am appending to an existing excel spreadsheet that has approx. 32K rows.

I am trying to append an additional 2,250 rows.

Initially, the excel file was set up as a table. I restructured it so it was just a range and deleted all rows below the last row of actual data.

Any assistance would be greatly appreciated.

Error Message

Accepted answers

Have you checked if there is an empty records after the the 32,000 line?

try to past the 32k rows to a new sheet and append to that one.

Hope this helps!

Regards.

All comments

This is happening because of excel limit exceeded of .xlsx format.

You can union both files using the union tool and change the format to .csv as an output format.

Hope this helps!

Regards,

Thank you for your quick response however, the excel file only contains 32,000 rows and the Alteryx solution would only be adding an additional 2,250.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703