Importing 2 separate excel files into one sheet

MarthaP

Hello! I'm looking for some recommendations on how I can pull 2 separate excel/csv files into one sheet. Data from the sheet will be used to create reports that will feed a dashboard. I don't have access to data shuttle.

kowal

hi Martha,

From what I know the importing is always 1 to 1 so one excel tab to one smartsheet sheet.

If the both excel have exactly the same columns (as it should be) you can import one and for the second you can copy and paste data.

Or you can merge those 2 excel sheets before importing them to Smartsheet.

Hope it helps.

kowal

hi Martha,

From what I know the importing is always 1 to 1 so one excel tab to one smartsheet sheet.

If the both excel have exactly the same columns (as it should be) you can import one and for the second you can copy and paste data.

Or you can merge those 2 excel sheets before importing them to Smartsheet.

Hope it helps.