Hacker News Reader

Comment by uxp8u61q | Hacker News Reader

Have you... used Excel? It's very simple to create any kind of "dashboard" (AKA graphs on a page) and then you just share the web link to the page.

View on HN

Yes, I have. What Excel is still lacking is an easy solution for the input side. You can bind tons of data sources, but all are weird, hard-to-use, manual. There is no easy "grab this from that website, get the current data of what I just pasted there, mash it together, publish it"

Hell, it cannot even do proper CSV import. You need to reformat your CSV to match the locale Excel is running under!

Uh? Are you sure you've actually used Excel? The CSV import is highly configurable and leads you immediately into Power Query where you can massage the data any way you want.

The LibreOffice CSV import is configurable. The Excel one isn't.

You can do things in PowerQuery, but that is far from obvious and still buggy. Not to mention all the woes after import, like date/time auto-interpretation and autocorrections that cannot be switched off.

I stand by what I said. Excel imports are a huge mess.

Would you like me to send you some online tutorials on how to import CSVs into excel? Because at this point it's just crazy. Are you using excel 2009? Do you not know about the "Data" tab in the ribbon? There's a whole dialog to complete with several options when you import a CSV file.

Cut it with the attitude. This is not the place for it.

Who are you?

Powerquery oh god never again!

Are you evaluating import or open? Open does stuff to the data right away, import lets you push buttons first:

https://www.fcc.gov/general/opening-csv-file-excel

Reply on news.ycombinator.com