Sheet Export to Excel has 1 Blank Row in the middle

Ryan Levitz
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).

CleanShot 2023-04-17 at 10.45.29.png CleanShot 2023-04-17 at 10.45.38.png


Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer โœ“

    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

    Need more information? ๐Ÿ‘€ | Help and Learning Center

    ใ“ใ‚“ใซใกใฏ (Konnichiwa), Hallo, Hola, Bonjour, Olรก, Ciao!๐Ÿ‘‹ | Global Discussions

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer โœ“

    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

    Need more information? ๐Ÿ‘€ | Help and Learning Center

    ใ“ใ‚“ใซใกใฏ (Konnichiwa), Hallo, Hola, Bonjour, Olรก, Ciao!๐Ÿ‘‹ | Global Discussions

  • Ryan Levitz
    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!

  • No problem! This was definitely a strange one

    Need more information? ๐Ÿ‘€ | Help and Learning Center

    ใ“ใ‚“ใซใกใฏ (Konnichiwa), Hallo, Hola, Bonjour, Olรก, Ciao!๐Ÿ‘‹ | Global Discussions