Google Analytics has a very easy interface to export data out of Google Analytics and/or share your data with others.
In the top section you will see a menu for “Email” and “Export” functionality.
The drop down has 4 options
- CSV – CSV means Comma Separated Values . The output you will get is all you data separated by a comma. You can open this file using whatever editor you prefer e.g. notepad, excel. This can also be imported into a database.
- TSV – TSV means Tab Separated Value. The output is just like CSV except that there is a tab between each data field instead of a comma. The data can be opened with notepad, excel or can be imported into a database.
- TSV for Excel – Is very similar to TSV
- PDF – The output in this case is a PDF file. Use this option if you want a static snapshot and don’t want anyone to mess with the data
For Exporting, choose the format you want from the drop down box and you will see the report in the format you chose.
With the email option you can set the email to be a onetime event or a recurring email that goes out Daily, Weekly, Monthly or Quarterly. Just like Export function it also allows you to email the data in 4 formats, CSV,TSV, TSV for Excel and PDF.
Note: When you use these options, the reports that will be exported or emailed will have the same settings e.g. row count, filters etc. that you see on your screen.