holmen
"Ung" og "lovende"
Har du importert data fra pdf til Excel? Eller bare kopiert inn? Skal gå an å få inn data som tabell.Noen som har fått til å behandle den pdf-en man laster ned i excel eller annet regneark?
K
Extracting data from PDF to Excel
You can import a PDF file directly into Excel and extract tabular data from it:
Open an Excel sheet
Data tab > Get Data drop-down > From File > From PDF
Select your PDF file & click Import.
You'll now see a Navigator pane displaying the tables & pages in your PDF along with a preview.
Select a table & click Load. The table you selected will now be imported on to your Excel sheet.
This might work pretty well with simple tabular data. Complex tables or multi-page tables might throw up some formatting errors!
