MS Excel Highscore Look-Up

[sam10187]

Is there any way to get Excel to look up my RuneScape Highscores, including the exp? I've been trying to make a goal calculator on Excel, but I don't know any way to get Excel to look-up my Highscores. Obviously I could enter the exp manually, but if there's an easier way, I'd definitely prefer it. It's probably worth adding that I have no coding experience.

 

 

 

Thanks in advance,

 

 

 

Sam

[kelerps]

Go to data > import external data > new web query

 

 

 

A window should popup, paste this address in http://hiscore.runescape.com/index_lite.ws?player=

 

This should lead you to a text only page with a bunch of number separated by commas.

 

Click the yellow and black arrow on the top left of the browser window and then click import.

 

Your should now be in excel with the import data dialog box open. Click the properties button at the bottom of the dialog box. Here you can change your refresh option to your choice. Press ok. Then select the radio box that says put data in new worksheet. This will allow it to be out of the way for when you create your document.

 

The data should be in the format rank,level,experience and if there is no data there will be a -1. It should be in the same order as the usual high scores.

 

Select the data range and rename it hiscores so you just refer to it as a name.

 

Now you will need to format your data to easily be used by other functions. If you go to insert function there will be lookup and reference formulas witch you theoretically will be able to use for that. If you cannot accomplish this then the VBA editor(alt +F 11) could be used.