Forum Discussion
Solved
Importing an overwritten excel file
Hello, I have built a dashboard that gathers data from a downloaded Excel file, it is saved as SafetyCulture-Issues.xlxs, and ity contains data for March. The file origionally had the file name Safe...
Just by way of update. I now download the new excel spreadsheet, and save as a xlxs file. I then copy the contents, and paste it into the original file.
Seems to be the easiest and quickest way, and is working well at the moment.
Thanks for all your suggestions. It's much appreciated.
Mitch.
lbendlin
Super User
Super UserInstead of overwriting files and/or renaming them you can consider to use the original files as is. Place them in an easily accessible location (for example a SharePoint folder), and then ingest them all. That gives you flexibility on what to keep and what to compare (akin to a manual "Slowly Changing Dimension" processing).