Get Data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/get-data/ Bestselling Excel and Power BI Courses Sun, 17 Aug 2025 07:45:46 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Get Data Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/get-data/ 32 32 How to Bulk Import Data from PDF to Excel https://www.xelplus.com/bulk-import-pdf-files-to-excel/ Mon, 20 Jun 2022 14:18:00 +0000 https://www.xelplus.com/?p=9102 Use this button you already have in Excel to bulk combine and import PDF files to Excel. Forget copy, paste, manually typing values or using 3rd party tools. Get it dynamic too so you just need to drop a new PDF in a folder and the data is immediately imported to Excel.

The post How to Bulk Import Data from PDF to Excel appeared first on Xelplus - Leila Gharani.

]]> How to Convert PDF to Excel https://www.xelplus.com/import-pdf-to-excel/ Thu, 15 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10614 Learn to properly convert PDF files to Excel without losing any formatting. With this method you can even refresh your Excel result to grab the latest data from your PDF file.

The post How to Convert PDF to Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Power Query – What Is It and Why Should You Use It https://www.xelplus.com/excel-power-query-course-preview/ Mon, 29 Jun 2020 17:50:00 +0000 https://www.xelplus.com/?p=10898 What can Excel Power Query do for you? It can help you in more ways than you think. Not only can you import big data from different locations, but you can also replace complex formulas with a few clicks.

The post Excel Power Query – What Is It and Why Should You Use It appeared first on Xelplus - Leila Gharani.

]]> How to Combine Files From a Folder with Excel Power Query https://www.xelplus.com/power-query-combine-files-folder/ Thu, 21 May 2020 09:00:00 +0000 https://www.xelplus.com/?p=11329 Learn the easiest way to combine multiple Excel files into one Workbook. With Power Query you can import files directly from a folder and append them into one table or Pivot Table. It just takes a few clicks.

The post How to Combine Files From a Folder with Excel Power Query appeared first on Xelplus - Leila Gharani.

]]> How to Easily Import Data from Web to Excel https://www.xelplus.com/import-data-from-web-to-excel/ Sun, 15 Dec 2019 02:53:00 +0000 https://www.xelplus.com/?p=11661 Quickly learn how to import data from a web page into Excel with these 2 practical examples. The advantage of importing data this way is that whenever the data on the website is updated, you'll just need to "refresh" the data in Excel to get the latest information. It's super easy!

The post How to Easily Import Data from Web to Excel appeared first on Xelplus - Leila Gharani.

]]>