The Scenario
You are a product analyst. The data governance review with engineering is Friday. Your Amplitude project has 80 user properties accumulated over three years. Some were set up by the original team and have no documentation. Some may no longer be populated.
You need to pull the full user property list into an Excel workbook — name, type, description, default or custom — so the team can audit it before Friday.
The slow version:
- Open Amplitude, navigate to User Properties in the Data tab
- Page through the list manually
- Copy-paste names and descriptions row by row into the workbook
- Fill in type and default/custom status by hand because the Amplitude export does not format cleanly for Excel
- Three hours in, you have covered 40 of the 80 properties and engineering needs the workbook now.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to Amplitude's User Properties API and writes the full list into the Properties tab in one pass.
Open the SheetXAI sidebar and type:
List all user properties from Amplitude and write property name, type, description, and whether it is a default or custom property into columns A–D of the Properties tab. Add a header row.
SheetXAI calls the Amplitude Data API, pulls all 80 user properties, and writes the structured table into the Properties tab. The governance review has its input by Thursday morning.
What You Get
A complete user property table in the Properties tab:
- Column A — user property name (all 80, one per row)
- Column B — property type (string, number, boolean, array, etc.)
- Column C — property description from Amplitude's data dictionary
- Column D — default Amplitude property or custom property created by your team
Every user property in the project is represented. Blank descriptions in column C are findings, not gaps to fill later.
What If the Data Is Not Quite Ready
Property documentation audits surface problems by design. SheetXAI handles the enrichment in the same prompt.
When you want to flag properties with no description
Missing descriptions are the first thing engineering should fix.
List all user properties from Amplitude and write name, type, description, and default/custom status into columns A–D of the Properties tab. In column E, write "UNDOCUMENTED" for any property where the description is blank. Write the total count of undocumented properties into cell G1.
When you want to separate default properties from custom ones for easier review
The default properties are Amplitude-managed and do not need documentation review.
Pull the complete Amplitude user property list. Filter to custom properties only. Write name, type, and description into columns A–C of the Properties tab. Sort by name ascending.
When you want to cross-reference which properties have no recent data
A property not populated in 90 days is a candidate for deprecation.
List all user properties from Amplitude and write name, type, description, and default/custom status into columns A–D of the Properties tab. Pull each property's last-seen date and add it to column E. Flag any property not seen in the last 90 days with "STALE" in column F.
When you need the full list, missing-description flags, stale flags, and a summary count all in one pass
The governance review template requires the property table and a summary header.
Pull the complete Amplitude user property list and write name, type, description, and default/custom status into columns A–D of the Properties tab. In column E, flag any property where description is blank as "UNDOCUMENTED". Pull last-seen date into column F and flag any not seen in 90 days as "STALE" in column G. Write a summary in cell I1: total properties, total undocumented, total stale.
The pattern: the full audit — list, enrichment, flagging, and summary — happens in one prompt. Engineering gets an actionable document instead of a half-finished copy-paste job.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull the full Amplitude user property list with whatever enrichment the governance review requires. The Amplitude integration is included in every plan. For related workflows, see how to export the event taxonomy for audit or the Amplitude in Excel overview.