I need automated way to import data from website to excel

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Other - Accounting & Consulting Posted 3 years ago


Hours to be determined
3 to 6 months


My name is David and I work as a computer support technician, to support my clients I use AMMYY Admin (www.ammyy.com).
as full payed license in ammyy I get access to logs that shows me the clients ID I contacted, the time and date I started the connection and the duration that I was connected to them.
I would like to create an excel document that will be able to go to the ammyy admin report sites of my connection (require user and password) and then take all the data into excel into a table.
in another tab in the same excel I would like to create a table that identifies the customer ID with the name of the customer and when the routine imports the data from the site I would like it to show not only the customer ID but the name of the customer and the name of the company.

at the moment I already have something like that that works but at the moment I have 2 problems with it:
1.  I can't get the data directly from the website, I need to export the html file and then get the data into the excel.
2. because of upgrading from excel 2010 to excel 2013 some of the functions stopped working in my excel.

attached are screenshots of what I have and need.

is this something that you know how to do? can you estimate the time frame for the work (how much billable hours should it be)?

Skills: import

About the Client

(5.00) 2 reviews

Ness Zionna 11:11 AM

3 Jobs Posted
100% Hire Rate, 1 Open Job

$182 Total Spent
4 Hires, 0 Active

Member Since Jan 18, 2013