Export Footers

[Trina_Chambard]

Hi. I know there is a way to export all my footers, because I've done it before, but I can't remember how. Does anyone know?

[Thom Parker]

Do you mean export the Header/Footer Settings? or the actual footer?

[Guest]

I have the same question.

Have used all three left, right, and middle sections of the footer to create indexes for each page and want to export those three columns into excel for use in excel.

How can this be done.  Don't need the pdf pages themselves, just the footer information from each page (left, middle, right).

?

[try67]

Use the Save Settings command in the Add Header & Footer dialog and then you'll be able to copy the file it is saved to from your computer (or account) to another one.

The exact location depends on your OS and version of Acrobat.

On Windows it would be something like this:

C:\Users\<USER NAME>\AppData\Roaming\Adobe\Acrobat\<VERSION NUMBER>\Preferences\HeaderFooter

It's an XML file with the name you've selected when you saved it.

[Guest]

Thank you that information about where the "settings" are saved; that was a helpful future reference. I think my question was unclear. I am looking to export the actual (not the setting) footer information only and not the context.

Example:

Page 1 footer (left = "Page 1", middle = "LAB_2", right = "Geo5")

Page 2 footer (left = "Page 2", middle = "LAB_2", right = "Geo5")

Page 3 footer (left = "Page 3", middle = "LAB_3", right = "Geo5")

Page 4 footer (left = "Page 4", middle = "LAB_3", right = "Geo5")

Page 5 footer (left = "Page 5", middle = "LAB_3", right = "Geo8")

I want to export the actual footer data only (NOT THE page contents) to an excel or CSV file so I can then use excel analytics on the footer information:

So in the resulting export to excel --->

Excel Cell (R1,C1) = "Page 1"; Excel Cell (R1,C2) = "LAB_2"; Excel Cell (R1, C3) = "Geo5")

Excel Cell (R2,C1) = "Page 2"; Excel Cell (R2,C2) = "LAB_2"; Excel Cell (R2, C3) = "Geo5")

...

and so forth.

Is there a way to do that?

[try67]

Ah, I see what you mean... That should be possible, but it would require the development of a custom-made script, and it might not work if the file is very long or have a lot of words on each page.

If you're interested I'm happy to look at a sample file and let you know if I think it would work, and if so how much it will cost to develop such a script. You can contact me privately via [try6767 at gmail.com] to discuss it further. If a script won't work then another option is to do it using a stand-alone tool, which is also something I can create for you.

[Guest]

Ok, again, thank you for the information.

The files are indeed VERY long with lots of words sometimes extending down into the footer area. 😞

[try67]

Then it will be very tricky to extract the footer text from the rest of the text. Maybe based on its structure...

[Thom Parker]

Do you know if these footers were created with the footer tool in Acrobat?