Adding the "Power Query" to the table editor

Suggestions Spreadsheet editor
,
1

Imported from UserVoice

Author: Артем С

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.

3

Thanks for the suggestion! This is something we’re already working on — a Power Query equivalent for the Spreadsheet Editor is currently in development. We don’t have an ETA to share at this moment, but we’ll update this thread once it’s available.

1 Like