Get the free blank spreadsheet templates form

Video instructions and help with filling out and completing free blank spreadsheet templates

Okay in this tutorial we'll be teaching you how to copy information from off of a PDF document that has been displayed in column form and paste it into an existing Excel spreadsheet step one is to load up your PDF step two select the text that you want to bring in in this case it begins with Row one right here and it ends at the very bottom of our page so we'll scroll down until all that information is selected we are left clicking and dragging to select the text next right-click and choose copy open up Excel click in the cell you'd like the information to be placed right click and choose paste now in this case the information is not displayed in column form as it was in our PDF so we'll have to format this just a little bit it's actually quite simple to do so select everything in your first column just like so come up to the data menu and choose text to columns we'll see we'll leave the top option selected which is delimited characters such as commas or tabs we'll separate each field here we'll choose next and we want the columns divided up each time a space appears in the text so we'll go ahead and choose that option here space and it previews what it will look like here choose next and finish and that's all you have to do now as you can see each word or number has been placed in its very own cell now there's a couple locations here where there are some errors in this case on cell d12 it's separated Ashland and city well we want to go ahead and bring city into the same cell as Ashland is so I'll simply cut that and paste it right here looks like the second let me do it just going to have to select the text right click cut come back here and paste that in there we are I'll resize column C a little bit and then I need to shift these cells over so I'll just do a quick cut and paste right click cut click in the cell I want it to go right click again and choose paste there we are and then from here it's just a matter of formatting your information so that it looks the way you want it to that's all there is to it