Modify an extensive Excel Spreadsheet

Closed

Description

We have a very large spreadsheet that we use to import into our e-commerce system. The spreadsheet then takes all of these fields and concatenates them to create insert statements. This "script" is used to replicate products into different cities across the us. For example, You could have Widget #1 in Atlanta, Widget #2 in Detroit, etc.

The project has two two pieces.

The first is to modify the existing spreadsheet to account for new products. Right now the products are hard coded. We would like some input fields to accommodate new products. This will include new descriptions and images.

The second part is to create a new script that can modify the existing city pages and add the new products to them and then of course load the new products.

I will supply you a copy of the file, but my client is very secretive so I will have to remove the domain name and any testing will have to be done on your side. You will not have access to our servers.

Skills: Excel, MySQL, SQL

See more: widget testing, spreadsheet script, spreadsheet input, account spreadsheet, excel file mysql, load excel, import modify, mysql spreadsheet, spreadsheet insert, commerce project testing, excel import access, import mysql excel excel, can scan spreadsheet hard copy excel soft copy, script import mysql file, import excel file project, client statements excel, script modify excel file, widget mysql, excel input mysql, mysql import excel, excel import mysql, excel project images, modify existing spreadsheet, excel file cities, excel hard copy

Project ID: #5237231

38 freelancers are bidding on average $417 for this job

meet2amitvw

Need to discuss in more details for the proper estimation of cost and time. see my recent work for the technical expertise along with reviews & feedback on my profile page. let's discuss and get started.

$721 USD in 12 days
(42 Reviews)
6.7
eperfections

10+ years experience. 600+ projects completed successfully. Very interested in this project. Please send me full details including the excel file. Ready to start ASAP.

$618 USD in 6 days
(138 Reviews)
6.7
bharanisrihari

Hi, I'm an Excel expert / VBA programmer. I can get your requirements done perfectly! Please refer the excellent reviews for my completed projects in Freelancer.com. I've completed a number of Excel VBA projects More

$300 USD in 10 days
(64 Reviews)
6.4
seekdeveloper

Hi, I have read your post and understood your requirement. I have good experience in handling Wordpress /Magento/Joomla/Drupal/ HTML5/CSS3/PHP/ Yii framework/Javascript/MySQL/ Kindly go through my works to c More

$1030 USD in 10 days
(9 Reviews)
6.0
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this matter. with than More

$494 USD in 9 days
(35 Reviews)
5.7
vbexcel

I can help. I am an Excel / VBA coder pro with over ten years experience in developing automated applications. I have particular experience in data mapping projects, that is, reformatting input data files into eC More

$260 USD in 3 days
(27 Reviews)
5.4
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$388 USD in 10 days
(45 Reviews)
5.2
zExcel

Hi, I'll try to help you with this project but I'd like to have a look at the file first. I will show you how to send the file when you respond to this message

$300 USD in 3 days
(31 Reviews)
5.1
wsh2

Season's Greetings from Easton PA.. {smile} Highly experienced (20+ years) MsExcel programming and database expert with Guru / Menotr level technical credentials at www.experts-exchange.com and www.vbcity.com. ST More

$526 USD in 10 days
(14 Reviews)
5.0
maverick44000

Hi there. Being highly proficient in Excel and databases, especially Access and SQL, I can manage your project very comfortably as I have successfully delivered many similar projects before. Kindly share the sheet so I More

$380 USD in 4 days
(19 Reviews)
4.9
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche More

$555 USD in 10 days
(33 Reviews)
4.8
dviruki

Hello! I can help you with modification of the spreadsheet. I have over 12 years of extensive Excel experience and can start working immediately.

$250 USD in 3 days
(26 Reviews)
4.4
duksmth

Hello, I am very interested in your project. I have BBA degree, IT in management, I work in sales and I am ms office / vba expert. I would like to see your files prior to awarding / accepting project (Non-disclosur More

$350 USD in 5 days
(19 Reviews)
4.1
Edison1983

Similar work I've done a lot. https://www.freelancer.com/projects/4962719.html I'm a VBA Programmer, having 6+ years of exp. Have developed & designed various Excel based projects, dashboards, templates & trackers More

$250 USD in 1 day
(12 Reviews)
3.8
schungur

EXPERIENCED PROGRAMMER WITH MORE THAN 20 YEARS EXPERIENCE in development of Windows and Web apps... Please check my badges and projects...

$388 USD in 10 days
(9 Reviews)
3.5
gitapodder1989

I am ready to do the job for you and hopefully I can do it nicely with very good quality of output in time.

$515 USD in 10 days
(3 Reviews)
3.2
MSExcelPro

Hi. Excel, Access, SQL and MySQL Expert Here. Please see my feedback. Let me know if you need any more details. Ready to start. Regards.

$299 USD in 8 days
(2 Reviews)
3.1
mail2vimalarora

Hi.. I have gone through your requirement in the project and feel comfortable in taking up it to completion. Since spreadsheets are not provided, I would like to have a discussion to get more details and get it clarifi More

$261 USD in 5 days
(5 Reviews)
2.9
ajafari

Hi, I am a profession computer man and can do your project. If you are interest please contact me to talk more about your project. Thanks

$250 USD in 7 days
(1 Review)
2.5
rightfreelancer7

I am a professional software engineer with 9+ years of experience. I am very talented programmer with the following skills c, c++ , java , UNIX, Linux,SSH, sql,plsql, PHP, Jsp , Js , advanced js like jquery, extjs etc. More

$250 USD in 7 days
(4 Reviews)
2.3