4,374 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 79%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
You should look into power query for this task. This blog I wrote should give you some ideas. https://exceleratorbi.com.au/combine-csv-files-power-query/
Automatised actions on a folder
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Majda BOUGHANMI
1
Reputation point
Hello everyone!
As written in the title, I would like to automatise some actions on new files that are added to a folder.
These files are automatically downloaded from a FTP in .csv format.
My goal is to tranform these .csv into .xlsx and to do a macro on them: mainly, gathering every value of column A and the adequate sum in column B. For instance, if I have:
Company Value
A 3
B 1
A 5
A 0
B 2
C 4
And I want to obtain:
Company Value
A 8
B 3
C 4
Is this possible to automatise this kind of actions please?
Maybe through microsoft flow and by locating these csv doc into the cloud? Or any other way, please?
Best regards,
Majda
Microsoft 365 and Office Development Other
Community Center Not monitored
46,181 questions
{count} votes
-
Erin Ding-MSFT 4,476 Reputation points2021-03-05T01:54:37.673+00:00 @Majda BOUGHANMI
Tag "office-excel-itpro" focuses on general issues about Excel clients, as your issue is out of the scope of it, I will remove the tag. Thanks for your understanding. -
Majda BOUGHANMI 1 Reputation point
2021-03-05T08:07:46.4+00:00 Thank you for the advice!
Sign in to comment