Import PDF to GRIND For Free

information from these PDFs into a single Excel  sheet? Well, you can start with copy and paste,   but soon you'll probably find it easier to just  type everything from scratch, but no, don't   do that. No copy and paste and no typing from  scratch. Instead, you're going to do this.   You're going to open up Excel and select Blank workbook. Then, go to Data > Get Data > From   File > From Folder. Now, you get to pick  the folder in which you have all of your   PDFs saved. In mine, it is sitting right here in  the folder "sales pdf". I'm going to select that   and open. Now, in this view that opens up, we  get to peek inside that folder. These are all the   different files that are saved there. Now, just  click on "Transform Data". Here, we can see more   information about the file. We can see the  extension, the date it was modified, date created,   and some more attributes. We don't see the content  of each file until we click on this double-down   arrow. With this, we get to combine the contents  of all these files. So, Power Query opens up   and gives us a sample file to take a look at. And,  by default, it shows the first file in the folder.   But, if you're not happy with the first file, you  can pick a specific file to represent the sample.   But, I'm fine with this. I'm going to keep it  dynamic and go with the first file. This is the   content of the file. I get a table view and the  page view. In this case, these are the same views,   so I'm just going to pick the table one and click  on OK. Now, Power Query is going to go ahead   and create some transform routines based on that  sample file, and then it's going to apply those to   each single file and finally, it's going to append  the results. So, all of the stuff that appeared   here was done automatically by Power Query. What I  get here is the file name, which can become useful   if you need to keep that in your final report. We  get the different columns in the file, so we have   date, properly formatted as date, first name,  last name, our text, quantity, formatted as a   whole number, and sales value is a decimal number.  And, I can update this to the currency format.   All my information is appended together.  All the steps are recorded by Power Query.   All I need to do is send this data to the  workbook. But, wait before I do that. I don't want   this column to look like this. I just want to grab  the store location from this part. So, I'm going   to double-click and update the header to "Store".  Now, to grab this part where it says "East" and   "North", let's use a transformation. Let's go to  Transform > Extract > Text between Delimiters.   My start delimiter is an underscore, but the  problem is that I have two underscores here.   I want the last one. So, I'm going to click  on "Advanced Options" and scan for the start   delimiter not from start of the input but instead  from the end of the input. So, we're going to look   backwards until we get to the first underscore. ...