Import Data into Excel from Anywhere! (PDFs, Websites & Photos)
Need to get data into Excel but tired of messy copy-paste results? In this video, I'll show you how to import data into Excel from anywhere - PDFs, websites, and even photos - using Power Query's amazing capabilities.
Here's what you'll learn:
· How to import clean data from PDFs without the formatting mess
· The smart way to pull data from websites directly into Excel
· Using Excel's new "Data from Picture" feature to extract data from images
· Why Power Query is your best friend for importing data from anywhere
Whether you're dealing with messy PDF tables, large website datasets, or data trapped in photos, these Power Query methods will let you import from anywhere and give you perfectly formatted results every time.
📖FREE RESOURCES
FREE EXCEL SHORTCUT GUIDE (PC): https://excel-dictionary.com/pages/fr...
-FREE EXCEL SHORTCUT GUIDE (MAC): https://excel-dictionary.com/pages/mi...
-FREE EXCEL FUNCTION GUIDE: https://excel-dictionary.com/pages/fr...
📩NEWSLETTER
-Unlock the full potential of Excel with expert tips delivered to your inbox each week: https://www.excel-dictionary.com/subs...
🤓SHOP EXCEL DICTIONARY
COURSES: https://excel-dictionary.com/collecti...
-GUIDES: https://excel-dictionary.com/collecti...
-MERCH: https://excel-dictionary.com/collecti...
-TEMPLATES: https://excel-dictionary.com/collecti...
📺SUBSCRIBE
-Subscribe to never miss a video: / exceldictionary
🕰️ TIMESTAMPS
0:00 - Introduction
0:22 - Importing from PDFs with Power Query
1:14 - Importing from websites
2:02 - Importing from images (Data from Picture)
2:43 - Wrap up