1. Got barcode reader and scanned some barcodes from books
2. Looked up these from online API
3. Wrote result in ISBN;Name;Year to output
4. Tried to copy result to Google Sheets
5. No import from custom CSV? (Excel has very good tooling)
6. Actually to split I had to use =SPLIT() and then copy paste results in weird way to actually be able to use first column...
Is this really better? Or good enough...
Most people using Excel/Sheets/Word/Docs are not power users. Pretty much all home use is covered by OpenOffice and that is the majority by user count.
I have Libre Calc installed because I am on mint at home and even if it could do everything excel could do, I don't know how to do things the same way. Neither do most people. The personal experience and network effect is insurmountable for other software.
Exactly.
Just work in the finance or insurance industry for a year, and you will see how it is part of the daily workflow to use very obscure, advanced Excel feature combined with VBA. If a proposed Microsoft Office alternative cannot handle this, it's not suitable.
I personally observe that a lot of nerds who barely use Excel in their daily workflow patronising that ... (in particular LibreOffice) is an alternative to Microsoft Office. Better first learn how the actual powerusers' workflows (in particular for Excel in the finance and insurance industry) actually look like.