How do I view XML backup in Excel 2007

1. When logged into Paper Tiger Online, click on the Database from the Dashboard that you want to export.

While inside the database you want to export - click the Database Preference tab located to the top, right of the screen

capture1.PNG

2. Export the Database as an XML File

On the pop-up box that appears, click the link at the bottom of the box to "Export Database as an XML File". Select a location to save the XML file and Save it. (The default location is usually the Downloads Folder)

capture2.PNG

3. Open Excel

On the Menu bar, select the Data View

capture3.PNG

4. Import Data

From the "Get External Data" section, select the "From Other Sources" option, then select "From XML Data Import" from the drop down list

capture4.png

5. Select the XML File

Navigate to the directory where you saved the XML file and select it

capture5.png

6. Select the Cell where you want the Data to Start

This determines where the data will begin on the worksheet. In the image below, the data will begin in the first column and the first row (First cell A1)

capture6.png

7. The data after it has been imported (Includes all other columns to the right)

Screenshot.png

Another screen shot of the Excel file after resizing the columns:

xml_to_xls_2007.png


Can't find the right answer?

  • Contact our support team and we will personally get back to you as fast as we can.