Find Jobs
Hire Freelancers

Create database from CSV then create program that matches/merges database to other CSV/Excel files.

$30-250 USD

In Progress
Posted over 5 years ago

$30-250 USD

Paid on delivery
**Please note: I have an Apple MacBook. This database and program need to function on MAC OS.** Project: I have 2 different lists. One list is a CSV file with every business in one State in the USA. (4,500,000+ records) which needs to be turned into a usable database. The file includes the business name, the people who own and operate the business, the business address etc. The other list(s) are lists I purchase that have real estate owned by businesses. These lists do NOT have the names of the people who own and operate the businesses, just the business/entity name. The key identifier in both lists is the business/entity name. I need a program to match records from my real estate lists to records in the MA business database and merge the two so the final result includes business name, business owner and operators, and the real estate the businesses own. I buy these lists regularly so I need the program to be able to allow me to easily merge new lists in the future. I know nothing about database design, SQL, VBA, Excel etc. so you would need to advise on the best way to build the database/program and on if it should be hosted locally or have a web based program etc. Thanks!
Project ID: 17237511

About the project

32 proposals
Remote project
Active 6 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
Dear customer, looking forward to provide a solution to your business need. I would deliver a web based solution. You just open your browser (safari in your case on mac os) upload both csv files and get the merged vsc for download. Best regards, Joerg.
$99 USD in 3 days
5.0 (1 review)
2.0
2.0
32 freelancers are bidding on average $176 USD for this job
User Avatar
Hello, I can help with you in your project Create database from CSV then create program that matches/merges database to other CSV/Excel files.. I have more than 5 years of experience in Database Development, Excel, Excel VBA, SQL. We have worked on several similar projects before! We have worked on 350+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction.
$250 USD in 3 days
5.0 (503 reviews)
8.4
8.4
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards
$250 USD in 10 days
5.0 (321 reviews)
7.4
7.4
User Avatar
Hello, how are ya? I am Wen. I've read your project details carefully, very excited for checking your brief. I hope you to open chat with me to get discussion about your project more detail. Thanks.
$500 USD in 10 days
5.0 (24 reviews)
6.4
6.4
User Avatar
hi! I can help you. Just give me your files (CSV/Excel) and I'll figure out what I can do. Just want to build you an excel database that is very easy to use. And if you won't like what I do just to pay me. thanks
$90 USD in 5 days
4.9 (64 reviews)
5.4
5.4
User Avatar
Hello how are you I think it is possible with php and mysql and csv i can merge it as your requirement please contact me I am ready to work and i can start to work immediately thanks
$155 USD in 3 days
5.0 (9 reviews)
5.1
5.1
User Avatar
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
$155 USD in 10 days
4.9 (38 reviews)
5.3
5.3
User Avatar
Thank you for looking at our bid, sorry for exceeding max budget. As you want this application on Mac, can we propose a Java based application - - that can import new files as required - You can also export merged records having required columns. Kindly check out my Freelancer portfolio https://freelancer.com/u/fleetways.html for previous work. It would be great if we can get an opportunity to discuss this project further. Thank you.
$833 USD in 21 days
5.0 (2 reviews)
5.0
5.0
User Avatar
Hi I am very,very interested in your project My name is Shan Bin and I'm a Chinese developer. I have 6 years of development experience such this projects. I am a highly skilled developer in C, C++, C#, Python, Java, Perl, NodeJS, Reverse Engineering etc. Also I have already experienced with the job similar to this job. Please contact me. Looking forward to hearing from you soon. Best regards. Thanks
$200 USD in 3 days
5.0 (10 reviews)
5.1
5.1
User Avatar
I am very able to create a vba script to cater your requirement. I am ready to start
$167 USD in 3 days
4.5 (46 reviews)
5.6
5.6
User Avatar
Hello i am so highly skilled python dev . i suggest a python script to do this work and mysql or postgresql database . i like we discuss more over chat for more details
$55 USD in 1 day
4.7 (26 reviews)
4.9
4.9
User Avatar
I am a python expert and i can make you a script that does exactly the same. I can start immediately and can complete it. please check my reviews to see my quality of work. please message to discuss details.
$30 USD in 1 day
5.0 (11 reviews)
4.7
4.7
User Avatar
Hey there!! I am ready to provide you the great service from the right away. I've 5+ years experience in this field. And I will be glad to work with you for long term way. I will assure you that you will get a quality work according to your instructions. I'm ready to start the work right now. I am an expert in the following Database Development, Excel, Excel VBA, SQL, C# Programming, PHP, WooCommerce, WordPress, Website Design etc. Regards, George
$210 USD in 3 days
4.9 (10 reviews)
4.9
4.9
User Avatar
Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Champion
$166 USD in 5 days
5.0 (10 reviews)
4.6
4.6
User Avatar
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can write VBA programme for you to perform this task and also suggest you the better platform to do with. Please come on chat for more details. Awaiting your response. Thank you.
$50 USD in 3 days
4.4 (46 reviews)
4.8
4.8
User Avatar
Hello, Myself Barduga, I have 10+ years of experience in data conversion activity. I have worked on many data conversion projects from Excel spreadsheet to other DB systems. I have developed macros for extracting Excel data. Looking forward for your reply. Please feel free to discuss with me. Warm Regards Barduga
$170 USD in 5 days
5.0 (7 reviews)
3.7
3.7
User Avatar
1. Excel expert with extensive vba programming experience. I am versed in multiple languages as well as SQL Server, Oracle, MS Access, My SQL. After talking to you more I could advise you better as to which approach would work better for you and whether or not you should host it locally or on the web. I can build a program for you that you can reuse each day to merge new files and merge them into the new database. I do work similar to this regularly. 2. I have worked for several years in excel and perform daily work using vba, user forms, pivot tables, formulas, etc. 3. I would start by committing to 3 days but this depends on the scope and could change 4. I have an extensive background in Excel. I would love to know more about your project.
$155 USD in 3 days
5.0 (1 review)
3.8
3.8
User Avatar
hi. i can write a python script for this. i have some questions. why you need a database for this? do you need to do anything more than just merge CSV files into one? can you give a minimal example of data files and how the resulting CSV file should look like?
$150 USD in 3 days
5.0 (3 reviews)
3.6
3.6
User Avatar
I own a Macbook Pro and have experience in databases administrations, programming and text processing on microsoft excel.
$30 USD in 1 day
5.0 (5 reviews)
3.4
3.4
User Avatar
Hi, I can create a configurable software (for MACBOOK) using .net core. You can configurate the merge using the pivot columns for the 2 differents lists. The sw will produce the 1 csv. I am an italian developer. Have a nice day Angelo
$444 USD in 10 days
5.0 (6 reviews)
3.1
3.1
User Avatar
Hello, I'm coder, I have more than 8 year experience in html, css, jquery, php, mysql, wordpress,joomla,..... I do many import csv to db projects, I have read your requirement and understood what you need, it can be done in web app. please discuss, thank you!
$111 USD in 2 days
5.0 (3 reviews)
2.8
2.8

About the client

Flag of UNITED STATES
Somerville, United States
4.7
12
Payment method verified
Member since Sep 29, 2014

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.