Importing excel spreadsheet that has long column names produces duplicate column error

Kurt Robohm

Just thought I'd toss this little tidbit into the community in case someone else stumbles into this. I was trying to import and Excel sheet into SmartSheets and received and error indicating that the excel sheet could not be imported because it contained duplicate columns. Turned out that the reason SS thought it was a duplicate was because there is 50 character limit to column names. Within the first 50 char of the imported excel sheet, there would have been duplicates. Solution was to reduce the char count of column names in the imported excel sheet. Duplicate errors gone!