Best way to export collection to CSV

[naveed_raza]

Hi All,

What is the best to way to export collection to CSV in proper UTF-8 unicode compatibility.?

it should handle all double quotes , single quotes and commas between names and should be very reliable to handle thousands and lacks of records 

any suggestions and what are all multiple ways to do that ?

[naveed_raza]

Initially , i have exported data to Excel using MS Excel VBO and MS Excel VBO Extended object and saved the file as CSV using Workbook Save As. Its was saving the file in CSV format however it was not UTF-8 compatibility and when ever we open the file we are getting the pop up error.