Importing an Excel file problems

Ed Perkins

I have an Excel xlsx file with multiple worksheets.  I first worksheet is the one I am trying to import. and it has only 28 columns and 125 rows.  None of my worksheets have more than 28 columns ofr data or formulas.

 

When I attemp to import into SmartSheet tells me: "the file you are imports has a worksheet with more than 1556 columns".  

 

I have a few rows that the fill property has been set for the entire row.  Is that what SmartSheet is looking at?

Tim Meeks

probably so.I suggest copying the worksheet to upload to its own sheet. Then set the property for just the columns only where there is data and not the entire row and see if that works.

 

tim

JohnHinkle

Sometimes Excel files have meta data in columns that appear blank. I would try copying all the data from your Excel file to a new Excel file, then try uploading it.