Completed

Create script to manipulate cvs files

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.

Skills: Powershell, Software Architecture, Visual Basic, Windows Desktop

See more: script compare xls files, php script send attached files, create script jpeg, batch file read csv column, batch file loop through csv, how to read excel file using batch script, batch file to edit csv, batch file loop through list, script to read csv file, csv batch file, how to make a csv file in python, software development, c# programming, software architecture, excel, python, web scraping, microsoft excel, desktop app, linux example script delete owner files

About the Employer:
( 4 reviews ) glenview, United States

Project ID: #17382285

Awarded to:

irondrake

Hi, I can develop a powershell script for you which perform exactly what you describe on your project description Relevant Skills and Experience 3 yr of exp. powershell dev, I developed multiple scripts which helps m More

$60 USD in 3 days
(8 Reviews)
4.4

45 freelancers are bidding on average $166 for this job

schoudhary1553

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, More

$200 USD in 3 days
(131 Reviews)
7.1
cgullapalli

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 More

$150 USD in 1 day
(393 Reviews)
7.2
$140 USD in 3 days
(178 Reviews)
6.8
AndrejStastny

Hi Relevant Skills and Experience I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Port More

$250 USD in 3 days
(39 Reviews)
5.7
Attractionnet

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 E More

$133 USD in 3 days
(90 Reviews)
6.0
elqueabandona

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 Experi More

$150 USD in 5 days
(56 Reviews)
5.5
zekovicm

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 profil More

$211 USD in 3 days
(9 Reviews)
5.4
solucionesnet

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 More

$125 USD in 3 days
(28 Reviews)
5.5
archanaoswal

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. More

$200 USD in 3 days
(35 Reviews)
5.2
SBITServices

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 Propos More

$100 USD in 2 days
(53 Reviews)
5.1
jdayyeh

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 y More

$400 USD in 3 days
(5 Reviews)
4.9
imRaziel

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
(24 Reviews)
4.9
hauntedanon420

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
(12 Reviews)
4.3
redincorpindia

Dear client I saw your requirements regarding the csv file manipulation application development from scratch. I can develop this application within a day maximum based on your requirements. I developed many applicati More

$250 USD in 1 day
(10 Reviews)
4.2
$155 USD in 3 days
(23 Reviews)
4.4
gszo123zl

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 easil More

$88 USD in 5 days
(10 Reviews)
3.9
dvcontact

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 Rat More

$150 USD in 3 days
(1 Review)
3.5
ersiddharthshah

I can write one java program which will download csvs from provided links and then using java CSV APIs i can manipulate them as per your need. Relevant Skills and Experience I am having 2+ years experience in java i h More

$111 USD in 2 days
(2 Reviews)
3.2
$155 USD in 1 day
(65 Reviews)
2.9
eyalfinkelshtein

Hi, I can create the script you need using python (more preferable) or powershell. Relevant Skills and Experience I am a Web developer (html5, PHP, sql, javascript, jquery, bootstrap) and Programmer (java, c#, android More

$233 USD in 3 days
(1 Review)
2.4