Legal
The views expressed in this blog are my own and do not necessarily reflect the views of Adobe Systems Incorporated.
Search
April
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 |
Archives
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- June 2006
- May 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005
April 6, 2009
Exporting a PDF to Excel
I received this email from a paralegal at a large law firm recently:
Help! An attorney has asked me to convert PDFs we received in discovery to Excel. The PDFs are tabular in nature (probably originated in Excel). Some are scanned in from paper and others appear to be converted electronically. How do I do this?
Fortunately, Acrobat 9.1 offers a couple of different ways to export to Excel.
- Select table and open in Excel
This allows you to select a portion of a page and open it in Excel.
- Works best when you only need small part of the table
- Better results if the file didn't originate from a spreadsheet - Export as Tables in Excel
This method uses some artificial intelligence to convert multiple page PDF documents to multiple worksheets in an XML-based spreadsheet file. It works best on files which were converted directly from Excel to PDF.
To open the XML-based file output generated using method 2 above, you'll need either:
|
Acrobat generally will usually do a pretty good job converting the text, but formatting and column widths will look different than the original. Acrobat only copies over the text. Formulas will not convert. Do not expect 100% fidelity.
In the full article, you'll receive my usual step-by-step instructions.
April 3, 2009
Rick's Slides from the ABA Techshow, Some new movies
Last year, over one hundred people attended my "Acrobat for Legal Professionals" track at the ABA Techshow.
I think all of them came up to me afterwards and asked for a copy of my slides!
To stay ahead of the game, I'm posting them here, in advance.
The slides include some tips for getting to many Acrobat features including Bates Numbering, Redaction, etc.
And, for everyone, I posted three new movies on my all new Movie Page:
- Creating a Custom Stamp
- Understanding and Working with Comments
- Exporting a PDF to Excel
The link to the slides is in the full article.
Enjoy!