How to Output to CSV in MySQL. When you add online shopping to your ... Open the CSV file in a text editor such as Notepad or with a spreadsheet program such as Microsoft Excel to confirm that ...