Add data from web to an existing Excel spreadsheet
$30-250 USD
Pagado a la entrega
Hello,
To give some context, the purpose of this project is to constitute a list of companies to be contacted:
Please refer to attached excel spreadsheet: you would need to fill in the columns M, N, O, P, Q (in yellow) by:
1. Taking the company number in column L
2. Going to the web page: [url removed, login to view]
3. Entering that number in the 'company number' field under the 'annual accounts' box on the right, middle of that page
4. Click on 'search': a pop-up window will open and will display the name, address of the company and table with its accounts:
4.1 Verify it is the correct company
4.2 Copy the street and number in column M
5. In the table at the bottom, open the PDF in the FIRST row
6. On the first and second page of that PDF doc, you will have a list of names (on the left) and their title (on the right, in French):
6.1 When it shows 'Administrateur' >> put it in column N in the xls sheet
6.2 When it shows 'Administrateur Délégué' >> put it in column O
6.3 When it shows 'Gérant' >> put it in column P
When there are multiple 'Administrateur', 'Administrateur Délégué' or 'Gérant', put all the names in the same cell
7. Go to: [url removed, login to view] and type
7.1 In the 'I'm looking for' field, the name of the company (in column B in excel sheet)
7.2 In the 'in' field, the City (in column E in excel sheet)
>> Copy and paste the phone number in column Q
NOTE: there are hidden columns in the sheet, which you can use if necessary BUT do NOT erase any of the columns or information contained.
If you are keen on being selected for that assignment, send me with your bid a TEST file of the first FIVE companies completed, so I can review quality before awarding the project.
Thanks & Regards,
Cedric
Nº del proyecto: #1457334
Sobre el proyecto
Adjudicado a:
42 freelancers están ofertando un promedio de $77 por este trabajo
Good day im very interested to do this project please check Private Message for details. Thank you
Greetings! Thank you very much for giving us an opportunity to bid for your project. Please refer to PMB for our detailed bid.
letz start..I have done similar jobs before..so i can deliver this work within 4-5 days..just hire me and i'll start your work..Regards..Raj..!
I've completed many similar projects successfully. Well versed with Excel and fast data searching, extracting and inputting skills. Can start immediately. Details in Pm. Thank you.
I understand you need your spreadsheet filled out with accurate data. Per your request, I've included a sample along with my bid. Please check PMB for details. Thanks.