How to extract tables without borders from a pdf using Acrobat Pro 2020

Forum|Forum|3 years ago
October 4, 2022
3 replies
5063 views

Hello, I am trying to extract a table of data from a pdf using Acrobat. This table is from a research article and doesn't have column or row borders. Unfortunately, when I try to extract the table to excel, it ends up extracting the data with rows merged or with a table row divided into two vertical cells, which is very time-consuming to fix. See below

This topic has been closed for replies.

try67

Community Expert

As mentioned, you can't change the output Acrobat creates. However, it might be possible to get better results using a custom-made script, especially if the columns are always the same size. It's not a simple task, though. If you're interested in hiring a professional to create such a script for you, feel free to contact me privately (click my username and then on Send a Message to do so).

Luke Jennings3

Community Expert

Do you have access to the document that produced the original pdf? Using the original might produce better results, you can often determine the software that created a pdf by going to File> Properties> Description. If you don't need to use the chart for anything other than a visual reference, you may be able to add the pdf to your Excel file as an image (I don't currently use Excel, so I'm guessing here). You could also try to export to spreadsheet, then copy and paste, unless you have already tried this.

M

Mo264298931ywuAuthor

Participant

No, unfortunately, I don't have access to the original file. My goal is to be able to extract this data and create another table by adding this data to other data and analyzing them all in aggregate.

Luke Jennings3

Community Expert

So you did try exporting as a spreadsheet? Try exporting as Word, then copy/paste into Excel, also try saving as rich text, with a bit of luck, one method might show some improvement.

In the past, if I needed to recreate a table (in InDesign), I would place the table as an image, reduce the opacity to 50%, then re-set all new copy on top of the original in a different color, then delete the image when done, the advantage was it's easy to catch any errors.

radzmar

Community Expert

You won't get any better results. Acrobat hat no clue, what a PDF visually represents to you. It can interpret vartical spaces as columns and line breaks as rows, but it can't determine if a row should contain multiple lines of text or not.

M

Mo264298931ywuAuthor

Participant

But it looks like it's having trouble even interpreting where the columns and rows are at.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded