Case Study
HS List Formatter
Upload a CSV, map columns, export a HubSpot-ready import file.
The problem
Target lists come in from every direction — different departments, different formats, sometimes just one column of raw data and a prayer. Depending on the list type, the formatting requirements are completely different.
And a couple of fields in particular had to be exactly right, or they'd break reporting, dashboards, suppression logic, everything downstream.
So people kept coming to me. Every time. To confirm the columns were right.
How to think about this problem
List formatting sounds like admin work until one wrong column breaks everything downstream.
The problem is not the CSV.
The problem is that the rules are different depending on the list type, and the person formatting it has to know which rules matter.
That is exactly the kind of process that should not rely on memory.
If a field has to be perfect every time, the tool should make it impossible to get wrong.
That is the difference between documentation and guardrails.
Documentation says: "Please remember to do this correctly."
A tool says: "You cannot do this incorrectly."
What it does
Load the list, pick the type, export it formatted exactly right for HubSpot import. For the notification type specifically, the critical fields are handled automatically — it's impossible to get them wrong, because the tool doesn't give you the option to.
How it works
Pick the list type and it applies that type's formatting rules. For notifications — the type where the critical fields have to be perfect — those fields are set automatically, so there's no way to get them wrong.
- 01Load the list
- 02Pick the type
- 03Export HubSpot-ready
Why it's helpful
It's not just faster. It's that the answer to “did I format this correctly” is now built into the tool itself. Nobody has to ask me anymore.
See it
Screenshots and a walkthrough coming soon.
Under the hood
Pure browser-side HTML/JS — the list never leaves your machine until you export.