Find Jobs
Hire Freelancers

Import Excel or Google Spreadsheet to mySQL database using PHP

$30-250 USD

Completed
Posted about 7 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 12946451

About the project

26 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
A proposal has not yet been provided
$150 USD in 3 days
5.0 (136 reviews)
7.6
7.6
26 freelancers are bidding on average $152 USD for this job
User Avatar
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 https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I am available to get started on your project right away. I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$333 USD in 2 days
5.0 (983 reviews)
8.8
8.8
User Avatar
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 to discuss more: ashish260287 Thanks and Regards, Ashish Singhal PLEASE CHANGE THE ATTACHED FILE'S FORMAT TO XLSM BEFORE USING.
$155 USD in 3 days
5.0 (182 reviews)
7.6
7.6
User Avatar
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 industry verticals. I also have expertise with Magento,WordPress, PHP, PHP Scripting and CodeIgnitor along with Photoshop. So can help you with the design as well. Looking forward to your response.
$55 USD in 3 days
5.0 (302 reviews)
7.5
7.5
User Avatar
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
4.9 (351 reviews)
7.7
7.7
User Avatar
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 process the file and making insert/update for you. I could start now Thanks & B/R
$200 USD in 0 day
4.6 (61 reviews)
7.3
7.3
User Avatar
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
5.0 (30 reviews)
5.1
5.1
User Avatar
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. Regards,
$111 USD in 3 days
4.9 (29 reviews)
4.7
4.7
User Avatar
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 providing high quality Web design and coding in very short amount of time. I take pride in my ability to produce results which pass the validation for XHTML and CSS as per W3C standards. In last 6 years I have successfully executed 150+ amazing Websites and 10+ Mobile Apps. I am well equipped in Magento, Wordpress,codeigniter, Opencart, PHP, MYSQL, js, JQUERY, PHP Frameworks, PhoneGap, Andriod, IOS and AJAX and designing through Adobe Photoshop, including HTML5, CSS2/3, Bootstrap (responsive sites). I have been through all your requirements and i assure you i will provide you with best of my Quality Work. Please award me this project so i will start working on it ASAP. Thank YOu Cheers Aadil
$140 USD in 3 days
5.0 (17 reviews)
4.2
4.2
User Avatar
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 (if needed). Please give me chance to serve you. Thanks Manish Kumar
$133 USD in 2 days
4.9 (5 reviews)
3.6
3.6
User Avatar
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.0 (5 reviews)
3.3
3.3
User Avatar
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. This is how the solution will work: First you have to export your Google spreadsheet as an Excel file and then you can import that file in MySQL using simple steps. You simply want to select that Excel file and hit the "Import" button. That's all! It will be my great pleasure to work for you. Regards, Saurabh Borse
$99 USD in 3 days
5.0 (3 reviews)
3.4
3.4
User Avatar
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, and I having experience in this kind of task so I definitely can get it done before deadline. I would be glad if you start a chat with me now, as I have few questions to ask regarding the task. I shall look forward to our chat. Regards,
$111 USD in 5 days
5.0 (4 reviews)
3.0
3.0
User Avatar
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 - shammm262 Hoping for the cooperation! Best regards, Sergey
$222 USD in 3 days
5.0 (1 review)
0.8
0.8
User Avatar
I have worked on similar task like importing excel int mysql table. I can help You on the same. I have 5+ years experience in php web development.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. very interesting task. I can do it in 3 days. i have done several works like this. I am new here. please trust me and you will be delighted. Thanks
$166 USD in 3 days
0.0 (0 reviews)
0.8
0.8
User Avatar
yess i help you
$35 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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-transactional data; - I worked as independent developer and like a team player, remotely and in office. I know how to manage my time effectively; - I do not afraid overtimes and emergencies. During launching some critical projects I sleep next to servers to be sure that all go smoothly; - My last project was a Online Invoice. Fully responsive, tested under MAC and Windows, written on, Jquery, PHP and MySQL. - Have experience with AOUTH API2 - integrated high security desktop app with web sites; - Well know nginx to implement software loading balancing. For the collaborative in small projects, I use Trello and Goodge Doc. For free source control - gutbucket. Used Fabric and Jenkins for deployment and continuous integration. Good with DB modeling and DB coding and optimization. Worked with tables with more than 10mln records. My rate is $150 but if you provide project details then I can estimate and give you fixed price. I am looking for a sort-term project(s) and can negotiate conditions if you decide to hire me. I am very reliable and responsible person. If I choose you as an employer, then I will not do any simultaneously projects. Best regards, Tariqul Islam
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
To whom it may concern, I am Ezequiel from Estudio PWS. I am part of an interdisciplinary team dedicated to the development of institutional websites, e-commerce as well as web applications. I believe that I can carry out this project by the experience in different national and international projects, as well as by the support of my teammates, who among all, we meet our client’s expectations. Yours faithfully, Ezequiel.
$277 USD in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Odessa, United States
5.0
2
Payment method verified
Member since Nov 2, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.