Importing Bank Statement PDF into Excel via Power Query

This tutorial demonstrate how to grab bank statement which is in PDF format into Microsoft Excel directly without using any external software for conversion of PDF to Excel. It uses Power Query which is embedded in Microsoft Excel to import it.

0:00 Intro
0:13 PDF Overview
0:41 Import Demonstration
5:30 End

Below is the setup used for demonstration
Excel: Office 365
OS: Windows 10 (64 bit)

[peppleibitoru]

So far the best explained video without any bias

[pvspkumar]

Very well explained without any ambiguity and the presentation is excellent to follow and understand

[JaiRaman-tczr]

Ty u r only till now I have seen hundreds of videos of excel 2 mention the excel version used ty keep up the good work

[jfernandez]

Perfectly explained. Direct to the point. I am your new subscriber

[rssdharini]

Excellent..👍👍👏👏 Dhanajay .. Thank you .. keep educating us.. please..

[sujesh.]

Excellent Dhanjay ji. Will ask any clarification is needed

[shokhabbosmaksudov]

Bro, you lost info from the description when sorting null date)) Anyway, I found what I was looking for. Thank you

[khandavadeveluaravindhandc]

Hi. I have a file with more than 10 pages. Is there a way by which I can clean all these pages and load to a single excel sheet? Please help me out.

[priyamvadaparmar]

How to import a file with more than 50 pages... Please help

[Nazar_ali_choudhary]

Hi sir,
i have a bank statement with multiple pages & power query makes a separate table for each page, is there any way to merge all of those tables?

[BaffaBadamasi]

i use a mac book pro it doesn't show the pdf option on my 365

[adityamundada]

Very good video. However I am not getting an option to import pdf even if I have office 365 subscription. How can I do this function in that case ?

[mahendrab]

If I want to merge multiple line narration datewise in pq how to do it in power query

[mariankeen]

I struggled to do this because my statement converts to 124 Tables. There are about 5800 lines of data. I am not sure where to go from there.

[ama]

But I can't SUM the amount of money of the data that converted from pdf. Does anyone know what is the problem?

[Faisal-qyfp]

I didn't find PDF option on my excel sheet "From File"

[krishnakantgoyal]

Agar get data ka option hi na show ho rha ho Excel 10 me

[gstshiva]

GOOD MORNING SIR, HOW TO REMOVE HEADER (LIKE FIRM NAME, ADDRESS, BANK ADDRESS AND MORE ) ITS COME EACH PAGE, HOW TO REMOVE IT, ITS KOTAKMAHENDRA BANK, PLZ REPLY ME, I AM A UR SUBSCRIBER, THANK U

[Amitkumar-ndfm]

it is worked on credit card statement also...plz tell sir

[vaishakhc]

It shows "pdf failed to load with result : password Required"