SaaS ideas your next customers are already looking for
100 SaaS startup ideas for the people who said they'd pay, from agency owners to dentists. Micro SaaS ideas, AI SaaS ideas and B2B SaaS ideas: find yours, build it, sign them up.
Popular:
| # | Idea |
|---|
No idea matches this filter.
Pain points in business: what people struggle with
Search the problems to solve, as people described them on Reddit and other platforms, in their own words.
Popular:
| # | Pain point |
|---|
No pain point matches this filter.
Messy Data Import Cleanup
Users repeatedly struggle with cleaning and reformatting messy CSV, Excel, and other exports before they can be imported or analyzed.
In their words
I need to use a text editor to verify the value is remitting as needed and then use Excel to do things like formulas for auditing and filtering.
Every month I get bank statements and system exports in five different layouts and reshape them the same way every time.
It worked, but honestly became a bit of a maintenance headache over time (edge cases never end)
I have to copy data over from one platform and paste it into Excel. And then it’s impossible to ever to VLOOKUPS
CSV upload tool was timing out on large imports... they ended up just sunsetting the CSV upload and told all us contractors to hire a person full-time to manually update all the data instead.
as soon as I hit the 200k+ mark, my local workstation starts gasping for air and the PowerShell process memory usage just climbs until it hits a wall
the amount of time I spend cleaning up other peoples nasty Excel data to bring into the system is pretty high
This leaves me in the position of having to do their CSV uploads for them.
Every few months column order shifted slightly when someone added a category mid-sheet. Nothing broke loudly, the dashboard just started mapping "returns" into "revenue."
I find it a horrible pain to work with CSV inside the actual playbook. Also it gets really messy with Jinja2.
The schema is so complex that it takes a good hour just to load up this convoluted mess into my mental RAM so I can start working on it at the start of the day.
Manually reformatting JSON from an API that returns everything in snake_case when the frontend expects camelCase, wrote a one-liner for it after six months of doing it by hand like an idiot.
these ids will have been converted into scientific notation by Excel with the resulting loss of precision rendering the ids useless
exporting data from the Cronos format to CSV through the proprietary software becomes quite a hassle
Data and spreadsheet users
Where they talk
- r/excel
- r/dataengineering
- r/Accounting
- r/MicrosoftFabric
- r/dropshipping
- r/databricks
- r/spreadsheets
- r/MicrosoftFlow
Tools they use today
- Excel
- Power Query
- Python
- Claude
- Google Sheets
- Power Automate
- Power BI
- Shopify
Why those fall short
- Excel auto-converts pasted identifiers, breaking VLOOKUPs and corrupting CSVs
- Excel drops trailing zeros on open; import wizard needs manual steps each time
- Excel treats IDs as numbers and removes leading zeroes
- Numbers files are incompatible; clients send them anyway
- no error report, no dry run, no custom field bulk import
Map of ideas
Drawing the map…