DataCollector for iPad
Tips & Tricks

Xml Data Exchange with Excel 2010

1) Export the file from the DataCollector App by pressing "Mail" and select "Export As Xml DataSet with Schema (*.xml)"

2) Import the xml file in Excel and press "As an Xml table"



3) You can now edit the data. When you update the xml from the iPad just reimport in Excel and only the xml data is updated. The rest of your Excel sheet is preserved! Cool!



4) To activate the Xml options in Excel activate and select the "Developer" Ribbon