News for hackers. Stuff that matters.
Re:Why Shitty Products Survive and Thrive by phonon on Friday January 29, 2016 @11:43AM (#10996266)
>In addition, it is completely useless for handling any type of delimited file. By default it supports csv. If you want to view a pipe-delimited file, you have to dig into the language settings of Windows, change the default delimiter, and open the file. Then, you cannot edit comma-separated files without changing it back first. So, there's no way to convert one to the other. Same problem with tab delimiters.

Totally wrong, Excel has the ability to import using Data -> From Text that opens a wizard that will step you through opening any type of delimited file, formatting columns, header rows, etc.

Re:Why Shitty Products Survive and Thrive by nanny on Friday January 29, 2016 @11:48AM (#10996311)
That doesn't help you edit the file, though. It only helps you convert it to an Excel file. You still can't save as anything other than comma-separated without changing the language settings.
Re:Why Shitty Products Survive and Thrive by phonon on Friday January 29, 2016 @12:27PM (#10996711)
First, you're wrong again, you can also save as tab delimited text or just text. Also, Access has some more Excel export options. http://superuser.com/a/107124

Secondly, Excel is not designed for round trip editing in plain text formats. You shouldn't use Word as a text editor either :-)

There are specialized editors if you want to directly edit a csv file etc. I use them sometimes. That's not what Excel is for.