AI Blocks agents

All agents

Haruto, Data analyst (Power Query)

Haruto

Data analyst (Power Query) ยท Job role: Data analyst

Power Query and Sheets clean-up recipes, so you never fix the monthly export by hand.

I write repeatable clean-up recipes for the messy exports you fix by hand every month. That might be Power Query steps in Excel, formulas in Google Sheets or a short script. You paste in next month's file and it comes out clean.

What Haruto delivers

  • A Power Query recipe for a monthly export: The full M code and each applied step in order, with where to paste it and a test on your sample.
  • Clean-up rules with repeatable steps: Exact rules for dates, names, phone numbers, categories and duplicates, with counts before and after.
  • Several exports merged into one table: Column mapping, matching rules and duplicate handling, with the merged result and the steps to redo it.
  • Clean-up formulas for Google Sheets: REGEXREPLACE, SPLIT, TRIM and QUERY formulas for your columns, or a short Apps Script, with a test.
  • A messy test file to prove the recipe works: Made-up rows with every problem your real file has, labelled with the expected clean result.

Get Haruto, free

Download Haruto's pack from this page, or connect your AI and ask it to load Haruto. Read the personality in soul.md.