Closed

We need scripts written to merge data from two sources into one Excel data stream

We sell primarily apparel to one of our clients.

We have an Excel .csv output files that are exported from our ecommerce website we've built for this client. Each file is for a single order and provides that order's data. We also have data that needs to be added from a second Excel CSV worksheet that includes all of our client's operating system's product codes, delivery location codes, purchaser names, General Ledger account codes, and more. We need to merge these two sources of data into a third CSV file that will contain data from multiple orders. We would then send that file to the client at the end of the day that order ships. Attached are two files, one is a sample of the data from the e-commerce website and the second is the template needed to submit that data to the client's operating system. We don't yet have the client's file with all their operating system product numbers, general ledger codes, etc.

Skills: Data Entry, Data Processing, Excel, PHP, Visual Basic

See more: need ebooks written, need articles written tonight, need testing written php multiple choice, fme join, fme vlookup, need essay written, need articles written, visual basic scripts excel copy data cells, need resume written, need pre written blog, need program written, need book written, merge files excel duplicates, need scripts, 300 websites need backend written, need report written, need paper written com, need scripts progammers, we need to create a bill format in MS Excel for the patrol pump, We need our association member list put into an excel database

About the Employer:
( 0 reviews ) Richmond, United States

Project ID: #17702516

53 freelancers are bidding on average $381 for this job

jaylancer43

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

$444 USD in 3 days
(628 Reviews)
8.3
mirniyazuddin92

Hi there, I can make scripts to merge data from two sources into one Excel data stream. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$400 USD in 7 days
(351 Reviews)
7.7
schoudhary1553

Hello, I have the good knowledge of merge data from two sources into one Excel data stream. I have more than 5 years of experience in Data Entry, Data Processing, Excel, PHP, Visual Basic. I have reviewed your job a More

$400 USD in 6 days
(311 Reviews)
7.7
extreamcode

HI There, I can assist you write a script which will read from two sources and merge them together. I am very passionate about quality of my work, You will be pleased working with me. Let's have a quick chat to discu More

$555 USD in 10 days
(70 Reviews)
7.4
Vlzinch

Hello! I will do the script that will work with 100% accuracy and performance. That's my main direction and I love it to do it. Pls contact me to discuss points of your goals. Regards, Vlad

$744 USD in 10 days
(77 Reviews)
7.5
P0L

$300 USD in 5 days
(279 Reviews)
7.2
gangabass

I can provide you a script that will read your source CSV files (the data from the e-commerce website and the client's file) and generate third file using your template. You have pretty good project description so More

$250 USD in 2 days
(407 Reviews)
7.2
AleenaIlyas

Hi there, I have read the details I am experienced with Data Processing, Excel, PHP, Visual Basic. I can help you with this job, Please come to chat so we can discuss this job.

$555 USD in 10 days
(26 Reviews)
7.1
aarifakhtar

Hi: I can create a script in Python or VBA which will read the data from both the input files and convert them to the final client template. I have reviewed the two files shared by you, it would be great if we can have More

$250 USD in 5 days
(170 Reviews)
7.0
asin1987

Dear Employer, I understand your file Merging job and I will do that for you. Please do try me once. Thanks and Regards, Ash

$388 USD in 10 days
(117 Reviews)
7.0
avinav606lx

Hello there, This looks doable and I'm interested in doing this. 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. More

$250 USD in 3 days
(171 Reviews)
6.5
paris2785

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 More

$350 USD in 5 days
(159 Reviews)
6.8
chriskerpini

Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. I will u More

$300 USD in 4 days
(85 Reviews)
6.8
Tanmoy236

"""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 m More

$300 USD in 2 days
(154 Reviews)
6.4
mamoona016

Hi...! I hope you will be and I want to do your project .i want to start work immediately with my professional expert team and provide 3 month technical support .you pay once when you satisfy 100%.

$250 USD in 10 days
(71 Reviews)
6.5
bestit4u

Hi. I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and s More

$555 USD in 10 days
(81 Reviews)
6.8
zekovicm

Hi there,I am Miljan,Excel VBA/Macro 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 wit More

$333 USD in 3 days
(103 Reviews)
7.0
devi222

Hi Sir, I can create a script to combine both shesets into one with matching columns I’m a Python Programmer. I have created many Bots to scrape the websites like Amazon(UK, USA, AU, de),Alibaba(suppliers data), Link More

$470 USD in 3 days
(166 Reviews)
6.6
panfreelancer

Hi, I am Erfan. I think the goal is to copy some data from the csv file, and copy them to corresponding columns in template xlsx. Is that correct? So some data from csv will be copied correctly to these column More

$250 USD in 5 days
(80 Reviews)
5.9
sypsoo

We sell primarily apparel to one of our clients. We have an Excel .csv output files that are exported from our ecommerce website we've built for this client. Each file is for a single order and provides that order's More

$350 USD in 5 days
(52 Reviews)
6.3