# Any guides on how to use ESI in ms Excel **URL:** \ **Category:** Science & Industry\ **Created:** [April 10, 2018, 2:58pm UTC](https://forums.eveonline.com/t/any-guides-on-how-to-use-esi-in-ms-excel/68906 "2018-04-10T14:58:49Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![olan2005](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/olan2005/32/101674_2.png) [@olan2005](https://forums.eveonline.com/u/olan2005)\ **Post date:** [April 10, 2018, 2:58pm UTC](https://forums.eveonline.com/t/any-guides-on-how-to-use-esi-in-ms-excel/68906/1 "2018-04-10T14:58:50Z")
Currently i import Jita mineral Prices to work out build costs using data query in excel. To my understanding that is soon dis-appearing in favor of esi which i have no idea how to use. Any help with guides and how to use this to replace the import data function would be greatly appreciated ---
**Author:** ![Oriella\_Trikassi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/oriella_trikassi/32/376749_2.png) [@Oriella\_Trikassi](https://forums.eveonline.com/u/Oriella_Trikassi)\ **Post date:** [April 10, 2018, 4:01pm UTC](https://forums.eveonline.com/t/any-guides-on-how-to-use-esi-in-ms-excel/68906/2 "2018-04-10T16:01:59Z")
Jita prices will still be available from third-party sources as they are now. CCP doesn’t actually publish regional prices except on the in-game Market screen. For private data this should be the page you are looking for: [https://wiki.zansha.space/index.php/SSO\_Authentication\_in\_Microsoft\_Power\_Query](https://wiki.zansha.space/index.php/SSO_Authentication_in_Microsoft_Power_Query) Power Query was an add-on to Excel that is built in to Excel 2016. I’d suggest trying it out on one of the public info ESI endpoints such as Prices first. I’ve got that working fine. It’s more flexible than the old XML downloading but has its own way of doing stuff. Yes, it looks complicated. ---
**Author:** ![Steve\_Ronuken](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/steve_ronuken/32/373894_2.png) [@Steve\_Ronuken](https://forums.eveonline.com/u/Steve_Ronuken)\ **Post date:** [April 10, 2018, 5:57pm UTC](https://forums.eveonline.com/t/any-guides-on-how-to-use-esi-in-ms-excel/68906/3 "2018-04-10T17:57:09Z")
[https://market.fuzzwork.co.uk/api/](https://market.fuzzwork.co.uk/api/) covers how to import prices from my site, using powerquery 😃 All up ESI is somewhat harder to do. The link above covers it. Harder, but possible. (I’m just waiting to get python support built into Excel. It’s requested, but I don’t know how seriously it’s being looked at) ---
**Author:** ![Oriella\_Trikassi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/oriella_trikassi/32/376749_2.png) [@Oriella\_Trikassi](https://forums.eveonline.com/u/Oriella_Trikassi)\ **Post date:** [May 7, 2018, 11:17am UTC](https://forums.eveonline.com/t/any-guides-on-how-to-use-esi-in-ms-excel/68906/4 "2018-05-07T11:17:26Z")
Using the above Guide I registered with CCP and got Postman working. However the script in Excel generates an Error. Help! DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously. Details: DataSourceKind=Web DataSourcePath=https://login.eveonline.com/oauth/token ---
**Author:** ![system1](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system1](https://forums.eveonline.com/u/system1)\ **Post date:** [August 5, 2018, 12:24pm UTC](https://forums.eveonline.com/t/any-guides-on-how-to-use-esi-in-ms-excel/68906/6 "2018-08-05T12:24:44Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.