Saving html to csv and opening with Excel

Question

I am trying to save data from a database to a csv file. My problem is that some data is in html and when opening csv in excel the data is not formatted correctly. I need to save the html as it is, and I cannot edit it. Is there any way to do this?

Answer 1

Sure. Do not send CSV.

If your destination is Excel, then simply export the data to excel.

Take a look at http://epplus.codeplex.com/