User-friendly, affordable, and packed with different features, DocHub is a healthy and cost-efficient alternative to Yousign. Try it now and learn how to squeeze the maximum of our solution with easy-to-use feature shortcuts.
barry my accountant called me the other day and said hey chandu can i get a copy of all your credit card statement for the last year i dont want to manually go into 12 pdfs and you know copy paste the data i would rather use one excel table of course i replied say yes sure and i quickly opened up power query combined all my pdf files into one single excel table removed any unnecessary information and sent the data to barry before i finished my morning coffee let us go through the process so you two can do it easily so here is how my typical credit card statement looked like it has some header details and a transaction details table that goes into multiple pages depending on how many transactions happened in a month now lets see how to get a single credit card statement into excel first and then see how we can get an entire list of statements into one single table so we go home and then data from here get data from file from pdf now this option is available in office 365 but if you a