I will import and clean your excel or csv data into a mysql database
PHP and MySQL developer, bug fixes, data imports, web systems
About this Gig
Have a spreadsheet that needs to go into your MySQL database without breaking what's already there? I'll import it cleanly: checked, de-duplicated and verified.
I'm a PHP/MySQL developer who builds business systems, including bulk imports that update live data every month. So I don't just dump rows in. I check them first.
WHAT YOU GET
- Excel (.xlsx) or CSV imported into your MySQL / MariaDB tables
- Clean-up: trimmed text, fixed dates and numbers, empty rows removed
- Duplicate check against the data already in your database
- A short report: rows added, updated, skipped, and why
- Optional: a re-usable PHP or SQL import script you can run again next time
HOW IT WORKS
1. Send the file + your table structure (or a database export)
2. I map the columns and flag anything unclear BEFORE importing
3. I import, verify the row counts and send you the report
Your existing data is backed up before anything changes.
Not sure it fits? Message me first. You'll get an honest answer and a flat quote.
Expertise:
Migrations
•
Indexing
•
Data Types
Platform:
MariaDB
•
MySQL
My Portfolio
FAQ
Do you need access to my server?
Not necessarily. You can send a database export (.sql) and I send back an import-ready .sql file. Or give me temporary phpMyAdmin/database access and I import directly.
What if my columns don't match the table?
I map them and send you the mapping to confirm before anything is imported. Nothing unclear gets guessed.
Will this overwrite my existing data?
No. I back up first, and duplicates are skipped or updated according to rules you approve before the import runs.
Can you create the table too?
Yes. If there's no table yet, I design one that fits the data (Standard and Premium packages).
