I have thought about this issue, having been sent many scripts by playwrights in pdf format because they used final draft or another program not commonly used, or the pdf was created to preserve pagination cross-platform. I recently did purchase a Mac program called Solid PDF to Word (also works on Excel), that seems to retain all formatting, including headers and footers, in the conversion from pdf to either Word or Excel, a bit miraculous and well worth the money if it's something you need more than a couple of times. It's certainly worth a look.
Julie