Closed

Data Extraction from master spreadsheet

We need someone to either personally extract data/develop a tool to extract data from a master data spreadsheet. The spreadsheet contains information on Public Sector contracts awarded by the Government in a year, the names of the companies who have won them, their value, the name of the contracting authority and contact details.

We need this information to be extracted into a separate spreadsheet and collated by company, giving us a view of how many contracts they won in that year, who the contracting authority was and how much they were worth.

Skills: Data Entry, Data Mining, Excel, Software Architecture, Web Scraping

See more: how to pull data from multiple worksheets in excel, how to automatically update one excel worksheet from another sheet, how to create a master sheet in excel 2013, excel pull data from another sheet based on criteria, excel pull data from another sheet based on date, excel master sheet template, excel get data from another sheet based on cell value, how to extract data from excel based on criteria, contact details companies fax number 2008, details companies, web product data extraction, data extraction using regex, getafreelancercom web data extraction softwares scripts, automated data extraction, automated web login data extraction, times directory data extraction, web data extraction visual basic code excel, online data extraction, mumbai data extraction reading reports, web data extraction tools

About the Employer:
( 0 reviews ) Warrington, United Kingdom

Project ID: #17811897

53 freelancers are bidding on average £350 for this job

Innovative116

Hi there. I am a full time web researcher. Compiling database of Public Sector contracts awarded by the Government will be done with 100% accuracy. I have years of experience and have my own ways to compile database in More

£250 GBP in 2 days
(359 Reviews)
8.3
jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

£555 GBP in 3 days
(635 Reviews)
8.3
Joshua777

Hi, I am able to extract the data from the master spreadsheet to separate spreadsheet according to your requirements. Could you provide master spreadsheet ?I am ready to do few samples if you would like to do. Ki More

£500 GBP in 7 days
(595 Reviews)
8.3
rinsadsl

Hi there I read through the details of your project. I can build a tool to extract data from a master data spreadsheet located somewhere and produce a report by consolidating the data the way you wanted. The rep More

£300 GBP in 7 days
(544 Reviews)
8.4
jhliuster

Hi sir, I'm professional web data extractor, I can scrape data by a script and save the data into an excel file or csv file, wait for your reply, I can start work now. Regards Jianhua.

£300 GBP in 5 days
(509 Reviews)
8.1
seaanddream

Hi, my name is Selim. I read your "Data Extraction from master spreadsheet" project descriptions carefully before bidding. I checked your requirements as well... I got what you need and ready to go ahead as soon as w More

£250 GBP in 5 days
(342 Reviews)
7.9
helmot

Hi I have +10 years of experience in python programming. I can easily extract data from any spreadsheet and return the reports which you need. I’ve done tens of projects like yours. Please let me check your spreads More

£250 GBP in 7 days
(172 Reviews)
8.0
mirniyazuddin92

Hi there, I can extract data from a master data spreadsheet PM me to discuss further. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

£250 GBP in 10 days
(364 Reviews)
7.8
schoudhary1553

Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years o More

£400 GBP in 10 days
(302 Reviews)
7.7
Dhruvika111

Greetings, Data regarding the same is available on companyhouse website so you want us to collect the data from that website or would you share the resource website. We have various best scraping tools available to Ex More

£250 GBP in 3 days
(373 Reviews)
7.7
zekovicm

Hi there,I am Miljan,Web Scraping expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within More

£356 GBP in 10 days
(115 Reviews)
7.1
paris2785

Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to extra data from your Excel workbook to a separate shee. I'm going to develop an Excel app More

£250 GBP in 3 days
(163 Reviews)
6.8
Attractionnet

Hello. I am a vb.net programmer with specialization in creating custom program for data handling. I will create a program which will read the data and reorganize them the way you want, doing calculations etc. You can h More

£250 GBP in 3 days
(195 Reviews)
6.7
devi222

Hi sir, It’s not a big deal to create a spreadsheet like the way you asked. Please provide the data file, so I can create the spreadsheet as you asked in 1 day

£400 GBP in 3 days
(197 Reviews)
6.9
danielgpratidya

Hi, I have more than 15 years experience working on excel spreadsheet. I also can write vba automation and create the tool to do the data extract. Feel free to check my profile page. Send me the master spreadsh More

£250 GBP in 3 days
(193 Reviews)
6.6
kolosibalint

Hi, If you have a master spreadsheet that contains the data, it seems that all you need is building pivot (and maybe some charts) that sum up the count/value of contracts by companies and by authorities. To be ho More

£250 GBP in 3 days
(105 Reviews)
6.5
seoguru17

I can help you in extracting data or developing a tool for extraction. I would like to understand more what needs to be scrapped.

£555 GBP in 10 days
(85 Reviews)
6.3
nagybatonyi

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. I plan to complete the project via writing an Excel macr More

£250 GBP in 1 day
(62 Reviews)
5.7
shinelancer

how are you? I have read your description carefully. I am a data process and software expert and have rich experience for such project. If you want, we can get good results each other. You give me detail of project More

£400 GBP in 5 days
(29 Reviews)
5.6
mariusalex86

Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable freelancer, focused on quality and accuracy. Kindly consider my proposal. Thank you.

£250 GBP in 4 days
(74 Reviews)
5.6