Updating Main Excel Sheet with New CSV Files

Chiznuggets

New Member
Joined
Jun 26, 2019
Messages
8
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.
zoomu.JPG


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


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.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,099,471
Messages
5,468,813
Members
406,611
Latest member
hanman453

This Week's Hot Topics

Top