Performing queries between one or more excel files

$10-25 USD

I përfunduar

Postuar

almost 2 years ago

$10-25 USD

Paguhet në dorëzim

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

ID e Projektit: 34006143

Rreth projektit

48 propozime

Projekt në distancë

Aktive 2 yrs ago

Po kërkoni të fitoni para?

Adresa e email-it

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj

Paguhuni për punën tuaj

Përshkruani propozimin tuaj

Është falas të regjistrohesh dhe të bësh oferta për punë

I dhënë për:

@rylkov

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 në 1 ditë

5,0

(3 përshtypje)

2,5

48 freelancers are bidding on average $19 USD for this job

@RSUKANTA2014

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 në 1 ditë

5,0

(393 përshtypje)

7,4

@rahulg5466

--------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 në 1 ditë

5,0

(69 përshtypje)

5,6

@umairnoor32

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 në 1 ditë

5,0

(53 përshtypje)

4,3

@vw1514518vw

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 në 1 ditë

5,0

(11 përshtypje)

4,4

@edatawiz

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 në 1 ditë

5,0

(22 përshtypje)

4,2

@aldobraida98

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 në 1 ditë

5,0

(18 përshtypje)

4,0

@AhDardear

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 në 7 ditë

4,9

(10 përshtypje)

3,4

@wilfrednjorog

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 në 1 ditë

5,0

(1 review)

2,9

@akibul18

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 në 1 ditë

5,0

(6 përshtypje)

3,0

@Syedzaidi213

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 në 7 ditë

5,0

(4 përshtypje)

3,0

@nawazacca

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 në 1 ditë

5,0

(3 përshtypje)

1,8

@hungng945

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 në 1 ditë

5,0

(1 review)

1,0

@DataHunter1

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 në 2 ditë

4,2

(1 review)

0,4

@yarahim2022

basic software knowledge, strong communication skills, fast typing speeds, attention to detail, and commitment to accuracy.

$18 USD në 7 ditë

0,0

(0 përshtypje)

0,0

@ajengdiaas

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 në 5 ditë

0,0

(0 përshtypje)

0,0

@shaikhsahidnazer

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 në 1 ditë

0,0

(0 përshtypje)

0,0

@xChellai

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 në 7 ditë

0,0

(0 përshtypje)

0,0

@ravishaw25

Hi, I have great data entry skills. I will provide you best and accurate service with complete satisfaction.

$10 USD në 5 ditë

0,0

(0 përshtypje)

0,0

@shadu19

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 në 4 ditë

0,0

(0 përshtypje)

0,0

@Shabnoorkhan098

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 në 1 ditë