Hacker News new | ask | show | jobs
by c4mpute 979 days ago
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!
1 comments
uxp8u61q 979 days ago
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.
link
c4mpute 979 days ago
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.

link
uxp8u61q 978 days ago
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.
link
ellyagg 978 days ago
Cut it with the attitude. This is not the place for it.
link
uxp8u61q 978 days ago
Who are you?
link
maxerickson 978 days ago
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

link
Seanambers 978 days ago
Powerquery oh god never again!
link