Data Shuttle is not finding all columns in the source sheet

smillstein522

I am trying to use data shuttle to upload data from an excel file in SharePoint but when I get to the mapping part, the column names are completely different from the source. Almost as if it is not pulling the data from the sheet I specified, but a different one. I am using the second tab of the excel sheet and some of the options for column mapping aren't even in the workbook. Any help would be greatly appreciated.

Peggy Parchert

@smillstein522

Hello. Try moving in the excel sheet so that it is the first tab is the one you are trying to map. Smartsheet looks at the first tab.

Hope this helps.

Peggy

Danielle Wilson

@smillstein522 Hopefully you figured it out but probably had to do with the first step in the workflow builder on the Source page where you specify the tab or first row number (and whether the file has headers or not).