These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

Forum Index

EVE Forums » EVE Technology and Research Center » EVE Technology Lab » need help with importing data into excel

Topic is locked indefinitely.

need help with importing data into excel
Author

Previous Topic Next Topic

Strategic Exploration and Development Corp Silent Company 1
DeltaW7 Strategic Exploration and Development Corp Silent Company Likes received: 1	#1 - 2012-07-07 17:02:38 UTC Hi all I want to import prices from eve-central (or eve market) into excel. I know how to generate the eve-central query for specific items. This gives me a XML file. My question is how do I get the data from the xml file into excel

Fuzzwork Enterprises Vote Steve Ronuken for CSM 6,759
Steve Ronuken Fuzzwork Enterprises Vote Steve Ronuken for CSM Likes received: 6,759	#2 - 2012-07-07 19:38:51 UTC Try the 'import from web' option. (I'd give more detail, but I don't have a PC with a cooy of excel near me) Woo! CSM XI! Fuzzwork Enterprises Twitter: @fuzzysteve on Twitter

Louis Vitton

Viziam

Amarr Empire

Likes received: 88

#3 - 2012-07-08 06:25:25 UTC

Hey mate,

What version of excel are you using and here are some links may or may not help you further.
I dont use excel myself for xml i use google docs its just simple to edit and alter more then.

http://office.microsoft.com/en-us/excel-help/overview-of-xml-in-excel-HA010206396.aspx#BMimport
http://www.addictivetips.com/microsoft-office/excel-2010-working-with-xml-format/
http://msdn.microsoft.com/en-us/library/gg469857.aspx