[towawy]

Microsoft Excel. Manipulating tens or hundreds of thousands of rows, including cross-referencing across tables, is just so satisfying and much faster than doing it with a DB or code. Alternative spreadsheet software do some things better, but they don't come close as a complete package, I don't regret paying for it myself for the first time in my life. It such a life saver in a pinch.

Obligatory Spolsky intro to Excel: https://www.youtube.com/watch?v=0nbkaYsR94c

[manv1]

Excel gets my vote for one of the top 10 software programs ever. It's crazy how useful it is.

[hermitcrab]

Excel, the second best program for any task. ;0)

[huijzer]

As a Linux user, using Excel via the web interface or via a virtual machine is not so satisfying nor much faster than alternatives.

[npteljes]

Yeah, as someone who doesn't pay for MS, I'm basically using a combination of Calc and Gnumeric, because G can open larger files (handled larger files than Excel in fact), but Calc has more features, and it's more similar to Excel which I was used to. ONLYOFFICE's sheets can also be handy, if MS Excel compatibility is wanted.

[eitland]

Crazy useful.

So useful I like it despite how it always goes out of its way to waste my time by trying to misrepresent a number of different types of strings and numbers as American dates :-|

[zemoose]

Dear god, I would use Excel so much more if I could get it to stop mutating my data.

[jerzyt]

100% in agreement on Excel. Even when coding in Python I frequently save an intermediate file as xlsx to explore/debug, or even load into Tableau for viz.

[OrvalWintermute]

110% agreement on Excel

The ability create a relational database in Excel with vlookups and hlookups, then capture it all into a macro is amazing.

I've really enjoyed using Excel as a Postgres frontend, with a real Postgres DB instance handling data, and then using the report functionality to dump to Word.

While a pro reporting engine and cutting out MS Office altogether would be a better longterm solution, it is hard to beat for quick & dirty results.

[aquafox]

You should learn R and dplyr ;)

[adra]

I got to play around with Tableau when I was helping my wife in a collage programming course and though I don't have a current use to justify the significant cost, I must say that the tool was amazingly flexible and easy to use. I'd highly recommend it.

[systemvoltage]

Pssh... adults use JMP ;-): https://www.jmp.com/en_us/software/data-analysis-software.ht...

Trivia: JMP stands for "John's Macintosh Project".

Also, the entire semiconductor industry depends on JMP just like the entire pharmaceutical industry depends on Minitab.

[analog31]

I work at a shop where a few people are JMP users. I think it's a problem when a proprietary app is only available to a handful of users at a site -- they tend to get a lot of work dumped on them, and nobody can use their stuff without going back to them. It's a different experience when a site has a site license.

This isn't specific to JMP of course. A good thing about Excel is that businesses are OK with just paying for "everybody" to have it.

Also, people use Excel for more than analysis. It's also a crude database and platform for creating small "apps" that do things, that are easy to share with others.

[BeetleB]

And we go full circle. I learned pandas in 2012 so I don't have to deal with Excel or JMP scripting.

Still use Excel for quick stuff but otherwise it's pandas for me.

[hermitcrab]

The JMP buy page doesn't even give you a price. How expensive is it?

[jen729w]

Yeah, just yesterday. Hacky output from `nslookup`, not ideal but it’s all we had. Tens of thousands of rows. No IDE with regex capabilities available.

Excel to the rescue! Took me about five minutes to extract exactly what I needed.

[dgacmu]

If you can use dig output, the next time you need to do something like this you might find 'jc' helpful: https://github.com/kellyjonbrazil/jc

[jodrellblank]

> "No IDE with regex capabilities available."

If it's Windows there should be PowerShell ISE installed.

[melagonster]

where can I input regex to excel? I really need that, last time I copied table to nopad++ then copy paste it back.

[leokennis]

Often useful CLI tools are linked on HN (like in this thread). And probably if you take the time to learn them or if you integrate them into your automation they are 100% useful.

But, given the problem “I have some unfortunately formatted data which I need to analyze”, there is no better solution than sanitizing it in VS Code and then analyzing it in Excel.

[SuperSandro2000]

And for me excel wastes 100 hours a month.

[yawnxyz]

I don't have a Windows machine, and I'm having mixed feeling about Excel for Mac — is it as powerful as the Windows version? Are they exactly the same or are there big difference in functionality? The web / Office360 version doesn't seem much better, either though.

[cyberge99]

Native Excel on macos isn’t bad. I’m on an M1 and it’s slow to start initially, but once loaded it’s fine. Better than any web version.