Overview
Export Bookmarks to Excel writes the bookmark tree of the active PDF to a SpreadsheetML workbook that Excel opens natively. The PDF itself is not changed.
How to use
- Open a PDF that contains bookmarks.
- Go to Plug-Ins > Bookmarks > Views & Reports > Export Bookmarks to Excel.
- In the Save dialog, choose a file name and location for the
.xmlfile. - Click Save to export.
Output format
The worksheet is named Bookmarks and has three columns: Level (1 for a top-level bookmark, 2 for its children, and so on), Title and Destination. The header row is styled so it stands out when the file opens.
The format is SpreadsheetML — XML that Excel reads directly. Excel may warn that the file extension does not match the format; that warning is expected and the file is safe to open.
| Element | Description |
|---|---|
| Title | The full text of the bookmark title, escaped so that characters such as
& and < survive intact. |
| Destination | For page destinations the page number is written as Page N. For URI
actions the URL is written, for Launch actions the file path. Anything else is
written as Action: <type>, and a bookmark with no usable action
as Action: Unknown. |
Note
Level is a real number in its own column, so the sheet can be sorted and filtered by depth. Every bookmark is exported regardless of level.