Automatically extract data from website to Excel sheet

jayendrajpatel

Estimable
Sep 29, 2014
2
0
4,510
0
Actually I don't know that whatever I am going to ask is possible or not.

Actually I want to do result analysis of a class which includes Result of all student as wells as subject wise grades, topper of class etc etc.....

Now there are so many students ( average 60 students per class & total 12 classes)

Results are available online over the website of university. You can check website by following the link given below:
http://result2.gtu.ac.in//Default.aspx?ext=s2015&rof=935
Page looks like this




I just want to get these online reults on my excel sheet in organised manner so that I can Do my analysis easily.
Currently I am typing all this. & my excel sheet is like this

Now is there any easy way so that I can do result analysis easily. without typing or copy paste them.
OR say any way to link this page directly to excel or google sheets.

If there is any other suggestion then also welcome....
 

ss202sl

Honorable
May 23, 2012
758
0
11,960
109
Have you asked the University about this? They probably already have all the information in a spreadsheet(or DB). All you need is access to that data, and then it's easy to import into a excel file.
 
Thread starter Similar threads Forum Replies Date
L Apps General Discussion 3
M Apps General Discussion 5
S Apps General Discussion 3
I Apps General Discussion 2
R Apps General Discussion 1
geofelt Apps General Discussion 3
K Apps General Discussion 1
H Apps General Discussion 2
A Apps General Discussion 4
S Apps General Discussion 4
B Apps General Discussion 2
D Apps General Discussion 1
anoori9000 Apps General Discussion 1
LEOKAMBOJ Apps General Discussion 2
A Apps General Discussion 3
G Apps General Discussion 1
G Apps General Discussion 2
M Apps General Discussion 1
tarmiricmi Apps General Discussion 4
Z Apps General Discussion 1

ASK THE COMMUNITY