Excel · Power BI · automation

Power Query: data from many files in one clean table

Power Query is built into Excel and remembers every step of tidying your data. A query set up once does the same work every month, without you.

I'll review it for free and tell you how much time you can win back.

  • Excel world vice-champion, MOS 2026
  • 6 MOS certificates, incl. 4 Excel Expert
  • Szczecin and remote across Poland

Typical situations

  • Every month you merge a dozen exports into one sheet.
  • Dates, names and columns look slightly different in every file.
  • System data has to be fixed by hand before it can be counted.

What I set up

  1. Combining files

    Every file in a folder in one table, including the ones still to come.

  2. Cleaning

    Duplicates removed, data types fixed and names made consistent.

  3. Merging tables

    Data from different sources joined on a key, with no VLOOKUP across thousands of rows.

  4. Refreshing

    One button instead of hours of copying.

How I price it

  1. 01

    A free review

    You send the file or describe how the report gets made today. I tell you what can be automated.

  2. 02

    A fixed price up front

    You get a quote for the whole scope and a deadline before we start. No billing every hour.

  3. 03

    You see the payback

    With the quote I work out how many hours a year you win back, so you know whether it pays off.

Where I work

I work remotely with businesses across Poland: on a shared file and short online calls, with no USB sticks in the post. On-site meetings are possible in Szczecin, Goleniów and the rest of West Pomerania, and in Warsaw.

Common questions

Do I have Power Query in my Excel?

Yes, it's built into Excel 2016 and later and Microsoft 365, on the Data tab as “Get & Transform Data”.

Will it replace macros?

For fetching and cleaning data it usually does, and it's easier to maintain. Macros help where Excel itself needs to be controlled.

Will you train my team?

Yes, I hand the queries over with a short guide and show how to refresh and adjust them.

Got a spreadsheet that eats your time?

Send it over or describe what you do every month. I reply within a day.

Show me your file