How to open XML files in Excel

Hi All,

   Here is another article on testing and working with XML files. There is a growing demand for testing XMl files as most of the companies get there data in XML format and also send data in XML format. 

  I was testing xml files in one of my projects and wanted to convert the xml data into xls and found this very useful tool called XMLtoXLS. You can download this application from http://www.forgram.com/. Its a freeware and very useful to convert the xml data to xls. 

  Once the data is converted XLS you can  use the data for automation and convert it back to XML if you want to prepare  some test data. I will write a seperate article on how to convert a xls data to xml using excel macros. Its no rocket science and you should be able to learn it no time.

Happy Testing

Pavandeep Puddupakkam

 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 3/31/2009 at 9:56 AM
Tags: , , , ,
Categories: Software Testing
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (27) | Post RSSRSS comment feed

Comments

Add comment


 

  Country flag

biuquote
  • Comment
  • Preview
Loading