Completed

Import Excel or Google Spreadsheet to mySQL database using PHP

I have monthly data stored in a Google Sheets file that I would like to import into a mySQL table using PHP scripts. This could either be directly from Google Sheets or I could save that file into an Excel file.

I would need the ability to either INSERT new data or UPDATE existing data.

There will be unique fields within the Excel File that can be checked within the mySQL table to determine INSERT or UPDATE. (ad_id is unique, but also use client_id)

I would like field Mapping that could be within the PHP code. See spreadsheet for field mapping.

Skills: PHP, Software Architecture

See more: import xml file mysql database using php, import excel file database using php, upload excel file mysql database using php, create report database using php mysql, import excel file mysql database using php, slideshow image database using php mysql, import xml mysql database using php, reports created database using php mysql, software write mq4, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, update database csv file uploaded using php mysql, software write websites idea, software write book images, generate report mysql database using php, software write books

About the Employer:
( 2 reviews ) Odessa, United States

Project ID: #12946451

Awarded to:

xerobug

A proposal has not yet been provided

$150 USD in 3 days
(136 Reviews)
7.6

26 freelancers are bidding on average $152 for this job

rajeshsonisl

Hello! Bid includes implementing dynamic field mapping. With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page htt More

$333 USD in 2 days
(983 Reviews)
8.8
coolguyinus2004

ready to do it asap for you. Expert in PHP/MYSQL programming. Expert in stripe gateway work. Check my reviews and message me online then we can start work now. let me know thanks

$222 USD in 3 days
(351 Reviews)
7.7
cmitexperts

Hi there! Did go through your Job Description and glad to share that I have experience in working with wordpress platform. I have more than four years of industry experience and have been the part of diverse industr More

$55 USD in 3 days
(302 Reviews)
7.5
asin1987

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well More

$155 USD in 3 days
(182 Reviews)
7.6
itsea

Hello, I already have experience of importing excel into MYSQL using PHP. please see [login to view URL] user: admin pass: 123 login as admin. please message me so i can explain you more further. thanks More

$222 USD in 10 days
(82 Reviews)
6.8
mobiletech1604

Dear sir Thank you for posting this project. I'm Hoang and I'm experience developer. Your requirement are very clear. I think fastest way is saving your sheet as excel file, then upload using my script. My script will More

$200 USD in 0 days
(61 Reviews)
7.3
$155 USD in 3 days
(30 Reviews)
5.3
pollux1er

Hi sir, I am able to write you a script do do the task automatically. Please let me know if you want me to proceed now. I can deliver in 2hours regards

$155 USD in 3 days
(30 Reviews)
5.1
saqibsaeedkhan

Hi, i am a php, mysql developer. i have seen your requirement and i can import excel data to mysql database as per your requirement. please let me know if you have any question. looking forward working with you. More

$111 USD in 3 days
(29 Reviews)
4.7
aadilahlawat42

Hello Dear, I am a professional Web developer with an experience of more than 6 years in creating and customizing Web themes, extensions, application and plugins and framework like codeigniter . My expertise is in p More

$140 USD in 3 days
(17 Reviews)
4.2
$166 USD in 30 days
(13 Reviews)
4.4
$30 USD in 3 days
(11 Reviews)
3.7
ExtraMemory

Hello i am understand your requirement but have to discuss few things.. is that database create by you side ? or you want only insert update data .. Message me for more details... About ME :: we are More

$30 USD in 3 days
(4 Reviews)
3.3
kunjandetroja

hi sir, This is a daily job for us. we work on lots of projects where data is imported to MySQL from excel, so we know very well the ideal PHP code for this. I will start immediately if awarded.

$166 USD in 3 days
(5 Reviews)
3.3
SaurabhBorse

Hello Sir, I have fully understood your requirements and ready to work on your project with all my skills in PHP and MySQL. I can develop an effective solution to solve your problem with fantastic user interface. T More

$99 USD in 3 days
(3 Reviews)
3.4
mkvaish10

Hi, Based upon my experience , i am very confident to give you the best results. Most importantly i have completed a much similar project last week and got the code ready with some customization for your project ( More

$133 USD in 2 days
(5 Reviews)
3.6
phourxx

Greetings, You're looking for an experienced php developer to export your Google sheet or excel sheet to mysql database. Talking about a perfect match, I a a core php developer with over 5years of working experience, More

$111 USD in 5 days
(4 Reviews)
3.0
$194 USD in 7 days
(2 Reviews)
1.7
Sergey7219

Hello, my name is Sergey. I am co-founder of IT studio I-PR. I am really interested in your project and ready to start working right now. If you are interested we can discuss details of our cooperation here or in Skype More

$222 USD in 3 days
(1 Review)
0.8
tariqulboy1

Hello sir, As there are no details about the projects you going to use me in, so here is my short recap: - 3 years experience: HTML5, CSS3, PHP+MySQL; - Great experience with NOSQL DB: MongoDB and CouchDB for non-tr More

$155 USD in 3 days
(0 Reviews)
0.0