Excel 2011 renders data all in one column

asafdav / ng-csv

Simple directive that turns arrays and objects into downloadable CSV files

MIT License

573 stars 215 forks source link

Excel 2011 renders data all in one column #157

Open thierryskoda opened 8 years ago

thierryskoda commented 8 years ago

It works for me with my excel 2016, but with another computer and different version of excel, it puts all my data in on column divided by a comma.

Thank you for the help!

lneves12 commented 8 years ago

I think you need a special header for excel.

I created a pull request to overpast this question but it wasn't merged yet :/

thierryskoda commented 8 years ago

Thank you for the quick reply! I hope it will be merged soon haha!

waxxxd commented 6 years ago

Depending on your locale Excel has a different list of field separators. More info Stackoverflow. This post also discusses the sep=, value written to the file.