Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Why are you using Excel and not .txt or .csv directly?


One good reason would be (as he says) that it is flaky. eg how does it handle newlines, commas, tabs and non-ascii characters in data? I've had to pull dirty data between systems before, and csv as the lowest common denominator tends to be lossy as there's no spec on this stuff. Some systems (eg oracle's csv import) do support forms of escaping, but they're not interoperable.

I see they support other file formats & json here, but a nice to have would be to use the google spreadsheet url: https://developers.google.com/chart/interactive/docs/spreads...

Grabbing data directly from Office365 is also possible: http://cwebbbi.wordpress.com/2012/07/24/consuming-odata-feed...


The worst thing is that I work in a bilingual office. Excel's export to CSV does not work as intended when you have more than one number format.


I mean that I want to use Excel as a spreadsheet and use its contents to drive a D3 diagram without the current hassle of getting the data out of Excel into a format that D3 can read cleanly (and continuously - if I update the spreadsheet, the diagram should also update).




Consider applying for YC's Fall 2026 batch! Applications are open till July 27.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: