Google-Analytics-export-to-CSV is a straightforward, command-line tool for getting data out of Google Analytics (via the API) and into a CSV file, so you can open it in your favourite analytics program.

For an introduction, see here. For instructions on how to use the tool to run queries and extract data, see here. The program can be downloaded here. It is packaged as a ZIP file. It only needs to be unzipped before it can be used at the command line.

The program requires Java to run. If you do not have Java runtime environment installed, you will need to install it.  The following is a step-by-step guide to install Google-Analytics-export-to-CSV (incl. Java if necessary) and run your first query:

1. Check if you have the Java Runtime Environment installed

If you’re running an Apple Mac, chances are you already have the Java runtime environment on your machine, as Apple kindly bundles this with all Mac’s. If you want to check, open up the Terminal (go to Applications, and then open Utilies. The Terminal can be found there.) Double click on the terminal and type java at the command prompt. You should see something like the following:

If you are running a Windows machine, you may not have Java installed. To check:

1. Open the Windows PowerShell
   • Click on the Start Menu and select “All Programs”
   • Open the “Accessories” folder
   • Select “Windows PowerShell”
2. Type java at the command line and press enter. If Java is installed you should see something like the following screen shot. If you receive an error, it means Java is probably not installed on your machine: