# Google Sheet price Import

**URL:** <https://forums.eveonline.com/t/google-sheet-price-import/8360>\
**Category:** Third Party Developers\
**Created:** [July 2, 2017, 9:56pm UTC](https://forums.eveonline.com/t/google-sheet-price-import/8360 "2017-07-02T21:56:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Korban\_Reed](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/korban_reed/32/301978_2.png) [@Korban\_Reed](https://forums.eveonline.com/u/Korban_Reed)\
**Post date:** [July 2, 2017, 9:56pm UTC](https://forums.eveonline.com/t/google-sheet-price-import/8360/1 "2017-07-02T21:56:39Z")

</div>

Hi All,

A while back I used to use the “ImportXML” in google sheets, to import prices from EvE central. Now it no longer working (a past update i believe).

> =IMPORTXML([http://api.eve-central.com/api/marketstat?typeid=34&regionlimit=10000002](http://api.eve-central.com/api/marketstat?typeid=34&regionlimit=10000002), “/eve/price”)

Could anyone suggest an easy way to import a couple of prices without having to use scripts and such, as to be honest that isn’t a skill of mine.

As you can see the above “importxml” was very easy to use.

Thanks.

---

<div class="post-metadata">

**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:** [July 2, 2017, 10:05pm UTC](https://forums.eveonline.com/t/google-sheet-price-import/8360/2 "2017-07-02T22:05:07Z")

</div>

importxml is easy to use, yes.

However, it’s not really going to get you any where these days.

However, you’re in luck.

> **[Google Sheets - Updating from a Menu - Fuzzwork Enterprises](https://www.fuzzwork.co.uk/2017/04/25/google-sheets-updating-menu/)**
>
> Something which has been a problem people have run into, is that google sheets have a problem with automatically updating figures from custom functions. You’ll often find functions which suggest having a useless reference to a cell which you can then...

Goes through how to get google sheets loading prices. And updating them on demand (kinda. It’s pulling from my site, which updates once every 30 minutes or so. just be careful around downtime, as that can cause issues.)

---

<div class="post-metadata">

**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\
**Post date:** [July 3, 2017, 4:04pm UTC](https://forums.eveonline.com/t/google-sheet-price-import/8360/3 "2017-07-03T16:04:14Z")

</div>

I’d check Nuadi’s script out. Should work better than the raw importXML from eve-central.

> **[nuadi/googlecrestscript](https://github.com/nuadi/googlecrestscript)**
>
> googlecrestscript - A Google Sheets script designed to contact the EVE Online CREST/ESI endpoints
