EVE Technology Lab

Ok, let me start by saying I am somewhat inexperienced with a lot of what I'm doing but am teaching myself as I go.

I found where I can find a up to date list of station IDs System IDs, etc from fuzzwork.co.uk

However my question instead of opening those files and pasting them into another spreadsheet is it possible for the spreadsheet to automatically get those tables and import them

I'm trying to make my spreadsheet as up to date as possible and if there is a way to automate this then if CCP adds say a module or if they add a batch of space someday it would all automatically update in my spreadsheet so it would be accessable


Thanks.

If you're willing to do a one time import of excel on each release (about every six weeks), then this is pretty easy to do:

1) import Steve's latest sheets into your Google sheet (use File -> Import)
2) use either VLOOKUP or QUERY to look up entries from the sheet you imported

If you just need to map type ID to type name, then you can use Steve's type URLs (see post above). From Google sheets, you'll either need to use IMPORTXML to call Steve's endpoint, or you'll have to write a small bit of Google App Script code. It's recommended to write the code if you can as IMPORTXML can be unreliable.

If you truly want a live version of the SDE and you don't want to set up your own DB, then you can use the EveKit GAS library but that will require a bit of minor coding. If you want to go that route, check out this, and you can also browse the SDE API calls here. I can help if you decide to go this route (I run EveKit).