Find Jobs
Hire Freelancers

Data Clean - Excel to Sql

$30-250 USD

Completed
Posted almost 10 years ago

$30-250 USD

Paid on delivery
I need 5M records cleaned in Excel and put into sQLLITE , MYSQL. Some data is inputted in duplicated columns that need to be put into one the problem lies mainly with the parsing of the data. While scraping this data, the fields were not properly aligned due to the ", " delimiter. see image Data currently resides in 5 excel spreadsheet.
Project ID: 5775995

About the project

31 proposals
Remote project
Active 10 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
I will do a program a to read and eformat all data in a correct CSV format, suited to be loaded to DB. I will then give you the resulting files (in CSV, Excel, SQlite or MySql format, what you prefer). I will give you the program too, if you need it for future uses.
$120 USD in 2 days
5.0 (8 reviews)
4.4
4.4
31 freelancers are bidding on average $145 USD for this job
User Avatar
Dear Sir, I can do it right now and will done tomorrow for you. I'm process excel data and import to mysql, sqllite many before. Thanks. Thanh
$155 USD in 1 day
5.0 (33 reviews)
5.4
5.4
User Avatar
Hi, we are ready to work for this, we can do a perl script to parse data from excel file and put it to mysql database and also we can apply some kind of validation for fixing the bugs Thanks
$200 USD in 3 days
4.7 (46 reviews)
5.3
5.3
User Avatar
Hi, I'm very interested helping you cleaning and creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your database, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$147 USD in 3 days
4.9 (33 reviews)
5.2
5.2
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$200 USD in 10 days
4.9 (27 reviews)
4.4
4.4
User Avatar
Dear Sir Please assign this task for me I can assure 100% completion. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and five years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$35 USD in 3 days
5.0 (7 reviews)
3.4
3.4
User Avatar
Hi dwierman, let me do that for you. I am an Excel expert and have significant experience in Data normalization. Unlike other freelancers I will not just "update" spreadsheet, I will actually clean it and normalize it for you. I also have MySQL experience so can Upload these tables for you if needed. Regards, Alex
$147 USD in 5 days
3.6 (1 review)
3.3
3.3
User Avatar
I already done this type of project and database conversion,please check my profile.I am 100% responsible person when get the work.I have 3 year industrial experience in software development with SQL Server, MySql Sqlite with C#.Thank you for the considering my bid.
$161 USD in 3 days
5.0 (1 review)
2.5
2.5
User Avatar
hi its not a complicated task but time consuming task because of huge data to be import into mysql from excel without any error.i will finish the job in time and submit you file with accuracy on time for testing my work assign me one excel file to import into mysql. if you like my work speed and accuracy then you accept my bid . i am waiting for your positive response and looking for long good term relation with my empolyer. Open private message and assign me the job thanks
$155 USD in 7 days
5.0 (4 reviews)
2.2
2.2
User Avatar
Hi I'm interested in this job. I'm an IT specialist, my expertise includes any kind of data manipulation, file to mysql and vise versa. I will put the xls data into mysql database and do whatever you like with it. Contact me for details. Regards, Rafal
$35 USD in 1 day
5.0 (2 reviews)
2.1
2.1
User Avatar
Hello. More 20 years programming experience. Have done similar many times - It will be necessary exact definitions for parsing Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$100 USD in 5 days
5.0 (3 reviews)
1.7
1.7
User Avatar
Предложение еще не подано
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am working for US based company (Medical Billing) from last 5 years. I have more than 4 years experience in data base handling (Sybase & Mysql) and also have experience in Excel. So I can do this task perfectly. Please discuss & give more details about your project. We can work together.
$105 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am interested for this project. I am working in IT for last 12 yrs having in-depth knowledge in SQL, PL/SQL, Performance Tuning and Database Administration. Please feel free to contact me for any Database related work. I'll be happy to help you.
$155 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Have already done a lot of data transformations from Excel into MySQL and vice versa. My preferred programming language is Perl. It is known for its strength in data manipulation with regular expressions which will help to sort out the issues with the malformed table rows. That makes me a good candidate to fulfill your demands. Best regards Perl-SQL-Master
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on this project type. My project is exporting from excel to html. I have use apache poi for doing it.
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi The job seems not too hard. I have a good computer. I have 10 years experience in similar projects. I used SQLLite 10 years ago :) But this is not a problem. If you can give me login on MYSQL it will be better. I can do this job in 1 day. But I propose you 2, if I faced with some difficulties.
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can do this. I have more experiance with data migration(excel to MYSQL, and etc..). What is the size of the Excel? Price may be adjusted. Andrius,
$66 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have extensive experience with handling large files and databases. I have worked with CSV files of over 10 GB and databases larger than 1 TB. My programming language of choice is Python and I believe I can finish the task in 6-8 hours. If you want to send me a sample file I will process it and send you the result so you can verify it. Afterwards if you are satisfied with the result we can continue the collaboration. Thank you for your time! Best wishes, Ionut
$111 USD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I'm a software engineer with good knowledge in excel macro and sql design I can do this for you with money back warranty
$77 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Taylors, United States
5.0
201
Payment method verified
Member since Jan 17, 2007

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.