Analytics Query Tool - Excel IQY Files

Overview

Excel IQY files are supported on the Mac and Windows, and are used to dynamically import Google Analytics data through ShufflePoint into an Excel cell range. These cell ranges can then be bound to charts and formatted tables. Spreadsheets built with IQY files can be shared without sharing the IQY file.

If you are in a mixed Windows & Mac environment, then use the Mac IQY file since it is also compatible with Excel for Windows.

For detailed instructions, see Quick Start - Google Analytics with Excel using IQY Files.

“Place query in” setting

This setting specifies if the current query should be added to the generated IQY file.

Spreadsheet: Use this approach to maintain queries within the spreadsheet. This approach has the advantage of having the queries visible in the spreadsheet. This is in most cases the preferred approach.

IQY File: The query will be embedded within the IQY file. Use this approach if your query exceeds the 256 character limit of an IQY parameter.

Related Links

• Analytics Query Language (AQL)
• Quick Start - Google Analytics with Excel® using IQY Files
• How to create Web query files for use with Excel for Mac
• How to create Web query files for use with Excel for Windows

Generic IQY file downloads

• for Excel on Windows (save to 'My Document/My Data Sources' *)
• for Excel on Macs (save to 'Microsoft Office X/Office/Queries' *)

* Or save in the directory that Excel defaults to when adding Web Queries. Within Excel click Data / Import External Data / Import Data and note the location.