Importing from PDF

**Sibrulotte** · 09-22-2011, 10:18 AM

Hi,
I have an invoice of 46 pages I'd like to analyse. Supplyer can't provide anything else than a PDF file.

When I select all, copy and paste to excel, colomns are not one next to another, but rather one on top of the other...
So I see everything in colomn A:
Page 1, random hotel coordinates
Page 1, colomn with date
Page 1, colomn with description
Page 1, colomn with further description that are on 2 lines...
Page 1, colomn with amounts

Repeat for 46 peges, all in colomn A.

I've tried exporting it to .txt, but there is no delimitation that a text to colomn function can work with realy...

Does anyone know how I could extract this to excel without copying page by page (cause that actually works fine, but I have to go colomn by colomn)...

**Domski** · 09-22-2011, 11:10 AM

Supplyer can't provide anything else than a PDF file.

They must create it from something and how do they do their own analysis of sales? I'd ask them again as extracting data from pdf's can be a right pain in the backside.

Dom