
![]() |
Generic index document linker.csv Size : 0.283 Kb Type : csv |
![]() |
Generic Pinpoint Builder.xlsx Size : 287.531 Kb Type : xlsx |


Below are some videos I have made to demonstrate:
- the preparation I do for a hearing using electronic bundles
- some of the steps for constructing an electronic casebook
- my method for bulk hyperlinking.
Below is a summary of what I do for bulk hyperlinking, but there are many other methods that would also work. All of this relates to the Senior Courts Civil Electronic Document Protocol, which requires documents to be named with a defined structure (ie 101.0001, 201.0001, with the first part being the volume and the numbers after the decimal representing a page number).
This site has an excellent stand-alone tool for hyperlinking documents in bulk using a spreadsheet, which is what I use: http://try67.blogspot.com/2012/03/acrobat-create-custom-links-from-text.html.
The table of contents can be hyperlinked by simply running the tool, filling in the path to the document you want to hyperlink, and then filling in the path to this generic csv file (which finds all matches for xx.xxxx or xxx.xxxx and links to a file with the corresponding name).
![]() |
Generic index document linker.csv Size : 0.283 Kb Type : csv |
The whole process is shown in this video:
For pinpoint hyperlinking, I have developed my own master template (see below), which is populated to list all the casebook pages, and has formulae to build the relevant hyperlink reference for each page. Once created, this spreadsheet can then be applied to hyperlink automatically any pdfs you may create in the case (the index, submissions, cross-examination notes, chronologies, key document diagrams etc).
I have demonstrated the process in a video here:
![]() |
Generic Pinpoint Builder.xlsx Size : 287.531 Kb Type : xlsx |
* If you need to copy the pre-filled formulae to more rows, then column C needs to be entered with <ctrl-shift-enter> (because it is an array).
Your master spreadsheet should look like this:
Cut and paste the data from Column A and G of the master spreadsheet into the second "list to use" sheet (use special paste, values). Make sure the docids are still 4 decimals places (custom format the columns if required). Copy this spreadsheet to a new book and save it as a csv file.
Your final hyperlinking csv file for executing in Gilad's app should look like this: