Completed

Script an Excel workflow; outputs two files using data from two input files

I have a process in Excel in which I produce two csv files using the data in two input csv files. This must be done regularly, so I would like to script the entire process.

In the beginning, you will have the two input csv\'s. The script should end with the two complete output csv\'s.

The Excel processes include matching values between columns in two files, inserting values based on matching values in other columns, and concatenating values in two columns.

The guide to the entire process is attached, as well as example input and output files. The input and output files have up to hundreds of thousands of rows, so I prefer to use Python or C++, and then I can run the program through the terminal rather than open Excel directly.

Skills: C Programming, C++ Programming, Data Processing, Excel, Python

See more: data input database using excel, data entry using word excel, input data mysql using excel, macro programming excel data input, excel macro script insert data spreadsheet, data input link excel, macro input data number already used excel, script website data input, skilled data entry using excel

About the Employer:
( 32 reviews ) Palo Alto, United States

Project ID: #9323141

Awarded to:

joeltl

Hello, I got some questions regarding to the example zip file. 1. The Catalog# in [url removed, login to view] has duplication. The Cat in [url removed, login to view] has duplication. I suppose those are unique key fields 2. The data between input More

$70 USD in 2 days
(5 Reviews)
3.6

33 freelancers are bidding on average $100 for this job

Yknox

Hello I'm interesting your project very well I'm a Good C++, Java, Excel, VBA, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. More

$150 USD in 1 day
(573 Reviews)
8.7
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can make macro from csv input and matching it. please give a chance for doing your job and im able to start doing your job right now THank You Sincerely Pram More

$30 USD in 3 days
(311 Reviews)
7.0
gangabass

I'm expert in data processing with HUNDREDS of completed projects that's why I'm sure you'll be impressed with my work. I can create standalone program (for Windows or Mac or even Linux) where you'll select to input More

$74 USD in 1 day
(265 Reviews)
6.8
maverick44000

Hi Sir, I can develop a C#.Net desktop based application which shall read the 2 Excel files as input and produce the 2 corresponding Output files. Please discuss before awarding the work. Thank you. Usman

$160 USD in 3 days
(72 Reviews)
6.9
szymszteinsl

Hi! I am professional C/C++/C#/Java programmer. I can dom this project with highest quality! Best Regards, Szymszteinsl

$200 USD in 2 days
(94 Reviews)
7.1
fabest

A proposal has not yet been provided

$147 USD in 3 days
(55 Reviews)
7.1
hbxfnzwpf

I am very proficient in c, c++. I have 16 years c++ developing experience now, and I have worked for 6 years. My work is online game developing, and mainly focus on server side, the language is c++ under linux. I used More

$120 USD in 3 days
(127 Reviews)
6.9
anuyadav1

A proposal has not yet been provided

$155 USD in 3 days
(62 Reviews)
6.0
macroPOL

Hello, I am Excel and VBA expert. I can complete this project but in VBA (not in Python or C++). Please note that I have 100% completion rate and 5-star feedback on projects.

$88 USD in 3 days
(61 Reviews)
5.6
sylar1015

hello sir , c/c++/python/autohotkey expert worked for samsung & huawei a sample can be provided before hired hope to get message from u thank you very much

$80 USD in 3 days
(30 Reviews)
5.4
amynkvirani

Is it necessary to use c++ or python? I can try with python but C# would be much better for me. Let me know.

$50 USD in 1 day
(29 Reviews)
4.8
cracken

Hi, I, based on my 5 years of experience as a software engineer knowledgeable with tools automation, can handle this task pretty well. Let me know the best of your time so we can discuss further based on your requirem More

$149 USD in 0 days
(26 Reviews)
4.9
ankurs13

Hello. I am an independent developer who can write you a script to automate the process of conversion of the csvs to the final output. I can do that in python according to your requirements. Please contact me for furt More

$250 USD in 3 days
(13 Reviews)
4.4
sovenkoaavenkoaa

Предложение еще не подано

$200 USD in 5 days
(7 Reviews)
4.3
archanaoswal

I have excellent command on MS Excel. I have recently built a reservation system in Excel that involved formulas and Macros to consolidate data from various sheets and pricing calculation. I have also completed proj More

$80 USD in 5 days
(24 Reviews)
4.6
zkutch

Hello More 20 years programming experience. I would like suggest small gui .net application for your task. C#, VB on your choice. VC++ is also available, but it need more resources, of course it will be most forceful More

$100 USD in 3 days
(20 Reviews)
4.7
mukes72

Hi i have good experience on writing shells and python script , please have a look on my previous similar project. please let me know your interest . Regards Mukesh

$30 USD in 3 days
(6 Reviews)
3.5
nalbat

Hello. This task seems quite easy. I'd do it with python.

$166 USD in 2 days
(8 Reviews)
3.5
mrchambers

For this task I will use my own C#.Net Rapid Application Development libraries that contain methods for input / output file handling, delimited data parsing, and a basic GUI amongst many others. File paths will be d More

$133 USD in 3 days
(1 Review)
2.7
mihaialexandru90

#I have worked 1 year at an automotive company writing c and python,and as network admin for the university, linux and unix are familiar to me. #A buffer and memory management function when handling large chunks of More

$45 USD in 1 day
(2 Reviews)
2.7