--- title: "Transfer Subscribers Between Export and Import Lists" slug: "transfer-subscribers-between-export-and-import-lists" description: "Learn how to convert and format exported subscriber lists for successful import using Excel or a text editor." updated: 2025-12-16T18:12:13Z published: 2025-12-16T18:12:13Z canonical: "www.civicplus.help/transfer-subscribers-between-export-and-import-lists" --- > ## Documentation Index > Fetch the complete documentation index at: https://www.civicplus.help/llms.txt > Use this file to discover all available pages before exploring further. # Transfer Subscribers Between Export and Import Lists When you **export** a **Subscriber list** from a module other than **Subscriber Management**, the exported file is a tab-delimited .TXT file. The **Import Subscribers** function requires a .TXT or .CSV file that is comma-delimited and requires fewer columns than the exported file. This article will show you how to modify the file that you obtained with the **Export** function so that it can properly import subscribers as well. > [!NOTE] > Important Notes: > > - This article uses **Microsoft Excel** for the instructions. > - You can also complete this process with a text editor, but a spreadsheet application makes the process much easier. ## Instructions 1. Open the .CSV file that you obtained with the **Export Subscribers** function 2. **Delete** the fourth column (should only be populated with **OK**)![A Microsoft Excel file with the options menu expanded and the Delete option highlighted for Column D.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Microsoft%20Excel%20Delete%20Column%20-%20MWC.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A51%3A03Z&se=2026-11-22T14%3A51%3A03Z&sr=b&sp=r&sig=cfKK%2Fu2N2sCYtcRQGCEQb3Bg5CiiPTH9PcBwsALsJfM%3D) 3. Select **File**![The File menu option of Microsoft Excel, highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Microsoft%20Excel%20File%20Menu%20Option%20-%20MWC.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A51%3A03Z&se=2026-11-22T14%3A51%3A03Z&sr=b&sp=r&sig=7e27ODPxpAsEwGwpS7YS5oN1sSN8KXrK%2BGXMszdJWxs%3D) 4. Select **Save As**![Microsoft Excel on the File screen with the Save As option highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Microsoft Excel Save As - MWC.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A51%3A03Z&se=2026-11-22T14%3A51%3A03Z&sr=b&sp=r&sig=Kzv1N6KBWt3Odzvpo0RUC9jTadKgyd0JPUtjCZx70no%3D) 5. Change the file type to **CSV (Comma-delimited) (*.CSV)**![The Save As screen of Microsoft Excel with the file type menu set to CSV (Comma delimited) (*.csv).](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Microsoft%20Excel%20Save%20As%20CSV%20-%20MWC.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A51%3A03Z&se=2026-11-22T14%3A51%3A03Z&sr=b&sp=r&sig=XpvEtfd2S26QjdRZDqVC4STfebqpmukGZCWTQbm2tfk%3D) 6. Click **Save**![The Save As screen of Microsoft Excel with the Save button highlighted.](https://cdn.us.document360.io/17dc564a-8310-4f61-b929-1bd73b36e158/Images/Documentation/Microsoft%20Excel%20Save%20As%20Save%20Button%20-%20MWC.png?sv=2026-02-06&spr=https&st=2026-11-22T13%3A51%3A03Z&se=2026-11-22T14%3A51%3A03Z&sr=b&sp=r&sig=ZXVSB0cowqeb9pEfplaYauhdwYhF43DappUyz6noGos%3D) 7. Use the .CSV file to import subscribers. ## Resources - How to Export Subscribers in: - [Bid Postings](/municipal-websites-central/docs/export-bid-subscribers) - [Calendar](/municipal-websites-central/docs/export-calendar-subscribers) - [Notify Me](/municipal-websites-central/docs/export-notify-me-subscriptions) - How to Import Subscribers in: - [Agenda Center](/municipal-websites-central/docs/import-agenda-center-subscribers) - [Alert Center](/municipal-websites-central/docs/import-alert-center-subscribers) - [Bid Postings](/municipal-websites-central/docs/import-bid-subscribers) - [Blog](/municipal-websites-central/docs/import-blog-subscribers) - [Calendar](/municipal-websites-central/docs/import-calendar-subscribers) - [Jobs](/municipal-websites-central/docs/import-job-subscribers) - [News Flash](/municipal-websites-central/docs/import-subscribers-into-news-flash) - [Notify Me](/municipal-websites-central/docs/import-subscribers-to-notify-me) Text File Document. Comma-separated Value.