
Closed
Posted
I need customer information that currently lives in several spreadsheets moved accurately into our live MySQL database. The schema is already in place; you will be inserting roughly three thousand records that include names, contact details, account numbers, and a short notes field. While importing, please check for obvious duplicates and normalise phone and email formats so everything matches the existing conventions. The database is UTF-8 and uses InnoDB, so referential integrity must stay intact. You can work with phpMyAdmin, MySQL Workbench, or a command-line import routine—whatever is fastest for you—as long as the end result is clean and verifiable. Deliverables: • Fully populated MySQL tables with no duplicate customer IDs • A short plain-text log explaining any data you adjusted or could not import (with row references) • The SQL script or CSV file you used for the final upload so I can rerun it if needed I will provide the credentials, table definitions, and sample rows as soon as we begin.
Project ID: 40722217
40 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
40 freelancers are bidding on average $50 USD/hour for this job

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
$50 USD in 40 days
7.8
7.8

Hello, I have expertise in database specially in MySQL with 14+ years of experience in it. I have done the same job several times. Can you please share the sample excel sheet and also the MySQL schema details. I will make sure there is no duplicate data and also the email and phone number are normalised. You have this data in single excel or multiple, also do you want just one time data import or you want the feature to import the in future also with out my need. I am available to start the work immediately, can we have more discussion. Regards Avinash
$50 USD in 20 days
7.6
7.6

Hi, I'll use a php-cli script to process your sheets, extract the data, connect to your database and insert. I'll provide the php script used and a csv with the rows inserted and eventually a second csv with the rows skipped. I can start any time, message me for details.
$50 USD in 40 days
6.8
6.8

Hi, I’ve gone through details of this project and I’ve done similar tasks many times before, importing data from excel to MySQL or vice versa. I’ve 10+ years of experience you can check my profile as reference. I’m available now for further discussion and starting work. Thanks
$50 USD in 40 days
6.8
6.8

Hi, moving 3000+ records from spreadsheets into your MySQL InnoDB tables without breaking referential integrity needs a script, not manual entry through phpMyAdmin. I'd write a Python (pandas) import script that reads each spreadsheet, checks for duplicates before insert, normalizes phone numbers and emails to match your existing format, and inserts through prepared statements so your foreign keys stay intact. Every skipped or adjusted row gets logged with the row number and reason, and you'll get the full script back so you can rerun it anytime. Before I start I need one thing: what should count as a duplicate here, same email, same phone, or same account number? And can you send a few sample rows so I match your current phone/email format exactly. Once I have the schema and sample data I can turn this around in 1 day.
$50 USD in 40 days
6.6
6.6

Hi there! As an experienced Full Stack Developer, I'm confident in my ability to meet your needs for this project. With over eight years in the field, I've gained a deep understanding of MySQL, PHP and SQL - skills vital to the success of your database import task. Over the years, I’ve efficiently completed numerous data migration tasks like this one with zero errors and salvage all valuable lost data. I'm well-versed in phpMyAdmin, MySQL Workbench or command line import routine and can provide you with the scripts you might need in the future for reruns. I believe in delivering precise solutions that make a positive impact on your business operations. By choosing me for this project, you can expect delivery of a fully-populated, clean MySQL table ready to augment your business efficiencies. Thank you for considering my bid!
$50 USD in 40 days
6.4
6.4

I will write a small, focused import utility (simple script) that: Reads your spreadsheets/CSV. Cleans and normalizes data. Loads into a staging table, validates, then moves into the final tables. This ensures a safe, repeatable import with full control over duplicates and data quality. Experience 10+ years running my own development work, including data migrations and ETL utilities. Strong experience with MySQL, PostgreSQL, Oracle, and SQL Server in production systems.
$50 USD in 20 days
6.4
6.4

Migrating ~3,000 customer records from multi-sheet sources into a live InnoDB MySQL database requires strict pre-ingestion sanitation so foreign key constraints and UTF-8 charsets are preserved without collisions. ✅ Scripted data parsing and normalization (standardizing E.164 phone formats, lowercasing/validating RFC-compliant emails, trimming whitespace, and handling UTF-8 encoding). ✅ Pre-import deduplication against existing account numbers and customer IDs, with transaction-wrapped bulk INSERTs to preserve referential integrity. ✅ Full mysqldump backup taken prior to ingestion, accompanied by the reproducible SQL migration script and an itemized plain-text rejection/adjustment log with source row references. ✅ 10+ years production experience | 400+ completed projects | 320+ five-star reviews ✅ Microsoft® Certified: MCSA | MCSE | MCT & cPanel Certified (CWSA-2) Are customer IDs auto-increment primary keys in your schema, or are they existing business identifiers that must map to existing parent records? My rate is 50 USD/hour and I can start immediately.
$50 USD in 1 day
5.8
5.8

I can handle this migration carefully and make sure the final MySQL data is clean, consistent, and fully verifiable. I bring 18 years of backend and database experience, including MySQL, PHP, Python, data migration, validation, and production systems. For this task, I would: Review the existing MySQL schema and spreadsheet structure Map each source column to the correct database field Detect duplicate customer IDs and obvious duplicate records Normalize phone numbers and email addresses to match current conventions Preserve UTF-8 content and InnoDB referential integrity Validate foreign keys before final insert Import the ~3,000 records in a controlled batch Run post-import checks for row counts, duplicates, nulls, and rejected records Provide a reusable SQL/CSV import file Deliver a plain-text exception log with spreadsheet row references and any adjustments made I prefer using a scripted import process where possible because it gives better validation, repeatability, and rollback safety than manual entry. I can work with phpMyAdmin, MySQL Workbench, or command-line MySQL depending on your environment. The final result will be reproducible, documented, and easy for you to audit or rerun.
$50 USD in 40 days
6.2
6.2

Hi, there. "MYSQL CUSTOMER DATA IMPORT" — you need clean records moved without breaking your live database. I would first map the spreadsheet columns against your existing schema, then validate formats before import. I’ll handle duplicate checks, phone/email cleanup, and keep the InnoDB relationships intact with a clear import log and reusable SQL or CSV file. The main risk here is partial imports or silent data mismatches, so I would verify row counts, customer IDs, and sample records after loading. Are the spreadsheets already using consistent column names, and do you have an existing duplicate rule (email, phone, account number, or customer ID)? Looking forward to working with you.
$50 USD in 40 days
5.2
5.2

Hi, Aashiq here from Cape Town, South Africa. This project instantly caught my eye, so I had to reach out. I see you’re looking for someone to accurately move customer information from spreadsheets into your MySQL database, ensuring no duplicates and maintaining referential integrity. That’s right up my alley! With extensive experience in data migration and database management, I've helped businesses streamline their data processes and improve accuracy. I’m confident I can deliver clean, normalized data that matches your schema. Feel free to ask for samples of my past projects. Based on what you mentioned, here is how we would approach the project: - Review the existing data for duplicates. - Normalize phone and email formats to match your conventions. - Use MySQL Workbench for the most efficient import process. You can count on clear communication throughout, and I’ll ensure a seamless, user-focused solution optimized for performance. Best Regards, Aashiq
$50 USD in 7 days
5.3
5.3

With a rich experience of over 9+ years in web development, mobile development, and a specialization in the core tools you are seeking for this project (MySQL and PHP), I believe I am well-suited to offer my services. Having worked on several projects involving MySQL data migration and normalization, I possess profound insights into maintaining referential integrity and ensuring an uncluttered database. I'm proficient with multiple import methods, including phpMyAdmin, MySQL Workbench, and command-line routines; all are well versed in my skill set. Given the volume of data to be transferred (around 3000 records), I understand the importance of accuracy and will leave no stone unturned in detecting duplicates or normalizing phone/email formats to align them with existing conventions. My approach is thorough; apart from delivering fully-populated tables with no duplicates and a log of any adjustments made during the upload process, I will also hand over the SQL script or CSV file used for your future convenience. In addition to being efficient, my work guarantees lasting output—an attribute that serves as a testament to quality code writing. I believe in evolving ideas into reality—so let's transform your spreadsheets into an organized MySQL database and harness its true potential. Having solved diverse challenges throughout my career, I am prepared to handle any obstacles during this project as well. Let's connect soon to discuss further details!
$50 USD in 40 days
5.4
5.4

