Mark, I don't know any easy way to do it, and I presume you mean "how do you convert a table in PDF into an Excel File?"
Copy all the text from the PDF table and paste into MS-Word. Then you need to have each row header vertically formatted with a line break between each title. Do the same for all the data, making absolutely sure you have the same number of items in every column the same. If there's a blank cell, then there will be a blank line. When you've completed all that editing and you have a very skinny single column of text, select that entire string of text. Use the MS-Word Convert text to table function and tell it the number of columns you want, and select the auto size option. Then look at the resultant table in MS-Word, and see if all the data was distributed correctly. Often it takes a couple of tries to get it all correct. If you have a problem, undo and go back to find the error. When you have the table correctly formatted in MS-Word, copy the table and paste into a blank worksheet in Excel. If you try to simply paste the PDF table text into Excel, you will likely get all the text in one column of the spreadsheet, and not what you expect. Dave Carlson Oregonian, woodworker, Engineer, Musician, and pioneer ----- Original Message ----- From: "Mark Brett" <[email protected]> To: <[email protected]> Sent: Saturday, September 12, 2015 10:16 AM Subject: [Bulk] Re: [JAWS-Users] how to read tables in word, openbook, and ?adobe Hi, how do you convert a pdf to excel? Mark E-mail: [email protected] Mobile: +447966445226 Phone: +448432086070 Skype: markbrett1 -----Original Message----- From: Jim Pursley Sent: Saturday, September 12, 2015 2:04 AM To: [email protected] Subject: Re: [JAWS-Users] how to read tables in word, openbook, and ?adobe I will be interested to see how this thread develops. I've resolved the reading of row and column headers in Word and Adobe tables by exporting/copying to Excel wherever I can - especially where there are more than 5-6 columns, where my memory gets a bit stretched. Excel has a great feature in the Quick Settings (Insert V) configurator (Titles) that will allow user-defined row and column headers to be tagged so they are read by the JAWS voice as I navigate from cell to sell, column to column, row to row. Nice feature. On 9/11/2015 9:51 PM, Dacia Cole wrote: > Hi, > > I'm struggling reading a table in word, I've also tried reading it in > Adobe and openbook. It's hard to tell what columns go with what row. > What are the best ways to read a table in these programs? I have > openbook 9 and office 2013 with jaws 16 and windows 8.1 > > thanks, > > Dacia > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ > > > For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
