How to Export Google Analytics Account List
Managing multiple Google Analytics accounts feels a bit like being an air traffic controller. If you're an agency, consultant, or part of an in-house team overseeing various brands, you need a clear view of every property you manage. This article will show you a few practical ways to export your Google Analytics account list, so you can get a bird's-eye view, improve your workflow, and stay organized.
Why Export Your Google Analytics Account List?
Before jumping into the "how," it's helpful to understand the "why." Pulling a list of your GA accounts isn't just a technical exercise, it's the foundation for better management and strategy. An organized master list helps you move from reacting to data to proactively managing your analytics assets.
Here are a few common scenarios where an exported list is incredibly valuable:
- Agency & Consultant Audits: Keep a master log of all client accounts. You can track which ones are still on Universal Analytics (UA) versus GA4, verify you have the correct access levels, and streamline your client onboarding and offboarding processes.
- Centralized Governance: For businesses with multiple websites, apps, or sub-brands, a central list helps maintain control over your data environment. It allows you to quickly see all properties at a glance, ensuring consistent naming conventions and user permissions.
- Migration & Cleanup Projects: When migrating from Universal Analytics to Google Analytics 4, having a comprehensive list is the first step. You can use it as a checklist to track migration progress, identify old or unused properties that can be archived, and ensure nothing gets lost in the transition.
- Streamlined Reporting: Instead of bouncing between different GA accounts to pull monthly numbers, use your master list as a dashboard directory. This simplifies locating the right property when you need to pull specific insights quickly.
Method 1: The Manual Copy-and-Paste (The Quick & Simple Way)
Google Analytics doesn't offer a straightforward "Export Account List" button in its user interface. Fortunately, a simple copy-and-paste method from your browser works perfectly for most day-to-day needs, especially if you manage a dozen or so accounts.
Step-by-Step Instructions
This method takes less than two minutes and requires no special tools other than your web browser and a spreadsheet program.
1. Navigate to the Admin Panel Log in to your Google Analytics account. In the bottom-left corner of the screen, click on the Admin gear icon.
2. Open the Account Selector At the top of the Admin page, you'll see three columns: Account, Property, and View (for UA) or Data Streams (for GA4). At the very top of the "Account" column, click the dropdown menu. This will display a full list of every Google Analytics account you have access to.
3. Copy the Full List This seems wonderfully simple, but it works. With the dropdown menu open, click and drag your mouse from the name of the first account down to the last. Once all the accounts are highlighted, right-click and select "Copy" or use the keyboard shortcut (Ctrl+C on Windows, Cmd+C on Mac).
4. Paste into a Spreadsheet Open a new Google Sheet or Microsoft Excel file. Click into the first cell (A1) and paste the data (Ctrl+V or Cmd+V). Your list of accounts, complete with their corresponding ID numbers, will appear neatly in the spreadsheet. It might need a tiny bit of cleanup, but most of the work is done.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Pro Tip for Extra Long Lists: Using Browser Developer Tools
If you manage hundreds of accounts, clicking and dragging can be a pain. Here's a slightly more technical but much faster way to grab the entire list using your browser's "Inspect" feature.
- Open the Account List: Follow steps 1 and 2 above to open the full list of your GA accounts.
- Inspect the Element: With the list still open, right-click anywhere on the list of accounts and select "Inspect" from the context menu. This will open your browser's developer tools panel, showing the website's underlying HTML code.
- Find the Container: In the developer tools panel, the line of code corresponding to the list you right-clicked on will be highlighted. Look for a parent HTML tag that contains the entire list. It's often a tag like
<ul>, (unordered list) or a<div>with a specific class name related to the menu. - Copy the HTML: Right-click on that parent HTML tag and choose "Copy" > "Copy outerHTML". This action copies the entire block of code that generates your list of accounts.
- Clean it Up: Paste this block of HTML into a text editor (like Notepad++, Sublime Text, or VS Code). Many text editors have a "Find and Replace" function that supports regular expressions. Use it to strip out the HTML tags, leaving you with just a clean text list of your account names and IDs. This process turns a monumental copy-paste task into a few clicks.
The manual method is fast and accessible, but it's a one-time snapshot. If your account list changes frequently, you'll need a more automated solution.
Method 2: Using the Google Analytics Management API (The Automated Approach)
For those who are comfortable with a little bit of code or who need to retrieve this list programmatically on a recurring basis, the Google Analytics Management API is your best friend. This method allows you to build a small script that automatically fetches your account list and dumps it right into a Google Sheet.
This approach is perfect for larger agencies or data teams that need to maintain an always-up-to-date directory of analytics properties.
Getting Started with Google Apps Script
Google Apps Script is a cloud-based scripting language that lets you automate tasks across Google Workspace products, including Sheets. It's a great entry point because you don't need to set up a complex development environment, you can write and run code directly from your browser in a Google Sheet.
Here’s a simplified approach to get you started:
1. Create a New Google Sheet Go to sheets.google.com and start a blank spreadsheet. Name it something logical, like "My GA Account Master List."
2. Open the Apps Script Editor In your new sheet, click on Extensions > Apps Script. This will open a new browser tab with the script editor.
3. Enable the Google Analytics API Before your script can talk to Google Analytics, you need to tell Apps Script that you want to use the GA service.
- In the script editor, look for the "Services" section on the left sidebar and click the
+icon. - A dialog box will appear. Scroll through the list and find "Google Analytics API" and "Google Analytics Data API." Add both, and then click the "Add" button. This connects your script to the necessary GA services.
4. Write Your Script Delete any default boilerplate code in the editor and paste the following script:
function list_GA_accounts() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(),
// Clear any existing content
sheet.clear(),
// Set headers
sheet.getRange("A1").setValue("Account Name"),
sheet.getRange("B1").setValue("Account ID"),
sheet.getRange("C1").setValue("Property Name"),
sheet.getRange("D1").setValue("Property ID"),
sheet.getRange("E1").setValue("Property URL"),
let row = 2, // Start writing data from the second row
try {
const accounts = Analytics.Management.Accounts.list().items,
if (accounts && accounts.length > 0) {
for (let i = 0, i < accounts.length, i++) {
const account = accounts[i],
const accountName = account.name,
const accountId = account.id,
const properties = Analytics.Management.Webproperties.list(accountId).items,
if (properties && properties.length > 0) {
for (let j = 0, j < properties.length, j++) {
const property = properties[j],
sheet.getRange(row, 1).setValue(accountName),
sheet.getRange(row, 2).setValue(accountId),
sheet.getRange(row, 3).setValue(property.name),
sheet.getRange(row, 4).setValue(property.id),
sheet.getRange(row, 5).setValue(property.websiteUrl || 'N/A for GA4 App'),
row++,
}
} else {
// For accounts that might not have properties
sheet.getRange(row, 1).setValue(accountName),
sheet.getRange(row, 2).setValue(accountId),
row++,
}
}
} else {
sheet.getRange("A2").setValue("No Google Analytics accounts found."),
}
} catch (e) {
Logger.log('Error: ' + e.toString()),
SpreadsheetApp.getUi().alert('Failed to fetch data: ' + e.message),
}
}5. Run the Script
- Click the "Save" icon (floppy disk).
- From the function dropdown menu at the top, select
list_GA_accounts. - Click the "Run" button.
- The first time you run it, Google will ask for authorization. Review and accept the permissions to let the script access your data.
Once authorized, it will execute. Return to your Google Sheet, and you'll see a populated list of all accounts and properties.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Putting Your Exported List to Work
Getting the list is just the start. Now you can organize it for maximum benefit.
Enhance Your Spreadsheet
Once the data is in Google Sheets, you can add more columns to create a true command center for your analytics properties:
- Client/Project Owner: Which person or team is responsible for this account?
- Status: Is this an "Active," "Archived," or "Monitoring" account?
- Contract End Date: For agencies, this is useful for managing client relationships.
- GA4 Migration Complete?: Use Yes/No or a date to track progress.
- Notes: A catch-all column for reminders or observations, like "Custom event tracking needs review."
Build an Audit Workflow
Use your organized list as a checklist to perform routine health checks. Verify key settings such as:
- Is Enhanced Measurement enabled for GA4 properties?
- Are referral exclusion lists correctly configured?
- Do user permissions reflect current team members?
- Is data retention set to the maximum (14 months) for GA4 explorations?
This habit can prevent many data headaches.
Final Thoughts
Whether you choose the quick copy-paste method or set up an automated script, exporting an organized list of your Google Analytics accounts is key to efficient asset management. It enables you to audit setups, streamline reporting, and keep your analytics properties in order.
Once organized, the next step is analyzing your data without hours of tab-switching. That’s why we built <a href="https://www.graphed.com/register" target="_blank" rel="noopener">Graphed</a>: to connect all your analytics accounts (plus Google Ads, Shopify, Facebook Ads, and more) in one place. Ask in plain English for what you want, and dashboards update in real-time—no manual exports needed.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.