Hi there, Fernando here from Mexico. I understand you need around 3,000 customer records moved from multiple spreadsheets into your existing live MySQL database without disturbing the current schema or referential integrity. I can clean and validate the source data first, detect obvious duplicates, normalize phone and email formats to match your existing conventions, then perform the import with careful checks on customer IDs and UTF-8 data. I’ll also provide a clear adjustment/import log with row references and the exact SQL or CSV used for the final upload, so the process remains repeatable and verifiable. Quick questions: Q1. Can you provide the current table definitions and a few representative spreadsheet rows so I can map fields and identify duplicate/normalization rules before import? Q2. Do you have an existing convention for phone/email formatting and any tables that depend on the customer records through foreign keys? Looking forward to work with you. Thanks Fernando
$50 USD in 40 days
5.0
5.0

Hi there! Your project’s focus on accurate, clean migration of customer data into MySQL aligns perfectly with my experience. I understand you need approximately 3,000 customer records consolidated from multiple spreadsheets into your existing schema, with careful attention to duplicate detection and normalization of contact fields. Maintaining referential integrity in an InnoDB UTF-8 database is key, and I’m well-versed in ensuring data quality while using phpMyAdmin, MySQL Workbench, or command-line tools based on your preference. I’ve completed similar projects involving large-scale data entry, cleansing, and import, always prioritizing accuracy and clear documentation. I’ll ensure that the final tables are free from duplicate IDs, and I’ll provide both a thorough log of any data adjustments or unimported rows and the SQL or CSV files used for the upload, allowing you to rerun or audit the process with ease. To clarify: Would you like the duplicate check to be based solely on customer ID, or should I use other fields (like email or phone) for broader deduplication? Also, do you have specific formatting rules for phone numbers and emails that I should follow? Best Regards, George
$50 USD in 2 days
4.4
4.4

I understand you need to migrate ~3000 customer records from spreadsheets into your existing MySQL database, ensuring data integrity and standardization. My experience with similar data import projects, including cleaning and normalizing phone numbers and email addresses to match existing database conventions, makes me confident I can deliver this efficiently. My approach will involve a multi-step process: First, I'll create a staging table in your database to load the raw spreadsheet data, allowing for easier manipulation and validation without impacting live data. I'll then use SQL scripts to perform the necessary data cleaning, including duplicate detection based on account numbers and normalized contact details. Phone numbers will be standardized to a consistent format (e.g., XXX-XXX-XXXX), and emails will be validated for correct structure. Finally, I'll use `INSERT ... SELECT` statements to transfer the cleaned data into your live customer table, carefully preserving referential integrity within the InnoDB engine and ensuring UTF-8 compatibility. To ensure the smoothest possible integration, could you confirm the exact format of phone numbers and email addresses currently present in your live database? Also, what is your preferred method for handling records that might still present as duplicates after initial normalization? I'm available for a brief call to discuss these details and outline the specific tools and scripts I'll employ.
$50 USD in 7 days
4.0
4.0

Hello Sir, I have already worked on similar types of website and software development projects and I am confident that I can successfully handle your project. I am a full-time freelancer with **17+ years of experience** in web development, software development, automation, and API integrations. My expertise includes: * ASP.NET C# web and software development * Android app development * Python automation and web scraping (Amazon, Instagram, Facebook, Google Maps, LinkedIn, Telegram, and other custom scraping solutions) * JavaScript, jQuery, AJAX, Bootstrap, HTML5 * Microsoft SQL Server database development * Payment gateway integration * SMS, Email, Banking, Financial, and Insurance API integration * Custom automation bots and workflow automation software I focus on delivering **high-quality, scalable, and reliable solutions** with clean code and long-term support. Please contact me in private chat so we can discuss your requirements in detail. I can also show you a **demo of similar projects** I have completed. Looking forward to working with you. Thanks & Regards
$50 USD in 8 days
3.6
3.6

