How to Add an XML Map to an Excel Spreadsheet

104 39
    • 1). Launch Microsoft Excel and open the spreadsheet to which you want to add the XML map.

    • 2). In Excel 2003, click the "Data" tab and put the cursor over "XML." On the drop-down, select "XML Source." In Excel 2007, click "Data," then click "From Other Sources" in the drop-down, then click "From XML Data Import."

    • 3). Click on the "XML Maps" button and then click "Add."

    • 4). Locate the XML schema you want to map to the spreadsheet and then click "Open."

    • 5). Click "OK" to map the XML schema to the spreadsheet.

Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time

Leave A Reply

Your email address will not be published.