Is there a way to convert the index (Bookmarks) of a PDF file to excel.

I need to convert only the index file of some .pdf files to excel. Is there a way to accomplish this. Below is a picture of the index of a file I would like to convert. I do not want all the data just the index.

Any advice or help would be great.

Thank you

Index.jpg

Hi 737mechanic and welcome to ExcelForum,

Very interesting question. Yes it can be done, but Excel needs a little help from a (NO COST) tool Named Pdf Toolkit (Excecutable file pdftk.exe). Pdftk.exe can extract the Bookmark information from the .pdf file (into a text file), and then Excel can process and format the Bookmark information in the text file.

See the attached zip file which contains two files:
a. ExcelForumExtractBookmarksUsingPdftk-2014-12-30-16-41.xls - Excel file that does all the work.
b. 2014_p54.pdf - A pdf file that contains Bookmark information at three levels.

Pdftk can be used at NO CHARGE under its GPL (GNU Public License) License.
Pdf ToolKit Download Site: https://www.pdflabs.com/tools/pdftk-server/
Pdftk license Page: https://www.pdflabs.com/docs/pdftk-license/

The automated Pdftk procedure:
a. Verifies that the 'Pdftk.exe' executable file exists.
b. Verifies that the 'Data Folder' and 'Data File' exist.
c. Gets the input options and verifies that the values are valid.
d. Creates and runs a .bat file to run 'pdftk.exe (and create output file Scratch00.txt).
e. Processes the text file that contains the Bookmarks (Scratch00.txt) and outputs results on 'Sheet2'.
f. Optionally deletes file 'Scratch00.bat'

INSTRUCTIONS:
a. Select a .pdf 'Data Folder and File Name Combination' to use as an Input File.
b. Select the Pdf Took Kit executable and path to the executable (e.g. c:\pdftk\pdftk.exe')
NOTE: Steps a. and b. CAN BE OMITTED if the values in cells 'C11' and 'C14' are CORRECT.
c. Select the 'First Bookmark Level' to Index (Optional).
d. Select the 'Last Bookmark Level' to Index (Optional).
e. Click the 'Run the Automated Pdftk procedure' COMMAND BUTTON.

NOTES:
1. The program may not work if the 'Data Folder' name is too long (unknown how many characters that is).
2. The program times out if Output file Scratch00.txt has not been completely created in 5 seconds.
3. The program uses scratch files 'Scratch00.bat' , 'Scratch00.txt' and 'Scratch01.txt' (in the same folder as this file).
4. Any file deleted by this program ('Scratch00.bat, Scratch00.txt, Scratch01.txt) goes to the recycle bin.
5. Pdf ToolKit Server file pdftk.exe is required. It is possible that file libiconv2.dll (included with pdftk.exe) may also have to be installed.
On my computer, I installed both files in folder C:\Windows\System32 (but the files can go in any folder).

I apologize for the size of the downloaded file. I should have chosen a smaller .pdf file. For those of you who want to supply their own .pdf file, download the .xls file only.

Lewis