Automate combine a csv file and ecxel file

£20-250 GBP

Closed

Posted

over 3 years ago

£20-250 GBP

Paid on delivery

This project has to use Microsoft flow (power automate). When one excel file (name = lagersaldo + date) is saved in a teams channel (it is being e-mailed there) it updates a master excel file. When one csv file (Name = 3pl lager + date) is saved in the same channel it to updates the same master excel file. The csv file has to be read as text in the master excel file because it has to have leading zeroes for the product names to match in the master file. (The master excel file is already made ready to calculate data based on the data from these two files. ) This has to happen every day mon-fri. so the excel file has to be updated or a new master file has to be added to the teams channel each day

Excel

Microsoft

Project ID: 27914113

About the project

12 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

12 freelancers are bidding on average £155 GBP for this job

@asin1987

WE CAN TALK ABOUT PRICE IF NEEDED!! Dear Employer, I will automate your task of combining multiple files in one which happens Mon-Fri. I am an Expert with over a decade of experience. Kindly check my previous reviews here for your kind consideration: https://www.freelancer.com/u/asin1987 Hope to connect soon!! Thanks, Ashish

£200 GBP in 1 day

5.0

(232 reviews)

8.0

@writingapp

Hi. I have written many automation projects. Ready to write your project. Will complete within 6 days

£240 GBP in 6 days

4.9

(88 reviews)

5.7

@imfarrukh47

hi greetings. I am microsoft excel master and Vba developer. I read your project description and reviewed your excel file. I can automate this entire process. I have few questions. 1) Is sheets imported to master must be in tables? 2) Does this task include download files from email? or you manually download email files thanks farrukh

£50 GBP in 1 day

5.0

(28 reviews)

5.3

@erdikudu

Hi Sir/Madam, I have been working at Office 365 for 7 years. I have experience Sharepoint, Project, PowerApps, Power Automate, Teams, PowerBI, and Planner. I developed many kinds of workflows using Power Automate. I used the Custom connector to integrate the flow with 3rd party applications that are not provided the connector from Power Automate. I connected many data source for getting data like SharePoint, Excel, Outlook, One drive, Project, Planner, Teams, etc. Please let me know if you have any questions.

£389 GBP in 7 days

4.6

(12 reviews)

5.8

@TilagaA

Hello, good day! I'm Tilaga, Power platform, SharePoint and PowerApps developer. YES, i can create flow to read csv file and update master list. Please let me know if you would like to take it forward. My technical skills are below: ◆ SharePoint 2010, 2013, o365 ◆ PowerApps, Power Automate (MS Flow), Power BI ◆ JavaScript, ECMA script, Jquery, Ajax, Rest Api, HTML, CSS ◆ Infopath Form, Content editor, content query webpart. I have gone through your requirement and I found my skills are exactly matches with your expectations. I would like to work on your project as i have relevant skills to complete your task on time..

£250 GBP in 3 days

4.9

(20 reviews)

5.0

@Rasel2543

Hello there, I am expert in Excel. I have done many task like this. I have huge experience in VBA, Macro, Vlookup, Hlookup, Pivot tables, Pie chart, Graph. If you want to get your project done perfectly and 100% accurately then plz contact me. Thanks.

£30 GBP in 1 day

4.9

(16 reviews)

4.2

@youssefEngineer

Hello sir, i'm python expert, i worked many times on csv excel files, in data extraction, calculations, automation ..., if you don't have problem with python i can make a tool that automate this process for you, i just need some more information and discuss deeply the project in order to deliver to you a quality product i'm looking forward for your response cordially,

£200 GBP in 3 days

5.0

(7 reviews)

3.8

@chnsci

Greetings, I think here you are looking for someone to automate combine a csv file and ecxel file. I have seen the attached file and understood your project description. I am an expert in Excel, Microsoft and I am really interested in your project. I am really confident that, I can do this with 100% accuracy and ready to start now! But I want to know more about your project. So, can we discuss more? Thank you.

£125 GBP in 7 days

5.0

(5 reviews)

2.3

@DRG1990

Hello I have read your job description carefully. I have rich experience in csv and xls file controlling with python . So I am interested in and I am confident in your project. I always provide perfect results to my clients as you can see on my profile. If you give me a chance, I will provide you the perfect result. I hope you send me a quick message. Regards Daniel Ramos Garcia

£150 GBP in 3 days

0.0

(0 reviews)

0.0

@WaliMuhammad04

Hello Dear Client, i saw your description and requirements fully understand your project and i have done more than 100+ jobs of these kind i have 3 years experience of this field and i will do your work with 100% Accuracy and neat and clean in cheap cost if you want any changes in amount or in delivered days your most wellcome we will cooperate. Thanks, Wali Muhammad

£20 GBP in 1 day

0.0

(0 reviews)

0.0

@rezvirayhan2002

Hi brother I can do your job very nicely. And I've been doing this for a few days now. I am 100% sure I can do your job very well. Thanks Rezvi Rayhan

£100 GBP in 5 days