Power Query is useful for automating work with data in tables. The add-in allows you to extract, transform and download data from various sources, which simplifies the processing of large amounts of information and automates routine data preparation tasks.
In Excel (MS Office), Power Query supports downloading data from Excel (XLSX), CSV, TXT, PDF, JSON, XML, databases, cloud services, and other formats. You can receive data from multiple sources at the same time, for example, all files in one folder.

https://learn.microsoft.com/en-us/power-query/