For Export PDF to Spreadsheet , how to export Table which is a Picture?

[Sunny26326757tb7e]

For PDF which is created by Adobe PageMaker, there is a Table which is a Picture.

Adobe PDF Export to Spreadsheet fails; I am still getting a Picture from its Excel conversion.

Is there any settings to Export Picture of a Excel Table to Spreadsheet?

[Brad @ Roaring Mouse]

Probably not.

If the original Table was indeed a picture, or text converted to outline at some point in the past, then there is no text to export.

You could attempt to OCR the table in Acrobat, and then export the recognized text, but it may not be cohesive enough for Acrobat to "recognize" it as a table to export it as anything resembling a spreadsheet. OCR is rarely a 100% solution.

[Sunny26326757tb7e]

Thanks, after some more thought, what I really need is replicate of Table formatting. I have yet found a App to export Picture Table including Formatting. 

There are multiple reasons:

1. upload to public which I need to scrub the content
2. try different Fonts to get best print legibility

Since this very large Table is Financial Report, it cannot be public.

[Brad @ Roaring Mouse]

Normally this is not a workflow I would suggest, but you could try open the PDF in Illustrator.

At least there you can see if the copy in your table is actually useable live text or something else. Even if so, you're not going to get automatic reformatting into a spreadsheet without manual intervention.

And if by formatting, you mean everything from actual font/sizes, etc., that's not possible.

[Brad @ Roaring Mouse]

You might consider looking at one of the OCR apps that are out there. The more sophisticated ones have better tools to handle such things as tables, especially the ability to allow manual definition of where the columns are in a scanned table so it can properly organize the data.

[Brad @ Roaring Mouse]

If you are able to share the file, we might be able to suggest a workflow for you

[JR Boulay]

Go to : Acrobat Pro : File menu : Export to : Spreadsheet

And try this:

[Sunny26326757tb7e]

Thanks before I proceed to acquire Acrobat Pro, does it also export formatting as well ?

[JR Boulay]

I don't know.

[Abambo]

You need to test, with the 7 day test version of Acrobat Pro.

[Sunny26326757tb7e]

Thanks, for enterprise works, if only Acrobat can offer test version online (instead of Desktop App) to reduce IT workload and associated approval.....

[Abambo]

Thanks, for enterprise works, if only Acrobat can offer test version online (instead of Desktop App) to reduce IT workload and associated approval.....

By Sunny26326757tb7e

I know. IT is sometimes very rigid. In my company, I have the advantage of coming from IT, so I do not need to kiss their feet to get something approved.

I think, there is an online version of Acrobat, but I do not know the overall usability of that. I would, however, strongly recommend testing in the production environment.

[Sunny26326757tb7e]

I am resorting to hand trace Table.All Cell dimensions are now done by manually changing Column Width and Row Height with Picture inserted into Sheet; the next challenge is to overtype same content but Picture cannot be behind Sheet. I tried  Picture in Header but it is distorted because of Paper Size cannot be set to 22" of my Laptop.

I would think anyone who wish to share their Spreadsheet publicly but have to scrub confidential information need some tool to replicate SpreadSheet formatting; is there such tool?

[Brad @ Roaring Mouse]

Sorry, what you want is beyond the tools available. If your table is truly a picture (raster-based), it would need to be OCR'd to make it back into text, and that will only be as good as the quality of the image, and even so, most OCR programs are not font identifiers. Acrobat (and also a couple of different standalone OCR apps I have used) can only be relied on to do so much. At best, you could hope it might identify the difference between a regular and bold font, and maybe if it's a serif or a san-serif, but that is truly a long-shot.

[Sunny26326757tb7e]

To explain more about my case on sharing publicly an issue without its confidential data, please find following screenshot showing

1. Whole Table shown in Print Screen of Display
2. Example of distorted Picture (when in Background) is in Magnify Glass (Yellow Textbox)
3. Sheet Paper Size A3 Landscale
4. Table Grid Color - Picture is Black (Shaded) ; Sheet (to be populated) is in Red
5. Table Title Text Font Color - Picture is White; Sheet is Font Color Black
6. Table Body Text Font Color - Picture is Black Shaded; Sheett is Font Color Black

It is a challenge to create Table to align with Picture in Background.

As mentioned, Picture inserted into Sheet has no distortion problem but block me from keyboarding content.

[Sunny26326757tb7e]

To share publicly Table from Picture w/o confidential data, can Paper Size match 22" Display? hand trace Text i/c Format of Picture Excel Table but its cells are behind Picture ?

[MikeKaiser]

Sounds like we're having a similiar problem.  I have a table in a PDF that's an image and need to get it out to a Excel format for editing.   I currently use another PDF editing software that was making hash of it, so I thought I try Acrobat but unfortunately Acrobat didn't fare any better.  If I try to export directly to Excel, I just get an image of the table.  If I OCR the table first, the output is gibberish.

Reading through the messages here I saw that Brad suggested using more dedicated OCR software and looking about a bit I settled on [I don't know how Adobe feels about using the names of competitors but the name of the software is very close to the name of the place that monks live].  Free trial, no CC.

I just tried one table but so far it looks really good.

[Luke Jennings3]

You can mention the name of other software on this forum if you like.

As for getting the type in an editible table to match an image of a table, first determine the fonts used to make the chart, this can be done by uploading a small sample of the type image to a site like "what the font" 

https://www.myfonts.com/pages/whatthefont?gclid=EAIaIQobChMIuOnno_ir_gIVw-jjBx0tMQLcEAAYASAAEgIfffD_...

If you can use the actual font, or a close substitute, this may fix some of the spacing and re-flow issues on the OCR'd chart. Another option might be to place the chart image into an InDesign page, set the opacity to 50% on a bottom locked layer (as a visual reference), create a new InDesign table on a top layer, and paste the text into it, finally exporting as an XML.

[Sunny26326757tb7e]

Thanks Luke, I have been stacking (PowerPoint which is allowed in my environment) different Font combinations in Front of said Picture of Table; only best-matching and laborious but result is much better than online Apps I tried (inlcuding yours). Also, I have yet found an App that recognize Font Size. 

APPENDIX 

Screenshot of Font Type and Size I am guessing:

[Brad @ Roaring Mouse]

I use that particular one (Abby), in fact. I don't consider it "competition" as the ability to OCR in Acrobat is a convenience feature, not their main purpose for being. I just don't usually like saying names of other software in case it appears I'm endorsing them; there's lots out there. How good they are, who knows until you use them. 

I used to use OmniPage back in the day but they haven't had a Mac version for many years so I had to abandon it. They do still have a Windows version, though. Both of these were good with rebuilding tables of data as you had the ability to manually define the column layout before the recognition phase, which got you 90% there, as opposed to a mess.

Unfortunately, as a Mac guy, the version of Abby I have no longer properly works in Big Sur on, and to upgrade to one that does, they have changed to a subscription model, which for a tool I would use only once in a blue moon is a no-go for me.

Still, it sounds like the OP is looking for something even those cannot do: e.g. retain formatting, be it fonts, size, cell colour, rules lines, etc. etc.  No OCR can do that, nor should it.

[Sunny26326757tb7e]

For my Table which cannot be exported by Adobe, Excel 365 Business does get some OCR. 

From my point of view, naming more capable non-Adobe Apps

1. improve Adobe competition information and therefore Adobe ability
2. but does not help me because I can only use Microsoft or Adobe in my environment. 
3. in Tech Support World, I have been seeing competitor Apps named which helps foster competition.

[Abambo]

Everyone here should consider that OCR on picture-tables is not trivial. The Adobe OCR is quite good, but it's not perfect, and its primary use is to get searchable text, where you do not need a perfect result in most of the cases. I really would tend to say that you need to access a high end OCR program for this.

[Sunny26326757tb7e]

Thanks, Is there OCR to get formatting of Table... for me, it is useful for

1.  find Setting  related to print legibility
2. uploading my Table publicly for troubleshooting  

App to OCR Table Formatting will save muh time hand tracing Picture to replicate Table.

[Abambo]

Optical Character Recognition tries to stay faithful to the original, but especially with tables, you may experience errors, where numbers get recognized wrongly. If you recognize characters instead of numbers (like O instead of 0), you have a chance to see that, but if numbers get swapped or omitted, you will have a hard time checking the data, cell by cell.

[Sunny26326757tb7e]

Thanks, to share my experience from 2023 Feb, https://answers.microsoft.com/en-us/msoffice/forum/all/what-about-a-ocr-setting-for-screenshot-to-ge...