Is there a good guide on how to extract data from EVE?

You can only do that via Copy/Paste from ingame Assets Window or use the external API known as ESI (EVE Swagger Interface). In specific to Google spreadsheets you have GESI, which is an add-on created by Blacksmoke16 and you can find his forum thread here

Blacksmoke16’s Github page contains instructions for installation, so if you follow those you should be good to begin.

1 Like