Darren writes one of my favorite blogs – Problogger, it is a blog about blogging. It is super helpful for people like me who write, connect, share and sell online. A week back, Darren asked his readers to participate in a fun experiment by posting 7 links on their blogs. It seemed like an interesting idea, so I am chipping in.
1. My First Post on Excel: While this blog is in existence since 2004, I did not start writing about excel until 2006. My first post on excel is How to remove duplicates. This was not written on chandoo.org, but on my excel blog r1c1.blogspot.com which I later imported here.
2. The post I enjoyed writing most: Now, this is difficult to choose. Because, writing is not what I enjoy most. My enjoyment comes when an article generates a lot of conversation (comments, discussion on other blogs etc.). To that extent, the most enjoyed post is Become a Conditional Formatting Rockstar.
3. Post(s) that had great discussion: I am proud of our community here. Most of the posts generate quite a bit of discussion and sharing of ideas. Here is a list of posts that had lots of insightful comments:
- Do you know these double click tricks? – 86 comments
- Introduction to VLOOKUP, MATCH and OFFSET formulas – 75 comments
- Become a Conditional Formatting Rockstar – 180 comments
- Calculating Days Overlapped Between 2 sets of dates – 46 comments
- Childhood dream comes true – story of Chandoo.org – 86 comments
- Excel Keyboard Shortcuts – Open Thread – 66 comments [read followup Comprehensive list of keyboard shortcuts in Excel which consolidates all these shortcuts in to one post]
4. A post on someone else’s blog that I wish I’d written: 2 posts come to mind. First one is Debra’s unbelievably comprehensive collection of Pivot Table tips & tricks. Next one is Jon’s detailed overview of number formats in excel. Both of them are very well structured, highly sought after topics that I wish I had written. I refer to them every now and then when I am stuck and need help.
5. A post title that I am most proud of: Hands down it has to be Want to be a conditional formatting rock star? Read this. But I also like Twins, Clones and Duplicates – 6 Excel Shortcuts from an Excited Dad which I wrote from hospital room when I became dad to twins in Sept, 2009.
6. A post I wish more people had read: hmm, it could be the Date with my sheet – 10 tips on using date / time in Excel, which despite having a lot of tips, never really took off.
7. Most read post ever: It has to be the Gantt Charts – Project Management using Excel post. Written on June 16th, last year, the post attracted 150k page views so far, with 63 comments. The post also played a crucial role in 630+ sales of Project Management Templates.
One Question for you:
What is your most favorite post on Chandoo.org and why do you like it? Please share using comments.
PS: If you are not in mood for excel, here is something to get you excited. Some one calls me a bastard and it made me laugh. Find out why.
7 Responses to “Extract data from PDF to Excel – Step by Step Tutorial”
Dear Chandoo,
Thank you very much for this and it is very helpful.
However, all the Credit Card Statements are now password protected.
Please advise how can we have a workaround for that
Hello sir,
How to check two names are present in the same column ?
Thanks and Regards
Hi, Thank you for the great tip. One problem, when I click on get data >> from file, I don't see the PDF source option. How can I add it?
I tried to add it from Quick Access toolbar >>> Data Tab, but again the PDF option is not listed there.
I am using Office 365
Hi, Thank you for your video. I see you used the composite table, but I when I load my pdf, it does not load any composite table. It has 20 tables and 4 pages for one bank statement. I have about 30 bank statements that I want to combine. Your video would work except that I can't get the composite table and each of the tables I do get or the pages does not have all the info. what to do?
Dear Chandoo,
How do we select multiple amount of tables/pages in one PDF and repeat the same for rest of the PDF;s in the same folder and then extract that data only on power query.
Thank you
Hi, Thank you for your video. I see you used the composite table, but I when I load my pdf, it does not load any composite table. It has 20 tables and 4 pages for one bank statement. I have about 30 bank statements that I want to combine. nice share
One bank statement takes up 20 tables and four pages in this document. I need to consolidate roughly thirty different bank statements that I have. Your video would be useful if I could only get the composite table, which I can't for some reason, and each of the tables or pages that I can get is missing some information.