• 1 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
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 2004
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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

Users browsing this thread:
1 Guest(s)

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