Find Jobs
Hire Freelancers

Merge two sets of excel data

$250-750 AUD

Completed
Posted over 4 years ago

$250-750 AUD

Paid on delivery
Hi, I have two excel spreadsheets that I would like to merge together. The merge field that is the same on both sheets is a name. Would require some data validation as some entries may have a dulplicate name. Samples included below. Approx 3000 entries.
Project ID: 23761039

About the project

72 proposals
Remote project
Active 4 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 merge your data name field that is the same on both sheets & do validation for duplication. can we discuss?
$300 AUD in 3 days
4.9 (472 reviews)
8.1
8.1
72 freelancers are bidding on average $318 AUD for this job
User Avatar
i can help you to merge both sheet. I have good knowledge in Excel. IF you want message me so we can discuss more.
$250 AUD in 3 days
5.0 (831 reviews)
8.8
8.8
User Avatar
Hi Sir/Madam, It is being my pleasure to introduce you to me. I am expert in advance excel. I have excellent knowledge of advance excel. I know many things in excel like Formulas (Countif, Sumif, Index match, Vlookup and offset etc.). I have reviewed attached sheets. I will complete work. Please review my profile. My profile is suitable for this project. I will complete this project on time. Please give me a chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786
$250 AUD in 1 day
5.0 (596 reviews)
8.5
8.5
User Avatar
Hi there. I checked both the spreadsheet. Merging both the spreadsheets will be done within 2 days of project awarding. There will required some data validation and formatting. Please check my feed backs for my expertise in spreadsheet formatting projects done. I have completed 500+ projects. Everything is self explanatory and I can start right away. Best, Harish
$250 AUD in 2 days
4.9 (461 reviews)
8.6
8.6
User Avatar
Okay I can merge your excel's and remove duplicates from the file. i can deliver the final output file within the 30minutes to one hour max can we discuss more to start the project now Please msg me Thanks and regards Ajay
$250 AUD in 1 day
4.9 (1097 reviews)
8.3
8.3
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will merge data from 2 spreadsheets based on the ICSEA number and deduplicate the merged data. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $300* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 350 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$300 AUD in 5 days
5.0 (475 reviews)
8.4
8.4
User Avatar
Hello, I’m an Excel expert and I can merge your excel data. Please check my profile and contact me to discuss further details. Regards.
$250 AUD in 1 day
5.0 (499 reviews)
8.0
8.0
User Avatar
I have just checked through your both sheets. Message me so we can discuss further. Waiting for your reply
$250 AUD in 3 days
5.0 (584 reviews)
7.7
7.7
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) I can do merge your 2 file please ping me now for discuss more and im free now to start working your project right now Thank you Galih
$250 AUD in 2 days
4.9 (439 reviews)
7.6
7.6
User Avatar
Hi, I know data manipulation very well. I can merge these files based on "school name". Also I can remove duplicate in a separate doc. I have done it many times within the different projects. I can use R for this (saving result file as excel file) or just only Excel. Please let me know if you are interested in my proposal. Regards, Alex.
$250 AUD in 3 days
5.0 (51 reviews)
7.7
7.7
User Avatar
Hi There, I am an advanced excel specialist. I have reviewed both the attached spreadsheet and I will merge the files into one. I will remove all the duplicates and do validate the data of all 3000 records. The final output you will get in an excel will be 100% neat and clean format. Please do check out my reviews. You will never be disappointed hiring me for this task. Waiting for your response!
$250 AUD in 1 day
4.9 (103 reviews)
7.6
7.6
User Avatar
Dear sir I will merge both sheets and will also do data validation.I will provide you data done in 2-3 hours. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will always work with me for these kind of projects. would you like to discuss the project with me?
$250 AUD in 1 day
4.8 (171 reviews)
7.4
7.4
User Avatar
Hi There, I can merge your 2 excel sets data as per your requirements. I can give you the quickest delivery. Please allow me to start your work now. Thanking You Razia
$450 AUD in 4 days
5.0 (270 reviews)
7.1
7.1
User Avatar
$ 250 AUD only ------ In just 1 day ------- Excel VBA Macro Coding, Formula Generation and Automation Process Expert with 5 Ratting -------- I can start right now, please message me to discuss more.
$250 AUD in 1 day
5.0 (387 reviews)
6.8
6.8
User Avatar
Hi, As per requirements, I will merge your Excel files as per the description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I look forward to discussing the project with you and hopefully secure a long term working relationship. I am ready to work on this project now. Thanks and regards, Mohan
$250 AUD in 7 days
5.0 (100 reviews)
6.5
6.5
User Avatar
Hello I am Interested in this project . I am expert at excel. I can merge those two sheet properly. I can validate the names also perfectly. Lets chat for more details. Thank You
$250 AUD in 2 days
4.9 (107 reviews)
6.7
6.7
User Avatar
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$320 AUD in 4 days
5.0 (211 reviews)
6.6
6.6
User Avatar
Hi, Keen to work on this project and I am well versed with Excel and its various features. I am happy to do this in 200 AUD, but since the minimum bid is 250, I am putting 250. I am well versed with Excel and its various features like Pivot tables, HLookup, Vlookup, SUMIF, Left, Right, Index Match, drop down, filters, charts, graphs, conditional formatting, mail merge, dashboards and can provide the Excel that you are looking for. I have more than 15 years of working experience to my credit. I will be happy to answer any queries that you may have. Looking forward to your response. Thanks
$250 AUD in 2 days
4.9 (123 reviews)
6.5
6.5
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I am a full-time freelancer, I can start working on the project immediately and complete the job within one, maybe two days. If you send me a job specification, I'm ready to create a free draft pilot for you. Regards
$250 AUD in 2 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi there, I have good experience handling large amount of data and cleaning them up. I can merge your data and complete this work with good quality. My profile reviews will show the feedback I get my work. Regards. Reuben
$250 AUD in 1 day
5.0 (25 reviews)
5.2
5.2
User Avatar
Hi, I can see the school name can be used as unique value in both Excel, and you want to have data in School upload example. I suggest to have VBA to do the mergin, so then we can use this Macro to do the mergin again over time. I can write you such VBA code, please send me message to discuss more.
$300 AUD in 2 days
5.0 (14 reviews)
5.0
5.0

About the client

Flag of AUSTRALIA
Canberra Mail Centre, Australia
5.0
1
Payment method verified
Member since Feb 6, 2020

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.