Hi, Before I answer your question, I am curious about 2 things.
1. What do you your colleagues when faced with the same situation? Surely they have an established method. 2. Somewhat related to the first question, if your company subscribes to a paid data source, doesn't that provide you with financial statements in different formats? While publicly available financial statements are usually in PDFs, I don't think that's true for paid data sources. Finally, to answer your question, here is a free online service that converts PDF to Excel, and is as good as any desktop based solution. http://www.pdftoexcelonline.com Usually it is better and quicker to extract financials from HTML to Excel using VBA. Also, there are free sources that provide comparative financial statements directly in CSV format, let me know if that would be of any help. Regards Sent from my Lenovo ThinkPad --- On Wed, 6/22/11, ekinath ekinath <ekin...@gmail.com> wrote: From: ekinath ekinath <ekin...@gmail.com> Subject: Re: [AI] Help required wtih copying tables from PDF to excel To: "accessindia" <accessindia@accessindia.org.in> Date: Wednesday, June 22, 2011, 10:18 AM Dear Sachin, Hope you are doing great. I have red about most of the things from the old mail sent by Prashant too me long back. However, now i dont have so much time to take lessons on PDF understanding. I request for straight specific answers fromo people who are experiencing same problems and probably have fojund the smart way out. Anyway, genuinly thankful for your response. Cheers and good luck On 6/21/11, ekinath ekinath <ekin...@gmail.com> wrote: > Hi techies there, > > The PDF files really consume most of my job hours. I waste lot of time > in making PDFs accessible which are mostly annual reports of different > companys for financial analysis. > I request you to help me with PDF navigation, location of text or > tables, copying of tables to excel sheet properly. > > In fact, I am using a very fine software to convert PDF to word which > does a very good job in even converting image photo from any mobile > phone of any print. > However, it fails with tables. > > Specific problems: > > 1. Not able to properly convert tables from pdf to word > 2. Not able to select the table from the converted docx file > 3. After pasting table inm excel using paste special text feature > still sometimes table gets messed up > > Objective: Getting financial statement tables in to excel so I can do > many calculations where typing the whole balance sheet in the excel > sheet is not required. > > Pl. help me with this and I shall be very grateful. > In case if you are too generous to call me for this then > 09821708412 > > > -- > Regards > > Ekinath Khedekar > > Sr Mgr > Corporate Strategy & Planning, > Reliance Power Limited, > I block, North wing, > DAKC, New Mumbai > -- Regards Ekinath Khedekar Sr Mgr Corporate Strategy & Planning, Reliance Power Limited, I block, North wing, DAKC, New Mumbai Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in