Find Jobs
Hire Freelancers

Performing queries between one or more excel files

$10-25 USD

Teljesítve
Kiadva ekkor: majdnem 2 évvel ezelőtt

$10-25 USD

Teljesítéskor fizetve
Performing queries between one or more excel files. Hi everyone, I need some help to perform some query using Excel or GoogleSpreadsheet. Let me explain the problem: I've got 1 excel file that contain "Company Name", "Company Website" & "Email" (plus other columns not really relevant). Some companies has got empties values in "Email" field. So I've used a software to perform a scraping activity. Basically the software navigate each links and search for email fields. The output is a new file excel that contain "Company Website" and "Email". In Total I've got 18 raw excel files plus 18 excel files given from Scraping software. The goal is to compare/lookup "Company website" from excel file A with "Company Website" from excel file B, If the values ​​are the same we must copy "Email" values from excel file B and append it into excel file A in the correct row. Check attached examples files Please ping me for futher info, we can start an Anydesk session in order to show you what is the result I expect. Thanks everyone for your kindly attention
Projektazonosító: 34006143

A projektről

49 ajánlat
Távolról teljesíthető projekt
Aktiválva: 2 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
Hi, I'm sure that I have enough experience to implement Excel Macros for you needs. You can see in my profile that I implemented several projects related with Excel. You could give me all files, create milestone and I can start. Best regards, Siarhei
$25 USD 1 napon belül
5,0 (2 értékelés)
2,3
2,3
49 szabadúszó adott átlagosan $19 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Hello, I just seen the excel file A which have the websites. Can you please send me the excel file B too? Then I can understand this better. Also if you want I can do some sample work too before starting. Thanks.
$25 USD 1 napon belül
5,0 (374 értékelés)
7,3
7,3
Felhasználó avatár
--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
$25 USD 1 napon belül
5,0 (19 értékelés)
3,9
3,9
Felhasználó avatár
Hi there - It looks like the file you attached needs cleanup too. Do you have more than 45,000 rows in each of the 12 raw files ? Its more easy to consolidate separately all raw files and files with email and then do simple comparison to get the email. I am available for a quick chat. Regards Vishy
$25 USD 1 napon belül
5,0 (16 értékelés)
3,9
3,9
Felhasználó avatár
Hi, hope you're doing well! My name is Aldo. I am an advanced actuarial student. I have great knowledge of working with: R, Python, SQL, VBA, Excel, finances and statistics. I always deliver high quality projects within accepted time limit and budget. Please reach out to me so we can... have a detailed discussion/discuss the details :) - Thanks, Aldo.
$20 USD 1 napon belül
5,0 (17 értékelés)
3,9
3,9
Felhasználó avatár
Hello there, I will write a code (VBA) in excel throgh which data will be retrieved from one excel file to another by matching.. Looking forward. -Akibul
$18 USD 1 napon belül
5,0 (2 értékelés)
2,5
2,5
Felhasználó avatár
Hello! I am expert and professional in this work, I have read all your details and I will work on your project with low price and unlimited revisions. Give me this project and get extraordinary and 100% work. Thanks ? Regards umair
$15 USD 1 napon belül
5,0 (7 értékelés)
2,3
2,3
Felhasználó avatár
Dear Sir, I check the example and understand your requirements. I will do it for you in no time and I am sure you will be happy with my work. all I need is a 5 star review. Thanks
$18 USD 1 napon belül
5,0 (3 értékelés)
1,8
1,8
Felhasználó avatár
Hi, Greetings I Have Read Your Project Brief And I Understand That Your Of Entering The Right Email From File b To File A In Relevant Company Name Row. I Want To Ask That How Many Company Names In 1 Excel File ? I Can DO You Task Efficiently And I Can Start Now. Message Me, And We Can Start Immediately. Regards Syed Mudassar Zaidi.
$15 USD 7 napon belül
5,0 (1 értékelés)
1,4
1,4
Felhasználó avatár
Dear, To make the long story short, your task is achivable and I am Spreadsheets expert. I am ready to start working immediately, just share your data. Looking forward to your call. Yours Ahmed Saad
$15 USD 7 napon belül
5,0 (1 értékelés)
1,4
1,4
Felhasználó avatár
Hi I've read the project description carefully. I'm an expert in Excel VBA. Hope you contact me to discuss project more detail. Best regards!
$50 USD 1 napon belül
5,0 (1 értékelés)
1,0
1,0
Felhasználó avatár
Ready to develop a macro/script tool that will auto compare file A with web search result File B form matched web site name then fill Email field in file A with matched records from File B
$15 USD 1 napon belül
5,0 (1 értékelés)
0,8
0,8
Felhasználó avatár
Hello! I am professional writer with the vast skills and qualifications necessary for this job. I have experience in Excel Macros, Google Spreadsheets, Excel, Excel VBA and Data Management. I am confident that I can produce high-quality work that meets your specifications. If given the opportunity, I will exceed your expectations. I look forward to hearing from you. Please contact me to discuss more about this project. Thanks & regards Wilfred
$30 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi, I hope that you are well. I have read your posted job and understood it. I Can do this job according to the requirements. I am an experienced data entry expert and virtual assistant providing services ranging from data entry to file conversion I always pay attention to the requirements and accuracy of the job. You can also assign me any simple task for free as a test to check my ability. I can start right now, I have a question to ask. Please contact me so that we can discuss it. Thanks and have a good day.
$15 USD 2 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
basic software knowledge, strong communication skills, fast typing speeds, attention to detail, and commitment to accuracy.
$18 USD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi good evening, I will summarize all the lectures and provide you with clear, concise notes. I am a Undergraduate student who profesional at data management with 2 years of experience. I’ve worked on several similar projects data scraping on excel. I’m interested to hear more about the project and the subject matter of the lectures. If you award me the project, I’d be pleased to discuss this further and get started for you as soon as possible. Thank you!
$18 USD 5 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I CAN DO THIS AS SOON AS POSIBLE .I ALREDY DO THIS TYPE OF WORK IN MY PAST... IF YOU GIVE ME THIS WORK YOU WILL NOT REGRATE.
$18 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi! I'm Rachelle, 27 years old from Philippines. I'm a hardworking and dedicated person. Prioritizes time management in every task I do to meet deadlines. I believe my personality, perspective, skill and work knowledge suits your qualifications.
$20 USD 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.
$10 USD 5 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello Sir, I have now read your Proposals very carefully and I have seen the Excel sheet given by you, it is an incomplete sheet, I have received from your given Company Name, Website, Phone, Headquarters, Company Email, Street Address, City, State, Zip Code, Country , LinkedIn URL, Note is able to give this information accurately. Thank you
$15 USD 4 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi There! I have read through your instructions very carefully ,from that I understood that you want to compare file A and B and make sure that the value are same . You also want to copy Emails from file B to A in correct order. I can do this task accurately and on time. I have 5 years of excel and Vba experience and have done this kind of projects a number of times . I also ensure the quality of the content at reasonable rates before the deadline. Please come over chat and discuss your requirement in a detailed way. Thanks, Shabnoor.
$10 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

ITALY zászlója
Napoli, Italy
5,0
9
Fizetési mód hitelesítve
Tagság kezdete: nov. 25, 2020

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.