Updating Main Excel Sheet with New CSV Files

[Chiznuggets]

Hello,

I have a webstore that provides me with a csv file that gives information on everyone's orders. I get this csv file by manually clicking download on the website. I would like to regularly combine this csv file into a main excel file. Should I be using the "data", "Get&Transform Data" section to get and update this data?

This is the original csv file.

This if how it changes when I download the new file (adds rows for new orders).

I want to stick with excel but if this is not possible then I guess I'm going to have to look into sql or maybe python.


Thank you in advance for your help.

 

[sandy666]

Power Query (Get&Transform) - From Folder

 

[Chiznuggets]

Thank you that did the trick!

 

[sandy666]

You are welcome
Thanks for the feedback