Importing Excel file to Smartsheet


Hi All,

I have an excel file that I imported to Smartsheet - I have built a dashboard based on this report and it all works great. The issue is, as it is an extract from one of our customer's programs, we get this on a weekly basis, which means I will have to upload it to Smartsheet weekly. I don't want to build a new dashboard every week to represent the up to date data. Is there a way to bring a new report on to the existing sheet so the dashboards gets automatically updated?

I have tried the file - import from excel function but it seems it's creating a new sheet every time I tried. Copy and paste is not really doing it for me either as it's only allowing 50 cells and the extracts are much bigger.

Do you have any other ideas please?