DataCollector for iPad
Tips & Tricks

Home Screenshots Downloads Tips&Tricks Whats NewNew

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


(C) 2013 by sbr/Simplexity