How to export data to Excel without overwriting previously exported data.

carsonblu

Howdy! I have built a very robust sheet for collecting form submissions company-wide. We are currently maxing out our sheet cells every two months and I'm having to manually copy/paste the data to a running excel file that our Analytics team uses to connect with PowerBI.

Can I set up an excel sheet that just pulls 'new rows' from the smart sheet and does not delete rows I remove from the smart sheet? (I plan on deleting rows on a weekly basis in Smartsheet to avoid hitting our max cell count).

Every solution I've found overwrites all data within the Excel file so we can't have a running list of all submissions for our PowerBI dashboards.

James Keuning

Smartsheet won't do that natively. But you can use the Smartsheet data connector, and use Power Query to grab the data before you run your row deletion process, probably using Close and Load.

Microsoft Excel

https://www.smartsheet.com/marketplace/apps/microsoft-excel

Visualize Smartsheet data in charts, graphs, and dashboards