It's a huge file though - almost 13000 lines for my server but as we're not going to wade through it manually that's not really a problem. This data file only needs to be downloaded each time you want to update your spreadsheets with a limit of 10 times per 24 hour period. The great thing about it though is that you can use the same file for all your WoW related spreadsheets. I have most of my spreadsheets in one file, each one on a different tab or sheet & I just copy/paste the fresh data file over the old one in the relevant tab. This will then update all my sheets at the same time.
OK, so enough chit chat, how do you get to this file? Go to The Undermine Journal for your region & login. If you don't have a TUJ account yet, just follow the instructions on the site (I linked it to my Twitter account for easy access). Once you have your account set up, you should log in & it will take you to your account page - look for the 'Market Data XML & CSV' & choose your realm from the drop down box. It will give you two URL options & a IQY link. Just copy/paste the .csv link into a browser window & it should download the file automatically for you.
Next you will need to open the file in a spreadsheet program of your choice. If you are given options, this file is comma separated so choose that option & it should open nicely laid out, with columns already set up similar to the screenshot below.
|Sample .csv File from TUJ|
I hope this helps - I know there are one or two readers who will love this & probably race ahead & sort out some glorious spreadsheets for themselves but for those of you who haven't used spreadsheets before, bear with me & we'll get you some nice sheets to use.
Image © pjohnkeane under Creative Commons licence