Unlock the Secret to Importing Scanned PDF Data into Excel with Ease!
Вставка
- Опубліковано 4 тра 2023
- In this video, you'll learn a handy trick for importing data from a scanned PDF document into an Excel file. If you've ever struggled to copy data from a scanned document due to it being in image format, this trick can save you time and effort.
First, the presenter explains how they attempted to import data using the "Get data from PDF file" feature but were unable to due to receiving an error message. They then share their simple trick for capturing a screenshot using the Windows shortcut key, 🪟 + SHIFT + S. The captured image is then pasted into an Excel file to import the data.
The presenter also shares tips for ensuring the captured image is clear and provides guidance on reviewing and editing the data in the "Data from Image" pane before inserting it into the worksheet.
If you found this video helpful, please consider giving it a thumbs up and subscribing to the presenter's channel for more useful content.
#Excel #PDF #DataImport #ProductivityTips #MicrosoftExcel #ScannedPDF #DataExtraction #Shortcuts #Windows #Tutorial #HowTo #TechTips #DataAnalysis #OfficeTips
Thanks. You're a lifesaver. It worked great. I had to check most of the large numbers over 1,000. It seemed to mess up the decimals and commas.
You could have at least explained where the option to get data from a picture is....
It did. Screenshot the image so it is on your clipboard, the use the get data from picture from clipboard option on the data tab in excel.
Its from clipboard image
failed to understand
Recommended to watch in repeat until you get understand.
Thanks for showing me the unlocked secret, but my MS Excel 2000 doesn't do anything like this trick and nor does my recent Libre Office 7.3 equivalent spreadsheet software either!. So, which magic version of Excel are you using? By the way, can you use any PDF showing a table, rather than a 'scanned PDF', please?