Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

XML fields importing in separate rows in Excel

Avatar

Level 1

When importing the *.xml files from a returned form into Excel 2010, the fields correctly populate into columns, but each field also gets a separate row. It seems the xml is specifying a 'new row' for each field, when it isn't required. This creates a diagonal display of information (headers along row 1, info in A2, B3, C4, D5...)

When I import multiple *.xml, i get multiple diagonal displays, which look pretty, but aren't very functional.

Any ideas on how to get this to display correctly?

Thanks

0 Replies