Find Jobs
Hire Freelancers

Create script to manipulate cvs files

$30-250 USD

In Progress
Posted almost 6 years ago

$30-250 USD

Paid on delivery
Hi, I am looking to create a script that does the following: 1. Read a CVS/Excel file with multiple links 2. Download the files from each link (csv files) 3. Create some extra columns in each CSV file that was downloaded to add some concatenated data 4. One of the columns in the CSV files is a Category column, do a lookup in a file called [login to view URL] and if the Category is found in [login to view URL] then assign the category ID from that file 5. Merge all CSV files that were downloaded and processed into one big file I will provide more details and specifications, i just need to know if you can do something like this and what is the cost.
Project ID: 17382285

About the project

35 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
35 freelancers are bidding on average $168 USD for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience 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. Proposed Milestones $200 USD - Please pay me once job is 100% done. I am a full time freelancer and can work dedicated on this till completion. No milestones required in advance, please pay me once the job is 100% complete.
$200 USD in 1 day
5.0 (583 reviews)
9.1
9.1
User Avatar
Hi, I am good at Excel and vba. I have referred the description provided. It can be achieved using excel vba, as the data to be referred is to deal with excel or csv files. Please share the files. Relevant Skills and Experience Excel vba, Data processing, csv,Matching data Proposed Milestones $150 USD - Milestone Please provide sample files to review the data to get the scope of work.
$150 USD in 1 day
5.0 (736 reviews)
8.0
8.0
User Avatar
Hello Sir, I have reviewed your job details and I am sure i can deliver you the job with you satisfaction. Relevant Skills and Experience I have more than 5 year of experience in Powershell, Software Architecture, Visual Basic, Windows Desktop . Please ping me for more discussion. Proposed Milestones $200 USD - Create script to manipulate cvs files
$200 USD in 3 days
4.9 (367 reviews)
8.3
8.3
User Avatar
I can provide you simple Windows program that will read CSV file with list of links, for each link it will download a file, parse it, merge some fields and perform lookup in another file etc Relevant Skills and Experience I'm one of the best web scraping and desktop automation experts here (see my reviews) Proposed Milestones $90 USD - Windows program to process CSV files Can you show me real CSV file?
$90 USD in 1 day
5.0 (454 reviews)
7.6
7.6
User Avatar
I will write the macro which will go to each url to download the files, reorganize data in these files through search, concatenate, insert, and finally merge the reorganized data into one single file Relevant Skills and Experience I am proficient with excel macro/VBA development, your task is achievable through VB macro, which has the ability to transfer data with flexibility Proposed Milestones $150 USD - deliver the macro fits the requirement Please provide sample files to get the scope of work., looking forward to chat further for a turnaround solution and work on your project
$150 USD in 3 days
5.0 (158 reviews)
7.6
7.6
User Avatar
Hello Sir, We are team of developers and I read your project description and I fully understand your requirement but I need some more information, Relevant Skills and Experience We have more than 5 year's experience in this field Also We have completed many project related to this filed Proposed Milestones $200 USD - milestone
$200 USD in 5 days
4.9 (108 reviews)
7.0
7.0
User Avatar
Hi there,I am Miljan,Python expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! Relevant Skills and Experience Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. Proposed Milestones $211 USD - / 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
$211 USD in 3 days
5.0 (48 reviews)
7.0
7.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experience VBA/Excel expert Proposed Milestones $150 USD - final delivery
$150 USD in 5 days
4.9 (147 reviews)
6.8
6.8
User Avatar
Hello. I'm a visual basic .net expert. I have written many programs like this for csv/excel manipulation. I will write a program to do all the steps you want, read, download, create columns, etc. Relevant Skills and Experience I'm an expert on data scraping and creating custom programs which use any kind of data and excel, access, mysql etc to store/change data. Proposed Milestones $133 USD - Final program
$133 USD in 3 days
5.0 (140 reviews)
6.9
6.9
User Avatar
Hi, Reading your project description about creating a script to manipulate csv files makes me feel like you have me in mind when creating the project. I have all it takes to deliver. Relevant Skills and Experience Rather than just show you past projects, I want to exceed your expectation by completing a part of your job. If you are satisfied with the result, you can award the project. Please check my reviews. Proposed Milestones $150 USD - Creating a script to manipulate csv files Do you want me to start working on the sample right away?
$150 USD in 3 days
4.9 (24 reviews)
6.5
6.5
User Avatar
Hi, I am an expert coder in Python, I can manipulate and add the scraped data to the csv's. Contact me, Thanks! Relevant Skills and Experience Python Stay tuned, I'm still working on this proposal.
$55 USD in 1 day
5.0 (22 reviews)
5.8
5.8
User Avatar
Hi, I can develop for you a tool in vb.net to read your cvs/excel files and donwload the link files Relevant Skills and Experience I worked before with this kind of applications Proposed Milestones $125 USD - develop, test and delivery Can you attach in the chat a sample csv file?
$125 USD in 3 days
4.8 (57 reviews)
6.1
6.1
User Avatar
Hello Stefan , I have read your project description and understood your requirement. I have 2.5 years experience in Excel VBA programming With Regards, Bhaskar" Relevant Skills and Experience VBA Proposed Milestones $100 USD - A
$100 USD in 2 days
4.8 (94 reviews)
6.2
6.2
User Avatar
I can write a macro to download multiple files, modify them and combine them into one file Relevant Skills and Experience I have excellent command on MS Excel. I have completed many complex projects in Excel before. Proposed Milestones $200 USD - Completion of work Few of my past projects: - Create a schedule for delivery trucks pick-up and drop for optimal utilization of resources based on various constraints - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites. - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs. - Built a POS and inventory management system. - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile. Thanks, Archana
$200 USD in 3 days
4.8 (66 reviews)
5.8
5.8
User Avatar
hi what language you want it to be? can i do it with python or c#? Relevant Skills and Experience it's pretty simple task, i've done similar things before Proposed Milestones $50 USD - code
$50 USD in 1 day
4.8 (39 reviews)
5.5
5.5
User Avatar
Hello, I can develop a desktop application that will manipulate csv files as you described, but I need more details. Thanks Relevant Skills and Experience I have been developing Windows applications for more than 19 years. Proposed Milestones $400 USD - A Windows app to manipulate csv files and download data Can you show a typical link to download the files from?
$400 USD in 3 days
5.0 (7 reviews)
4.9
4.9
User Avatar
Could you please show me an example of the CSV file? Relevant Skills and Experience I have ~7 years of experience in C++ and over 3 in C#. I also write some Python code and recently Haskell, so I can do the task easily. Proposed Milestones $88.89 USD - Milestone
$88 USD in 5 days
5.0 (11 reviews)
4.0
4.0
User Avatar
Creating and manipulating xls & csv files with powershell is part of what I do in my daily job Relevant Skills and Experience Use powershell to administer users, computer & licenses. Of course I will need more details and sample CSV files before establishing a fixed price and delivery time. Proposed Milestones $90 USD - Done
$90 USD in 3 days
5.0 (7 reviews)
3.3
3.3
User Avatar
Hi, depending on the size of the files and resources to be downloaded it will keep the server very busy while its processing. My advice is to use a different server or we can use the browsers resource Relevant Skills and Experience javascript,php, mysql, web development Proposed Milestones $200 USD - Full functionality
$200 USD in 5 days
4.8 (1 review)
3.2
3.2
User Avatar
Hello I can write this for you in PowerShell that can be run on Windows (or Linux with PowerShell core installed) Please reach out so we can discuss details. Thanks Callum
$222 USD in 3 days
5.0 (1 review)
1.9
1.9

About the client

Flag of UNITED STATES
glenview, United States
5.0
7
Payment method verified
Member since Mar 26, 2013

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.