• 2 Vote(s) - 1 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to use an existing CSV file to add bookmarks to a PDF
Many PDF readers support clickable bookmarks. This is very helpful to navigate to a certain song when you use a PDF fakebook outside MSP.


If you already have a CSV file for a certain PDF file you can easily use it as input to add bookmarks to the PDF.

Before you start
- make sure that the required programs are available
  LibreOffice Calc is used to prepare the bookmarks file
  jPDFBookmarks is used to add the bookmarks list to the PDF
  both are available for free and should be usable on various platforms
  I did the following on Win10
- make backup copies of the CSV file and PDF file (just in case)

Convert the CSV file to a bookmarks file
- open the CSV file with LibreOffice Calc
  select the correct encoding and separator
- delete all columns except TITLE and PAGES  
- delete the column header line
- delete other unnecessary lines if required
  (e.g. CSV files that were posted by me often contain a line that refers to the complete book)
- edit PAGES of multi page songs so that only the start page remains
  e.g. edit "9-11" or "9,10,11" to "9"
- sort the lines by PAGES or by TITLE as you like to see the bookmarks in the resulting PDF
- save the edited file as "bookmarks file"
  File > Save As... (Datei > Speichern unter ...)
  choose "File Type" (Dateityp) "CSV"
  uncheck "Automatic file name extension" (Automatische Dateiendung)
  check "Edit filter settings" (Filtereinstellungen bearbeiten)
  specify the filename for the bookmarks file, use .txt as file extension
- as soon as you click "Save" (Speichern), the window "Export Text File" (Textdatei exportieren) opens
  select "Character set:" (Zeichensatz) "Western Europe (ISO-8859-1)" (Westeuropäisch (ISO-8859-1))
  set "Field delimiter:" (Feldtrenner) to "/" (without the quotes)
  click OK
Create bookmarks with jPDFBookmarks
- open the PDF with
  File > Open ...
- open the bookmarks file created as above with
  Tools > Load
- save PDF with bookmarks with
  File > Save as ...
  choose a new name, e.g. add -bookmark to the original filename
- check the result
  I used the default settings of jPDFBookmarks for a minimalistic approach.
  Clicking a bookmark jumps to the top of the given page and scales that page to the width of the current window.
  You might have to scroll down to find the song you are looking for.
I used "Kinder wollen singen" as an example to find out how bookmarks can be created easily.
See https://www.zubersoft.com/mobilesheets/f...&pid=24797
You can find a sample bookmarks file there

Attached Files Thumbnail(s)
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Messages In This Thread
How to use an existing CSV file to add bookmarks to a PDF - by itsme - 03-24-2019, 06:47 PM

Users browsing this thread:
1 Guest(s)

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.