The Scenario
You are a creator. You built your Kit list over four years and it now has 12,000 subscribers. You have decided to migrate to a different email platform.
You need a complete export of every subscriber — email, first name, created date, subscription status, all tags as a comma-separated string, and all custom field values — in a single Google Sheet. Kit's built-in export gives you a CSV, but it does not include tags and custom fields in a format that maps cleanly to your new platform's import spec.
The bad version of this migration:
- You export Kit's subscriber CSV
- You realize tags are not included in the export
- You export a separate tag-assignment CSV from Kit
- You try to VLOOKUP the two CSVs together in Sheets and spend an afternoon on it
- You realize custom fields are in a third export
- Three days later you are still reconciling three CSVs and your migration launch date has slipped.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI calls Kit's subscriber list API with full subscriber detail and writes every field into a single table in the sheet.
Open the SheetXAI sidebar and type:
Fetch all subscribers from my Kit account and write each one into this sheet. Include email in column A, subscriber ID in column B, first name in column C, subscription status in column D, created date in column E, a comma-separated list of all their tags in column F, and all custom field values starting from column G (one custom field per column, with the field name as the column header).
SheetXAI calls Kit's subscriber list API with full details, paginates through all 12,000 records, and writes the complete table to the sheet. One prompt, one sheet, migration-ready.
What You Get
A complete subscriber export with every field your new platform needs:
- Email, subscriber ID, first name — the core identity columns
- Subscription status — active, unsubscribed, or bounced, so you know who to import
- Created date — useful for migration logic (you may want to import recent subscribers first)
- Tags as a comma-separated string — in a format most platforms can split during import
- Custom fields as columns — one per field, with field names as headers
The full export in a single sheet means no reconciliation work. Your new platform's import wizard maps columns directly from this table. No VLOOKUP, no three-CSV merge.
If you only want to migrate active subscribers, tell SheetXAI to filter to status = active before writing. If you want to exclude subscribers who have never opened an email, add that filter too.
What If the Data Is Not Quite Ready
Twelve thousand subscribers exported from a four-year-old account will have edge cases. SheetXAI handles them inline.
When you only want active subscribers
Unsubscribed and bounced subscribers should not be migrated.
Fetch all Kit subscribers with status "active" only. Write email in column A, subscriber ID in column B, first name in column C, created date in column D, tags as a comma-separated string in column E, and all custom field values from column F onward with field names as headers.
When you need tags as separate columns instead of a comma-separated string
Your new platform's import requires one column per tag with a "1" or "0" indicating whether the subscriber has it.
Fetch all Kit subscribers. Write email in column A and first name in column B. Then create one column per unique tag across all subscribers — with the tag name as the column header — and write "1" if the subscriber has that tag and "0" if they do not. Include all custom field values after the tag columns.
When you need to split the export across multiple tabs for large list handling
Twelve thousand rows may be slow to process in one pass.
Fetch all Kit subscribers. Write the first 4,000 rows to the Batch 1 tab, rows 4,001 through 8,000 to the Batch 2 tab, and rows 8,001 onward to the Batch 3 tab. Use the same column structure in each tab: email, first name, status, created date, tags, custom fields.
When you want the full migration package: export, quality check, and migration notes in one pass
Before handing the sheet to your platform team, you want a QC summary.
Fetch all Kit subscribers and write the full table — email, subscriber ID, first name, status, created date, tags, custom fields — into the Export tab. In the QC tab, write: total subscriber count, count by status (active, unsubscribed, bounced), count with no tags, count with no custom fields populated, count of duplicate emails if any, and a two-sentence note on any data quality issues the migration team should know about.
The pattern: export the full list, flag the quality issues, and write the migration notes in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask SheetXAI to export your full Kit subscriber list into it. The Kit integration is included in every SheetXAI plan. For subscriber management workflows, see how to bulk import subscribers into Kit from a sheet or the Kit in Google Sheets overview.