Export table to CSV(display data)

Hello people) I have questions about export table to CSV file! I want export to CSV file table which i filtered or not filtered with headers and column which visible. How I can do it, please can someone help me? And how I can export date in right format the same as like in pictures?
Original table have 17 column but I display only 7 column, I export only displayed column)