Guides on data & research
Practical walkthroughs on spreadsheets, data manipulation and UK company research.
How to Consolidate Multiple Excel Files for Analysis (Without Writing Python)
A practical guide for data analysts who keep receiving 30 spreadsheets when they asked for one — and need to merge them cleanly, with full source traceability.
Read moreFuzzy Matching Company Names: A Practical Guide for Data Analysts
Why "Acme Ltd", "ACME Limited" and "Acme (UK) Ltd." never join cleanly — and the techniques (and tools) that actually fix it.
Read moreSplitting Large CSV and Excel Files: When and How to Do It Right
When 1.2 million rows arrive in one .xlsx, splitting is not optional. Here is how to split cleanly — by column, by chunk size, or by row count — without breaking downstream joins.
Read moreEnriching Company Lists with AI: A Workflow for Data Teams
How to turn a bare list of company names into a CRM-ready dataset with structured products, services and segments — using AI without losing data quality.
Read moreUK Company Due Diligence for Data Teams: Beyond Companies House
Companies House gets you 60% of the way. Here is what the other 40% looks like — and how to build it into your data workflows.
Read more