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

carsonblu ✭✭
edited 06/14/22 in Add Ons and Integrations

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.