Closed

Excel Database the extracts data from a website using a live lookup

Please read carefully and follow the steps outlined below as it will assist your understanding of my needs.

On the following website: [url removed, login to view]

There is a search form “Search Asic Registers”.

Within this there is a drop down box which allows you to search “Business Names Index” by name or number (ABN/Australian Business Number). I am only interested in the search by number option.

For this demonstration, please enter the following number: 68756994762 (not my company) and conduct a search.

You will see it takes you to a page with a lot of information about the business.

I require a an excel spreadsheet that can use a column list of ABNs (Australian Business Numbers) and conduct a live lookup to extract the data from the above website and populate it back into the spreadsheet.

The lookup will need to be able to handle up to 100000 numbers at a time as I will be conducting this look up once per month.

The data it needs to populate back is the following

1. Business name:

2. Status:

3. Registration date:

4. Address for service of documents:

5. Principal place of business:

6. Holder(s) details:

7. Holder Name:

I would like this data returned in the columns that correspond with the ABN that has been looked up.

If you can do this, then please contact me and quote a price. I will pay in full when testing is complete and you have delivered the full specification of this project, not just part of the project.

If this project is within your expertise, please contact me and include the name of the business that was found in the earlier search so I know you have read the project in detail. Submissions that do not include this will not be considered.

Thank you.

If you are having difficulties conducting the search, please try this link: https://connectonline.asic.gov.au/RegistrySearch/faces/landing/bn/SearchBnRegisters.jspx?_adf.ctrl-state=xbqxfywv4_22

Skills: Data Mining, Database Development, Database Programming, Excel

See more: which company needs a website, search for a website by name, search for an australian business website, excel spreadsheet of company names and contact numbers, excel spreadsheet expertise, excel spreadsheet business, excel specification, excel form to enter data, LOOkup, following number, extracts, excel database the extracts data from a website using a live lookup 2, enter data from website to spreadsheet, list company names contact details, drop list database, live data website excel, populate excel spreadsheet spreadsheet, australian search website, live excel data, page 100000

About the Employer:
( 1 review ) Petrie, Australia

Project ID: #7566204

38 freelancers are bidding on average $757 for this job

hossionsumon

Dear sir, Experts and top data entry service provider here ready to start work now .My success always measure with client's satisfaction. So, i always try to do the best. Please let me know if you have any questions. More

$394 AUD in 5 days
(193 Reviews)
6.7
sy3d

Advanced Solutions Group 4 hi, hru, please check my profile, i've no incomplete project and no bad wording for my work according to your requirement, i prepared sample, please check it 1. Business name: Advanced Sol More

$1100 AUD in 3 days
(188 Reviews)
6.7
dpune

Search result is "Advanced Solutions Group 4" Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by More

$500 AUD in 10 days
(60 Reviews)
5.7
aarifakhtar

"Advanced Solutions Group 4" Hi: I can implement a VBA macro in Excel to achieve this task. Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90 More

$375 AUD in 5 days
(54 Reviews)
5.6
facebooklikes007

Data Entry Sample work --- [login to view URL] Dear Buyer Greeting from Dream Media Solutions. Thank you very much for giving us an opportunity to bid for your More

$450 AUD in 3 days
(64 Reviews)
5.8
cugamelover

I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see the reviews on my profile for ALL skills. It would be my pleasure to do your project. Please have a look at More

$900 AUD in 8 days
(25 Reviews)
5.5
elqueabandona

Advanced Solutions Group 4 Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and models. Check my reviews. They speak for them More

$1000 AUD in 10 days
(46 Reviews)
5.3
P0L

Hello! I'm an Excel expert and I would like to help you with your project. I worked on similar projects before, using VBA code to scrape data from web pages to Excel. Please check my profile and contact me to discuss f More

$1000 AUD in 7 days
(48 Reviews)
5.3
talhamunir2002

sure we have checked the website its a java scrpit website so we have to made a scrpit that will take codes from csv file then it will return data into excel sheet sure we have checked the website its a java scrpit More

$1052 AUD in 5 days
(143 Reviews)
5.7
PigtailXL

Hello Sr., how are you ? First I invite you to watch my Portfolio to know my reputation here. Then, please, get this image: [login to view URL] It's just a capture of the More

$555 AUD in 10 days
(29 Reviews)
5.3
srinichal

Looking forward to discuss further about the project details and deliver the same to your needs .

$776 AUD in 3 days
(15 Reviews)
5.2
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready More

$766 AUD in 4 days
(44 Reviews)
5.6
phpXpertbd

Dear Sir, I'm very much delighted to let you know that i did data scraping with PHP-cURL, Node.js, Selenium from many sites. I just scraped the data from web site and then wrote the data in mysql database or excel o More

$819 AUD in 3 days
(18 Reviews)
5.3
SoftwareEng8876

Hi, I'll be happy to help you with this project. I take pride in accuracy, timely completion and support within reasonable time after completion. Please feel free to message me if you need to discuss any questions

$526 AUD in 4 days
(27 Reviews)
4.9
mkhrsunil

Hi, I'm web scraper developer and understood your requirements Please PM me to send sample data search before you award this project Below is the business name which found by ABN provided by you Business n More

$388 AUD in 3 days
(11 Reviews)
4.8
hwanghendra

Hi I searched the given number, but it says not found ? Please advise .................................

$842 AUD in 10 days
(18 Reviews)
4.5
level20peon

Advanced Solutions Group 4 - Hello, I am a professional with vast experience in webscraping. I would use a non-excel script in order to pull that data but I having sais script export the data back to excel would not po More

$786 AUD in 5 days
(2 Reviews)
4.2
editchamp

Hi I have read your job description ... I have expertise in this field. I did several job perfectly like this one . I can fulfill your requirement . High quality work goes cheap . I assure 100% satis More

$1055 AUD in 20 days
(68 Reviews)
4.6
prabakarm23

Greetings for the Day!!! The Name of the Business for the Example : Advanced Solutions Group 4 I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Int More

$500 AUD in 2 days
(24 Reviews)
4.0
kng229

I am a professional data analyst and researcher for the University of California, Berkeley. I would complete the tasks quickly and accurately, and provide you with excellent documentation and results at the end of the More

$750 AUD in 10 days
(3 Reviews)
3.7