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

[Gary_Gangi]

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.

[messi007]

@Gary_Gangi,

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,

[Gary_Gangi]

@messi007 

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.

[messi007 · Accepted solution]

@Gary_Gangi,

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.

[Gary_Gangi]

@messi007 

Thank you that worked.