Adobe Acrobat - copy table to other format

In Acrobat CC: File > Export To > Spreadsheet > Microsoft Excel Workbook

Can you upload a sample PDF for us to try with?

Sigurdur,

As I mentioned in my post, exporting as you describe does not work.

What version of Acrobat are you using? That might explain something.

Have you asked if you can get the data in CSV format instead?

The best way is to use software such as WonderShare pdfElement or Able2Extract

version is adobe Acrobat pro DC

Strange. I made me a pdf from your date, exported as pdf, tried to copy to excel and it failed. Then exported as I mentioned and that worked perfectly.

Do you not have the buttons in this place, or are they greyed out?
Do you have a chance to upload a demo file that fails for you?

Can you upload a sample PDF for us to try with?

Sigurdur: I suggested that 2 hours ago.  ID: 42160225 Always much easier to trouble shoot / resolve a problem if you have access to a sample file that's being worked on :)

Here is a sample of the table that I am trying to copy into a .txt file or excel. I do not need graphics, only table from Headings until end of table.

In this document, there are 3 rows and 11 columns.
Daily.pdf

Is this what you were after?  (See attached)

Steps taken to create:
1.  Opened Daily.pdf file in PDFelement Pro 6.1
2.  Clicked Edit
3.  Clicked File > Save as
4.  Select Save as type: Excel Files(*.xlsx)
5.  Done

If the result is as you expected, then there is either a configuration error in the Acrobat editor that you are using, or a limitation.

Please advise if the attached is the result you are trying to reproduce.
Daily.xlsx

The results that you show are as I am expecting.

I have Adobe Acrobat pro at my disposal. If I export the file as an .xls or .txt, I get the following as depicted in the attachments:
Daily.txt
Daily.xlsx

Thank you for your assistance and generous offer. I have daily reports that have to be converted, so passing them to you would not be efficient.

I do not mind purchasing another tool, but it is unfortunate that Acrobat itself cannot handle this issue correctly (or at least it is not very obvious).

No worries mbudman. Sorry the news isn't better. I've been trying different configuration options with my own copy of Adobe Pro and no joy so I'm fairly confident there's a bug of some sort.

PDFelements Professional 6.1 is an excellent product however and has other great features that you might enjoy, (OCR capabilities in particular) that I find outperform the genuine Adobe product when talking in terms of accuracy.  I've been testing it daily for about 3 weeks now.

Best..

Thank you for your assistance.

Mark

You're very welcome Mark. I'm glad I could help.

Andrew

Unfortunately, I did not pay proper attention; PDF Element did not convert correctly to Excel; The data does in the column is mixed up and no displayed the way it was in the original .pdf

Hmm.. Let me try that again. Back soon.

Still trying to nut out the .xlsx issue, but can you look at the attached and advise if that would be of help to you?

I'll be surprised if I can't find a solution to the XLSX problem though.. if I can't, it will be the first time this editor has let me down.
Daily.docx

I think I've identified the problem when converting the PDF to XLSX format.  

The conversion engine in PDFelements is failing to see each (right hand side) block of text as a single cell. This will be partly due to the quality of the PDF file it has to work with, but also partly because the conversion engine should be seeing those blocks of text and pasting them (spacing errors and all) into single cells in Excel.  

I'm currently testing this product at Wondershare's request for review and reselling purposes, so I've submitted a report to PDFelement Developer Support to see what feedback / suggestions they can offer about the problem.  Let me know if you would like me to message you after I get their feedback.

As I mentioned earlier, this is the first PDF > Excel conversion I've done with this software that's failed muster after about 3 weeks of testing.

The PDFelement Word conversion engine appears to be more accurate and is reproducing the PDF source file correctly, in that it's picking up the entire blocks of text correctly, though I don't know if a Microsoft Word conversion is going to be of any help to you?  In case it is helpful to achieving your end goal, here's the steps I took to produce the Daily.docx file. (Very similar to the Excel conversion)

1.  Opened Daily.pdf file in PDFelement Pro 6.1
2.  Clicked Edit
3.  Clicked File > Save as
4.  Select Save as type: Word Files (*.docx)
5.  Done

Regards..

The best way is to use software such as WonderShare pdfElement or Able2Extract

For the sake of completeness, I downloaded and installed the latest version of Able2Extract that expert Roy_Cox suggested as well, but it too converted with many conversion errors. PDFelement came close, but still not quite right. Currently waiting to hear back from Wondershare support.
Cheers..

Thanks!

Did Wondershare ever get back to you?

Yes, but only in so far as confirming the developers are looking into it. No resolution as yet though. They will contact me when they have an answer.

PDF to Excel is one of the editors main selling points, so I expect the issue to be pretty high on their list.  Will send you a message when I hear something back.

Best..

Thanks! Have a great weekend!

I wonder if the data was converted to a picture before saving as a pdf.