Hello everyone this is Ian Lamont author of Google Drive and Doc's in 30 minutes and recently I received a question about Google Drive and Docs and actually specifically Google sheets and I've created some videos in the past where you can create a PDF from a Google sheets but someone asks is it possible to create a Google sheets from a PDF that is if you have a PDF with some information on it can you import that data into Google sheets and the the short answer is yes but you have to do a couple extra steps to make it work and this is what this video will show you hopefully in a short period of time so let's take a look at a PDF here's a very simple PDF that I have it basically just shows the daily highs temperatures in various cities in the Northeast US on a weekly basis it's a very simple chart and what I want to do is take this data it's all text data in the PDF I can't edit it but I want to bring it into Google sheets and the idea is once that data is in there then I can manipulate it I can create charts I can export it as something else and how would you do that and the answer is it's pretty hard to do it directly and in fact I haven't been able to figure out a way to do it directly but there's a workaround you can do to make it work one caveat the PDF that you have it has to be a really simple charter table it can't be other like you can't have text over on the left side here that's outside of the table or you know to two...