How can I export the campaign report? What is the format?

There are export functions next to each report for download in CSV format. You could open CSV files by Microsoft Excel.