Early Access Trials Started: contact support@analyticsedge.com with feedback or assistance

Installation

SPECIAL INSTRUCTIONS DURING EARLY ACCESS

The early release currently contains connectors for Google Analytics, Google Ads and Google Search Console only. The rest of the connector are coming soon…

On a Windows PC, run the AppInstaller here:
https://www.analyticsedge.com/downloads/AnalyticsEdgeApp.appinstaller

Run the installer. The App should install and launch.

On a Mac, run the Package file here:
https://www.analyticsedge.com/downloads/AnalyticsEdgeApp-0.9.19.0.pkg

Run the installer. The App should install.

The Analytics Edge Desktop App is a standalone application that brings the capabilities of the Analytics Edge Add-in for Excel to Google Sheets and Excel files on both PC and Mac computers.

More →

Most recent release listed first. Install latest release over previous release should update existing installation saved credentials and settings.

2023-05-25:  v0.9.20.0 – added Bing WebmasterTools and Microsoft Ads connectors.  Now only shows Google Sheets files and folders created with the App (Google permissions restriction).

2023-05-15:  v0.9.19.0 – fixed a problem preventing creation of new Google Sheets folders and files

2023-05-11:  v0.9.18.0 – properly handle internationalization for Google Sheets and user interface (date pickers)

2023-05-09:  v0.9.17.0 – general functionality patches

2023-04-29:  v0.9.16.0 – initial public release; Google Ads, Google Analytics, Google Search connectors only

When you open a file, the App interface mimics a typical spreadsheet application, with a menu bar, a strip to display or edit cell contents, a worksheet display area, and a task pane area.

More →

With this option, you can record a sequence of functions that can easily be edited and refreshed. Macros are created and edited using the Task Pane located to the right of the sheet. More →

Choosing the Mode on the Analytics Edge ribbon lets you decide if you want a macro function or connector function to start an Analytics Edge Macro, a Quick Query, or simply run the function once (Interactive). More →

Available only for connector queries, selecting this option targets a new, refreshable query to be written to the selected worksheet/cell. After the query runs you will be presented with optional Quick Functions wizard. Intermediate results are visible in the ‘ᴁ Step Results’ worksheet behind the wizard. When you are ready, click the Write to Worksheet button to write the results to the originally selected worksheet/cell location. More →

Append a previously saved table, or the contents of a worksheet in the same workbook, to the current table in memory. More →

Append to the existing data in a worksheet, aligning columns to match. More →

Arrange and/or rename the columns in a table. More →

This Analytics Edge wizard lets you perform typical math calculations without using formulas, including a number of series calculations across rows or down columns. More →

Combine two sets of data, merging the values from a worksheet or previously named table. This is generally used with two similar data sets, totalling the numbers, retaining the most recent date, and/or preserving a list of category values. More →

This Analytics Edge wizard is used to compare the current table with another, computing the difference between matching rows. More →

This Analytics Edge wizard is used to convert columns from one data type (text, number, or date) into another. It can also convert to a variant of the same type, like converting dates to first of the month. Typically used to force imported data into the correct type (such as dates with odd formats), it can also be used to convert dates and numbers into specific formats for reporting purposes. More →

Analytics Edge supports Microsoft .NET Framework date format codes which are slightly different from Excel date format codes. The common variants are listed below, but see the references at the end for a full listing. More →

This Analytics Edge widget recognizes duplicate rows in your data and lets you choose whether to keep them, remove them or combine them. More →

This Analytics Edge wizard lets you construct one or more filters to be applied to the current table. Filters can be combined using And / Or logic, and you can choose to remove or keep the matching rows. More →

This Analytics Edge wizard inserts a column with an Excel formula, giving you full access to the spreadsheet application’s advanced functions. It is evaluated in the spreadsheet AFTER you write it to a worksheet, so it should be followed by a Write to Worksheet function. More →

This Analytics Edge wizard lets you add a category or group column based on the value in one of the other data columns. More →

Typical uses include combining name or address components into a single column for uploading into a database. More →

This Analytics Edge wizard lets you quickly lookup values from another Table or Worksheet that share an index column with the current table. More →

This Analytics Edge wizard is used to keep or remove rows based on whether matching row values exist in another table or worksheet. More →

This Analytics Edge wizard is used to pivot a column of data similar to Excel’s PivotTable. If you are pivoting by date, you can also select the date range and automatically fill in any missing values. More →

Following a Quick Query, the Quick Functions wizard allows you to Pivot, Arrange, Sort or Filter your data as well as provides options to Write the results. More →

This Analytics Edge wizard is used to convert the selected column into a number representing either the rank order or it’s percentile, decile or quartile position. More →

This Analytics Edge wizard allows you to import a text file into a table. It accepts both delimited files as well as fixed-width fields. More →

Read a worksheet into a table in memory. More →

This wizard converts the current macro into a Repeating Macro. Repeating macros allow you to load a tables of values from a worksheet to be used as Analytics Edge named ranges while running the rest of the macro. More →

This Analytics Edge wizard lets you replace text in selected columns. It supports the usual * and ? wildcard, as well as regular expressions. More →

This wizard allows you to run Analytics Edge macros, Excel VBA macros, or Windows commands from your macro. It also allows your to set criteria (Run If…) to determine whether to run or not. More →

This wizard lets you save an Excel workbook copy or your report, and optionally email it to someone. Email options include SMTP email or Google Gmail. More →

This Analytics Edge wizard lets you sort the data using specific sorting rules or generically sort all numeric columns. More →

This Analytics Edge wizard lets you split a text column into several columns. You can split on a delimiter, a fixed-width sequence, or into smart name columns. More →

This Analytics Edge wizard allows you to subtotal a table based on unique values in selected columns. More →

This Analytics Edge wizard lets you save the current table, and switch back to it or reference it later in the macro. It can also assign Analytics Edge range names to all the columns. More →

This Analytics Edge wizard lets you keep or remove a specific number of the top or bottom rows. More →

This Analytics Edge wizard is used to create a numeric aggregate row or column, like Total or Average. You can choose to aggregate only the first or last group of numeric rows or columns, and position the results before or after the numeric data, or to remove the original (now aggregated) data completely. More →

This wizard is used to transpose (swap) rows with columns in the current table. More →

This Analytics Edge wizard is used to perform a reverse pivot operation, converting multiple columns of data into two; one with the original column name and the other with the value. More →

This Analytics Edge wizard lets you update the current table from entries with matching rows in another table or worksheet. More →

This Analytics Edge wizard lets you write the current table to a delimited text file, specifying the format to be used for dates. More →

Write to worksheet writes the current table to a selected worksheet location. More →