Sheet Export to Excel has 1 Blank Row in the middle

Ryan Levitz

Hi there,

I'm stumped on this one. I have a basic Sheet with 1944 rows. There are no blank rows. When I do a basic export to excel, one blank row gets inserted at row 1758 of the excel file. The excel file has 1946 rows (1 is blank and 1 is the header) so no info is missing. I can't see anything in the smartsheet rows that would be causing a blank. Any help would be appreciated! Thanks!

It's easy enough to go into the Excel file each time and remove a row, but it's broken my automations (sort and filter in excel breaks due the blank row).

Genevieve P.

Hey @Ryan Levitz

Is it possible that there is indeed a blank row in your Smartsheet sheet at row 1756? I would try applying a filter to the Sheet if a specific cell is blank to see what comes up.

I will note that the fact that the row doesn't have a Date from your System column is very odd - it means this row doesn't have any data at all.

Once you apply a filter to show all blank rows, I'd suggest deleting the first 5 rows in case one of them is in the middle of your other data. Then try exporting again!

Cheers,

Genevieve

Genevieve P.

Hey @Ryan Levitz

Is it possible that there is indeed a blank row in your Smartsheet sheet at row 1756? I would try applying a filter to the Sheet if a specific cell is blank to see what comes up.

I will note that the fact that the row doesn't have a Date from your System column is very odd - it means this row doesn't have any data at all.

Once you apply a filter to show all blank rows, I'd suggest deleting the first 5 rows in case one of them is in the middle of your other data. Then try exporting again!

Cheers,

Genevieve

Ryan Levitz

Very strange. Filtering for blanks showed 10 rows, 1952-1961. I deleted the first 5 of those. Exported it and it all looks great. I appreciate the help!

Genevieve P.

No problem! This was definitely a strange one