The Scenario
You are a CRM manager. You have 800 at-risk users in an Excel workbook on the Risk tab, identified by support ticket count and inactivity. Your team wants to run a targeted campaign in Amplitude — but the cohort does not exist in Amplitude yet. Someone has to upload the user IDs.
That someone is you. Eight hundred rows. Amplitude's CSV import expects a specific column format. You have to format the workbook, export as CSV, upload it, fix any validation errors, re-upload, and name the cohort.
The slow version:
- Format the Risk tab to match Amplitude's CSV import format (user_id column only, specific header name)
- Export the workbook tab as CSV
- Log into Amplitude, navigate to Cohorts, create new cohort from CSV
- Upload, wait for validation, fix format errors, re-upload
- Name the cohort 'High-Churn-Risk Q2 2025'
- Thirty minutes later, one cohort exists.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects directly to the Amplitude Cohort API — no export, no upload form.
Open the SheetXAI sidebar and type:
Take the user IDs in column A of the Risk tab (rows 2–801) and upload them as a new cohort named 'High-Churn-Risk Q2 2025' in Amplitude.
SheetXAI reads the column, calls the Amplitude API, and creates the cohort. You do not leave the workbook.
What You Get
A new Amplitude cohort named 'High-Churn-Risk Q2 2025' containing all 800 user IDs, ready for targeting in campaigns, experiments, and chart segmentation.
The cohort is live immediately. If Amplitude returns a cohort ID, SheetXAI can write it into a cell so you have a record without going back into Amplitude.
Need to add users to an existing cohort instead?
Read my list of 200 Amplitude user IDs from column B of the Risk tab and add them to my existing 'Re-engagement May' cohort.
What If the Data Is Not Quite Ready
User ID lists in workbooks are rarely clean. SheetXAI handles the cleanup and the upload in the same prompt.
When the column has duplicate user IDs
The list was assembled from two data sources and some IDs appear twice.
Deduplicate the user IDs in column A of the Risk tab, keeping only unique values. Upload the deduplicated list as a new cohort named 'High-Churn-Risk Q2 2025' in Amplitude. Write the final unique count into cell C1.
When some rows have blank or invalid user IDs
A few rows in column A are empty or contain placeholder text from an export.
Filter column A of the Risk tab to include only rows where the user ID is a non-empty numeric value. Upload the valid user IDs as a new Amplitude cohort named 'High-Churn-Risk Q2 2025'. Write the number of skipped rows into cell B1.
When the list needs to be split across multiple cohorts by risk tier
Column B contains the risk tier: High, Medium, Low. Each tier should become its own cohort.
Read columns A and B of the Risk tab where column A is user_id and column B is risk_tier. Create three separate Amplitude cohorts: 'High-Churn-Risk Q2', 'Medium-Churn-Risk Q2', and 'Low-Churn-Risk Q2', each containing only the user IDs for that tier. Write the returned cohort IDs into column C next to each tier group.
When you need to filter, deduplicate, upload, and log all in one pass
You want a full audit trail without any manual steps.
Take the user IDs in column A and support ticket counts in column B of the Risk tab. Filter to rows where ticket count is 3 or more. Deduplicate by user ID. Upload the filtered list as a new Amplitude cohort named 'High-Churn-Risk Q2 2025'. Write the returned cohort ID into cell D1 and the final row count into cell D2.
The pattern: list preparation and cohort creation happen in one prompt. No export, no upload form, no manual verification.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of user IDs, then ask it to create or update an Amplitude cohort from the data. The Amplitude integration is included in every plan. For related workflows, see how to export an Amplitude cohort for enrichment or the Amplitude in Excel overview.