Export Radar Users and Geofence Membership to a Excel workbook

The Scenario

A product analyst at a location-based app company got a request from the growth team on a Thursday afternoon: they need all Radar user records exported to Excel — user ID, external user ID, last seen timestamp, and current geofence membership — segmented by region, by Monday. The data is the input to the quarterly engagement report.

The bad version:

• Log into Radar's dashboard, navigate to Users. The list shows 50 users per page and there are 2,000 users in the project. That is 40 pages.
• Start copying user IDs and geofence data from the dashboard by hand. By page 4 the pattern is clear: this is going to take the rest of the week.
• Submit a data export request to the engineering team. They're in sprint review and this gets scoped as a next-sprint ticket. That's two weeks away, not Monday.

There is no good path here except the one that doesn't involve waiting or manual copying.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent inside your Excel workbook. It calls Radar's user list API, handles all 40 pages, and writes every user record into the workbook with the fields the growth team needs.

Fetch all Radar users currently inside the geofence with tag premium-zone and paste their user IDs, device IDs, and last location coordinates into this Excel workbook

What You Get

• One row per Radar user matching the filter, all pages resolved
• User ID, device ID, and last known coordinates in separate columns
• The workbook is ready for the growth team's regional segmentation immediately

What If the Data Is Not Quite Ready

You need all users, not just those in a specific geofence

List all Radar users and write each user's Radar ID, external user ID, last seen timestamp, and current geofence tags to columns A through D of this Excel workbook

You need to join Radar user IDs to an existing subscriber table in Sheet2

List all Radar users and write Radar ID and external user ID to columns A and B — then match external user ID against the subscriber table in Sheet2 (external ID in A, plan tier in B) and write the plan tier to column C

Last-seen timestamps need to be formatted as dates for the pivot

List all Radar users and write Radar ID, external user ID, and last seen timestamp to columns A through C — format the timestamp in column C as YYYY-MM-DD date only

Export all users, segment by geofence membership, and add a regional summary table in one pass

List all Radar users and write Radar ID, external user ID, last seen timestamp, and geofence tags to columns A through D — then add a summary table starting at row 2005: count of users per geofence tag, sorted by count descending, with each tag's percentage of total users

The summary table is the regional breakdown the growth team actually needs.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook — ask it to export all Radar users with geofence membership and last-seen data into the workbook. For trip-level data, see exporting active Radar trips, or return to the Radar integration overview.