I love Sublime Text. It's one of my favorite pieces of software. I have it running 100% of the time on every machine I work on. It's where I write all of my personal notes, blog posts, and it's where I wrote both "Game Programming Patterns" and "Crafting Interpreters". At the same time, it's not the tool I use as an IDE. For programming, I use whatever IDE is dominant for the language I'm working in. Over time, that'…
For data manipulation, I like multi-line cursors. Sure, I have expensive IDEs that can do this too, but sublime is great for non-technical people and it's very affordable and lightweight as you mentioned.
My other friend spends a lot of time in spreadsheets, and he was trying to import a bunch of tabular data one time and it didn't quite work due to the source formatting. I showed him how to pull it into sublime, quickly add some commas and remove some junk data on every line to get it in shape for importing into Excel. He loved it!