Download, modify and upload an .csv to phpmyadmin !! EASY

This project received 7 bids from talented freelancers with an average bid price of €6 EUR / hour.

Get free quotes for a project like this
Project Budget
Total Bids
Project Description


I want to do 2 times per week at one specific hour or also when I push a bottom in my website and should be executed 20 times (because I want to download every time 20 excels for 20 differents tables in my DB):

I want to download one excel file (.xls) from one internet website.

With that .xls, I need to be modify to change the "Date" column and put in the correct formar (YYYY-MM-DD) and replace all the "," of the text for "."

After that, save in a CSV file (.csv)

Once that is save in that format, upload to phpmyadmin (is in my localhost) and update JUST the new rows, because in the excel that I download I would have some rows that are actually in the DB).

And that's all.

More specific details by MP.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online