I am using Acrobat DC Pro version 2021.001.20142. I have a PDF file which I am trying to export to Excel. When I run the process, the Excel file is missing 90 percent of the data. The header info is there but all the lines are missing information. I've tried this on several computers running the same version of Acrobat
If I take the same file to another computer which is running Acrobat Pro DC version 2015.006.30527, the file converts properly and I see all data.
All computers running Windows 10.
There are limited options in export settings. Both Adobe versions match the settings.
In general, exporting a PDF file to antoher format is one of the most complex tasks you can do with a PDF file, and the results depend highly on how the file was generated. If you started out with an Excel document, and used Adobe's tools to convert to PDF, and then try to export from that PDF again, you will usually see the best results. For other documents, Acrobat needs to analyze the structure of the data, and that's where things can go seriously wrong. Just because it's obvious to human eyes what should belong together, and where rows and columns are, that does not mean that a computer program will make the same decisioins as we do. It is possible that the change in behavior between the 2015 and 2021 version is due to an attempt to make other cases be handled better and your case just is an outlier.
What I usually do when I end up with a bad result is to export the PDF page as a high resolution image (e.g. a 600dpi TIFF image), and then I import that image back into Acrobat and run OCR, and then I try to export again to MS Word or Excel, and oftentimes I get better results. There is also a dedicated free application that allows for a better data extraction than what Acrobat does: https://tabula.technology (but it's also a bit harder to use than Acrobat's one click approach)