With my rich expertise in MySQL and PHP, specifically, importing and managing large volumes of data, I offer you a value proposition: the completion of your task with utmost proficiency while meeting all required specifications. I have an extensive experience of six plus years. My forte includes working diligently with REST APIs, normalizing large datasets, ensuring data integrity, and producing efficient and compact databases. Additionally, I am well-versed with 'phpMyAdmin', MySQL Workbench' alongside command-line import routines making me adaptable to handle the job without any trouble or delay. I understand the importance of data reliability and consistency and given that your records need to be transformed into existing conventions. I will ensure all contact details are well formatted and any duplication is eliminated. Importing such enormous data sets require meticulousness and attentiveness, which are virtues that have come to define my work ethic. Furthermore, as suggested by the project description I'll maintain a detailed plain text log with row references along with the script/CSV file used for importing for a vivid recap of performed duties. I look forward to processing this in an organized manner for maximum efficiency so that you may utilize this log for potential future re-run if need be.
$50 USD in 40 days
3.3
3.3

==== Hi - Manh here ==== "3000-CUSTOMER MYSQL DATA MIGRATION" - you need spreadsheet records cleaned, imported, and verified without breaking the live database. I’d stage the spreadsheet data first, normalize phone and email formats, check obvious duplicates, then import in controlled batches so existing InnoDB relationships stay safe. I’ll also provide the exact upload file or SQL script plus a row-level log for anything changed or rejected. Can you provide the current MySQL table definitions and a small sample spreadsheet so I can match the import fields precisely? Looking forward to work with you.
$50 USD in 40 days
3.0
3.0

Hi, I can accurately migrate your 3,000 customer records from spreadsheets into your MySQL database while preserving data integrity and existing relationships. With 10+ years of experience in MySQL, PostgreSQL, PHP, phpMyAdmin, and database migrations, I focus on clean imports with thorough validation. What I'll deliver: * Accurate import into your existing InnoDB/UTF-8 schema * Duplicate detection and normalized phone/email formats * Referential integrity checks before and after import * A detailed import log for adjusted or skipped rows * The final SQL script or CSV import file for future reuse I can work with phpMyAdmin, MySQL Workbench, or CLI, verify the imported data against your sample records, and provide a reliable, production-ready migration with minimal downtime.
$50 USD in 40 days
2.9
2.9

Hi I'd import the spreadsheets through a staging step first rather than writing unvalidated rows directly into your live tables. That gives me a safe place to normalize phone/email formats, check duplicate customer IDs and account data, and verify foreign-key relationships before the final insert. For the final load I'll use a repeatable SQL/Python import routine with transactions, then compare source/imported row counts and spot-check the resulting records so the result is clean and verifiable. You'll also receive the exact reusable import file plus a plain-text exception log showing every adjusted or skipped source row and the reason. Once you send the table definitions and sample rows, I'll first match your existing duplicate and formatting conventions before importing anything into production. Thanks, Belal
$50 USD in 40 days
0.4
0.4

Kathmandu, Nepal
Member since Sep 19, 2026
$30-250 USD
₹1500-12500 INR
₹750-1250 INR / hour
$250-750 USD
$750-1500 USD
$15-25 USD / hour
₹12500-37500 INR
$50-250 USD
£18-36 GBP / hour
$30-250 AUD
$250-750 USD
₹12500-37500 INR
₹600-1500 INR
₹1500-12500 INR
$30-250 USD
€30-250 EUR
€750-1500 EUR
$30-250 USD
$10-30 USD
₹1500-12500 INR