Back to Kit in Excel
SheetXAI logo
Kit logo
Kit · Excel Guide

Export All Kit Subscribers with Tags and Custom Fields to an Excel Workbook

The Scenario

You are a creator migrating your 12,000-subscriber Kit list to a new email platform. You need a complete export — email, first name, created date, subscription status, all tags as a comma-separated string, all custom field values — in a single Excel workbook.

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
  • You export a separate tag CSV
  • You try to VLOOKUP the two CSVs in Excel and spend an afternoon on it
  • Custom fields are in a third export
  • Three days later you are still reconciling three files and the migration 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 detail and writes every field into a single table in the workbook.

Open the SheetXAI sidebar and type:

Fetch all subscribers from my Kit account and write each one into this workbook. 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 with field names as column headers.

SheetXAI calls Kit's subscriber list API with full details, paginates through all 12,000 records, and writes the complete table to the workbook. One prompt, 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
  • Created date — for migration prioritization logic
  • 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 workbook tab means no reconciliation work. Your new platform's import wizard maps columns directly.

What If the Data Is Not Quite Ready

Twelve thousand subscribers from a four-year-old account will have edge cases. SheetXAI handles them inline.

When you only want active subscribers

Fetch all Kit subscribers with status "active" only. Write email, subscriber ID, first name, created date, tags, and all custom field values — with field names as headers — into this workbook.

When you need tags as separate columns instead of a comma-separated string

Fetch all Kit subscribers. Write email in column A and first name in column B. Create one column per unique tag — with the tag name as the 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

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.

When you want the full migration package: export, QC summary, and migration notes in one pass

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, count with no tags, count with no custom fields, 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 quality issues, and write the migration notes in one prompt.

Try It

Get the 7-day free trial of SheetXAI and open a blank workbook, 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 an Excel workbook or the Kit in Excel overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more