I need to convert PDF to Excel, however, columns and tabs make many merged cells and many blank columns. In addition to not separate the columns correctly, I see many not separate lines together in the same cell. I'm even thinking that Adobe Acrobat Pro D

New Here ,
Apr 24, 2015 Apr 24, 2015

Copy link to clipboard

Copied

I need to convert PDF to Excel, however, columns and tabs make many merged cells and many blank columns. In addition to not separate the columns correctly, I see many not separate lines together in the same cell. I'm even thinking that Adobe Acrobat Pro DC has limitations. There is no way to define what points in columns to force break column? Nor create many columns that are useless? How does text to column in Excel, fixed size when we import text, and define where the breaks have columns?

Google Tradutor para empresas:Google Toolkit de tradução para appsTradutor de sitesGlobal Market Finder

Desativar tradução instantâneaSobre o Google TradutorCelularComunidadePrivacidade e TermosAjudaEnviar feedback

TOPICS
Create PDFs

Views

45.6K

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

LEGEND , Apr 24, 2015 Apr 24, 2015

PDF does not contain columns, rows, formats, styles, or other aspects of word processing or spreadsheet file formats.

This is because PDF is decidedly not a word processing or spreadsheet file format or something "like" one of those.

(see ISO 32000 for what PDF "is")

What can optimize the export of PDF page content is to start with a well-formed tagged PDF (ISO 14289-1, PDF/UA-1 compliant).

Without that export is what it is and one performs whatever content cleanup is needed using the native applica

...

Likes

Translate

Translate
LEGEND ,
Apr 24, 2015 Apr 24, 2015

Copy link to clipboard

Copied

PDF does not contain columns, rows, formats, styles, or other aspects of word processing or spreadsheet file formats.

This is because PDF is decidedly not a word processing or spreadsheet file format or something "like" one of those.

(see ISO 32000 for what PDF "is")

What can optimize the export of PDF page content is to start with a well-formed tagged PDF (ISO 14289-1, PDF/UA-1 compliant).

Without that export is what it is and one performs whatever content cleanup is needed using the native application for the export file (MS Word or Excel).

Be well...

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 04, 2022 Mar 04, 2022

Copy link to clipboard

Copied

That makes no sense. We're want to take data in PDF and export them to an Excel file that  uses columns. The export function has to make some decisions about where the columns are located. Telling us that "it is what it is" is not helpful. A better engine is needed to correctly parse the PDF data into the correct colums. I have a PDF file with mulitple pages with excactly the same layout and some of them parse correctly to Excel columns and others do not. I'm writing this 7 years after the initial post, so this is still a problem.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 04, 2022 Mar 04, 2022

Copy link to clipboard

Copied

It's certainly possible to write your own algorithm to export the data in the desired format (using a script, plugin or stand-alone application), but it's not possible to change the way Acrobat does it.

If you try to do it yourself you'll see the complexity of such an endeavor and understand why it's not so simple to create such an algorithm that works with multiple layouts.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Mar 16, 2022 Mar 16, 2022

Copy link to clipboard

Copied

I agree with Anthony.  Adobe HAS changed the way the export to Excel over the years.  We still have users using Acrobat Pro 2017 and that version works as intended.  Instead of exporting one giant column with all the rows combined into one row of text (like the current version)... it will export each row in a table as its own row.

 

Adobe changed something and they need to change it back... what is the point of paying for this feature if it doesn't work.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Aug 25, 2022 Aug 25, 2022

Copy link to clipboard

Copied

LATEST

I don't have the knowledge or skills to write my own algorithms to export data. Nobody is saying this is not complex, but doesn't Adobe hire software engineers or train them to write what seems to be much more complex image processing software than than is needed to covert columns of data in a PDF to an Excel format? It makes no sense that 7 years later this is still not available.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 23, 2016 Mar 23, 2016

Copy link to clipboard

Copied

This is a major shortcoming of Adobe's PDF to Excel functionality. It does this even with well-formed, clean PDFs.

Here is one solution:

  1. export to Word
  2. then copy the table manually from Word into a Google Drive Spreadsheet
  3. then copy the table from Google Drive into an Excel Spreadsheet

It works, but it's a round about way of doing what should be a simple feature for Adobe to include. Hope they add it in there soon.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines