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.
26 freelancers are bidding on average $152 for this job
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
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.