Importing/Exporting XML into Excel?

from GalCiv3 Forums

Is there a quick way to import and export xml data with excel?

I would like to be able to tweak ship components via  spreadsheet rather than manually cutting/pasting with notepad++. 

Worse case just importing into excel would at least making data easier to view. When I try now, by default it's staggering the various tags thru the spreadsheet columns and rows instead of one column for each tag. File in link below is a spreadsheet file to see what I'm mentioning.

http://s000.tinyupload.com/index.php?file_id=48728865585245227680

4,168 views 1 replies
Reply #1 from GalCiv3 Forums Top

Excel, or at least Excel 2007 and later, has an option to import data from XML built into it. I don't know how well it'll work with the game's XML files, but you can try it. Check the Data tab on the tool bar or Import Data.