Find Jobs
Hire Freelancers

Automate creation of Excel files based on reports in csv format

€30-250 EUR

Completed
Posted over 5 years ago

€30-250 EUR

Paid on delivery
We want to automate the following task: - watch a folder - when a csv file appears in the folder (it is copied there by a batch task from an FTP location): move it to a location that has to be deduced from the name of the csv file - rename the file based on the content of the first line - open the csv file in Excel and open a master Excel file with calculations in a number of consecutive columns - copy the columns with calculations to the csv file - save the csv file as excel file Have a look at the attached files. The [login to view URL] file is what you get as input, the [login to view URL] file is the expected output. The [login to view URL] file is the master file with the calculations. The destination folder has to be deduced from the code PRG180001 in the file name. PRG is a customer code and represents a customer. You would need to read a configuration file that contains the customer code and the respective folder name. We would update this configuration file on a regular basis. The columns with the calculations should be read from the file [login to view URL] every time the program is executed because we would like to be able to change the calculations ourselves.
Project ID: 17844500

About the project

28 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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
Awarded to:
User Avatar
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ([login to view URL]). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
€200 EUR in 3 days
5.0 (888 reviews)
9.3
9.3
28 freelancers are bidding on average €148 EUR for this job
User Avatar
Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps. Please ping me for discussion. Thanks.
€250 EUR in 4 days
4.9 (629 reviews)
8.6
8.6
User Avatar
Hello! My name is Paris and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel because this is my favorite field and MS Excel projects are among the tasks I work with regularly and know exactly how to handle them. You mention that you need somebody to develop the necessary code within Excel that will check if there is a csv file within a folder, then open and manipulate it and finally save it in another location. These are common tasks that I've already implemented in the past. I'm going to spend less than 2-3 days to complete your project including required revisions for a total payment of 180€. I never ask for any payment in front. I claim the milestone release once the project is completed and my client is happy with the result. I'm a very experienced and skilled MS Office developer as you can easily check for yourself. You're welcome to visit my personal page on this platform and get an idea of who I am and what services I deliver to my clients. I'm looking forward to hearing from you. Sincerely, Paris Pallas
€180 EUR in 3 days
5.0 (596 reviews)
8.6
8.6
User Avatar
Hi, I have read the project description & seen the attached file. I am interested to make automated excel file. Please send a massage so we can discuss more. Thank You.
€30 EUR in 3 days
5.0 (444 reviews)
7.8
7.8
User Avatar
Hi I have +10 years of experience in python programming. I'm expert in create such automations task. Also I’m expert in working with CSV and XLSX files. I have read your project and the template files and I can done your project in few days. Feel free to visit my personal page and get an idea of how satisfied my clients are from my work. I'm looking forward to hearing from you soon. Regards
€150 EUR in 7 days
4.8 (181 reviews)
8.1
8.1
User Avatar
Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
€166 EUR in 2 days
4.9 (205 reviews)
8.1
8.1
User Avatar
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
€100 EUR in 3 days
4.9 (269 reviews)
7.1
7.1
User Avatar
Hello, I'm an expert Windows application developer and have done similar jobs in the past. I can deliver a Windows desktop application to do precisely as per your requirements. I can deliver in 5 days or less. Good quality work done. I will also be available for support whenever you require. (Additional work will cost extra). Thank you for considering me. Bests, Steve
€400 EUR in 5 days
4.9 (101 reviews)
7.1
7.1
User Avatar
Hello. I checked all 3 files and the specifications. I am a vb.net programmer and I work with those kind of files all the time. I will create a program in vb.net which will watch the directory for new files and then when a new file arrives make the rename, calculations and folder creation. It can read from the settings file whatever data you want so it will be customized. One thing that is important with excel files, is that the layout and the line numbers must remain the same in the calculations file. Excel is not a database so its read by line unless it has column titles in the first line. I can start the program today and have it ready within 2-3 days. Regards, Marina Louki
€111 EUR in 3 days
5.0 (210 reviews)
7.1
7.1
User Avatar
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
€111 EUR in 3 days
4.9 (177 reviews)
6.9
6.9
User Avatar
Hi, I am a java developer and interested to work on your project. I can create a java scheduler in order to monitor the folder and generate the excel files based on your requirement. I would be happy to provide you the continuous support in case of any changes required. Please let me know your decision.
€200 EUR in 4 days
5.0 (52 reviews)
6.6
6.6
User Avatar
Hello there, I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
€166 EUR in 3 days
4.9 (181 reviews)
6.6
6.6
User Avatar
Hi, I can start immediately and create the script for automatic checking of csv in folder do as needed. I am a highly motivated professional expert in programming and design. I will go with you until the script is published and also you can count on me after that for upgrades or specific requirements. Ill be more than happy to assist you in this journey. I do have few questions to start with the project so please drop me a note and lets start working. Regards Sneha
€200 EUR in 2 days
5.0 (28 reviews)
6.3
6.3
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects which involved Visual Basic, Visual Basic for Apps Key features of my work are as follows: 1) Always within schedule 2) Always within scope Looking forward to hear from you. Regards
€83 EUR in 3 days
4.9 (79 reviews)
6.2
6.2
User Avatar
Hi. I'm professional programmer from Russia with experience over 20 years. I have a big experience of work with Excel so I can write this program. Regards, Alex.
€155 EUR in 3 days
5.0 (37 reviews)
6.1
6.1
User Avatar
Hello. I am Python developer and i have an experience in excel data processing. 1. Python is much more fast than VBA 2. I can make Windows application that will stay in tray and watch for new files in chosen folder 3. It could be possible to provide wise settings 4. I can make User Interface if need. Best regards, Pavlo
€199 EUR in 3 days
5.0 (25 reviews)
5.7
5.7
User Avatar
Hi Good Day! I can help you to complete your VBA/Excel works in 3 day. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
€50 EUR in 3 days
4.7 (78 reviews)
5.4
5.4
User Avatar
Hello, At first I would like to thank you for your detailed description. It is a two days work, very similar to do the projects I have completed. If I am awarded, I may have further questions, but overall it is a well defined easy project. Best Regards, Serdar Yalçın
€140 EUR in 7 days
5.0 (25 reviews)
4.6
4.6
User Avatar
I will be able to make this automation of watching the folder & process the CSV + Xlsx files automatically as per your requirement. I have 15 yrs Experience in Excel Macro, VBA, Word & Office Automation. Please visit my tech blog officetricks to know more about my expertise or client reviews in here. I work full time in here & will be able to start your work immediately. Services Provided: 1. Excel Macro (VBA) 2. Manual to Automatic updates in Excel 3. Excel Pivot Charts & Tables 4. Excel Auto Filter, Vlookup, Formula Assistance 5. Excel to Access 6. User Forms in Excel 7. Calendars in Excel 8. Bulk Files Processing in side a Folder 9. Folder Operations 10. Sending Email from Excel 11. Extract Data from Webpages Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
€50 EUR in 4 days
4.9 (16 reviews)
3.4
3.4
User Avatar
A couple of questions. Is there a preferred programming language for this task? What is the environment resulting program will be working on? Is it windows, linux, will it run on server on a local machine?
€155 EUR in 3 days
5.0 (3 reviews)
2.9
2.9
User Avatar
i can do the job in two days doing more automations if you need
€55 EUR in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Weinbach, Germany
5.0
3
Payment method verified
Member since Feb 1, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.