TOP

Create Power Query worksheet

Power Query > Make PQ worksheet

This tool allows you to create new worksheet, containing a new formatted table that is dynamically linked to the original selected range in LibreOffice Calc. This mimics the "Power Query" (Get & Transform) functionality from other programs, simplifying data updates and their use for reports or pivot tables.

The source range is converted into a structured table, and the new table on the new sheet displays its content with the applied style.


Screenshot

Power Query > Make PQ worksheet

After applying:

Power Query > Make PQ worksheet

Running this tool

Click YLC Utilities > Power Query > Make PQ worksheet :

LibreOffice Calc:

YLC Utilities > Power Query › Create Power Query worksheet

How much time will this save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use LO Calc, the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Make PQ worksheet by installing the extension YLC Utilities.

After this, this feature will be available in all files opened in LibreOffice Calc.


Additional keywords for this tool:
Power Query, Query, Table, Link range, Formatted table

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel