Omnisend is an email and SMS marketing platform built for e-commerce. Its data model centres on contacts, segments, tags, campaigns and automation workflows. The platform has deep Shopify integration, meaning much contact data flows in automatically from connected stores.
This guide covers CSV import, contact export, the Omnisend API and Coefficient for recurring exports to Google Sheets or Excel.
| What data can you import and export from Omnisend? |
| Omnisend supports CSV import of contacts with tags, custom properties and phone numbers. Export covers contact lists with all properties and opt-in status as CSV, plus campaign reports as CSV. Automation workflows and email templates cannot be exported as data. The Omnisend API provides full programmatic access to contacts, campaigns, automation data and reporting. Coefficient connects Omnisend to Google Sheets or Excel for live, auto-refreshing marketing data exports. |
How to import data into Omnisend
Method 1: CSV contact import
- In Omnisend, go to Audience > All Contacts and click Import Contacts.
- Upload your CSV file. Omnisend requires specific column headers — download the Omnisend import template for the correct structure.
- Map columns to Omnisend contact properties: Email or Phone (at least one required), First Name, Last Name, tags and custom properties.
- Set the contact status: subscribed, non-subscribed or unsubscribed.
- Click Import. Omnisend processes the file and emails a summary when complete.
Format requirements:
- File type: CSV with UTF-8 encoding.
- Required field: Email or Phone number. At least one is required.
- Tags: include tags as a pipe-separated list in one column (tag1|tag2|tag3).
- Consent status: set to “subscribed” only for contacts who have explicitly opted in. Setting non-opted contacts as subscribed violates anti-spam regulations.
- Shopify contacts: if using the Shopify integration, contacts sync automatically. Use CSV import for contacts from external sources.
- Cannot import: campaign history, automation enrollment, SMS opt-in history and e-commerce order data cannot be imported via CSV.
Method 2: Omnisend API
The Omnisend API supports programmatic contact creation, tag management and event tracking. Use it for automated contact sync from e-commerce platforms not natively supported by Omnisend, or for custom integration workflows.
How to export data from Omnisend
Method 1: Contact export (CSV)
- Go to Audience > All Contacts in Omnisend.
- Apply segment filters or select a specific list to narrow your contacts.
- Click Export or the download icon. Choose which fields to include.
- Omnisend emails a download link when the export is ready.
What the export includes:
- Included: email, phone, first name, last name, all tags, all custom properties, subscriber status, opt-in date, country.
- Not included: email engagement history (opens, clicks), campaign send history, automation enrollment data.
Method 2: Campaign report export
- Go to Campaigns in Omnisend and open a campaign.
- Click the … menu and select Export Report.
- Download the CSV with campaign metrics: sent, delivered, opened, clicked, unsubscribed and revenue attribution.
Method 3: Coefficient for live, scheduled exports
Omnisend’s native exports are one-time CSV downloads. For marketing teams that need fresh contact counts, segment sizes or campaign performance data in a spreadsheet regularly, Coefficient automates this.
Coefficient connects Omnisend to Google Sheets or Excel. Marketing data refreshes automatically.
- Import contact records, campaign metrics and segment data with field-level selection and audience filters.
- Set auto-refresh so list health and campaign performance reports are always current.
- Turn live Omnisend data into a shareable web dashboard. Coefficient AI dashboards build it in plain English.
How to connect Omnisend to a spreadsheet with Coefficient:
- Install Coefficient from the Google Workspace Marketplace or Microsoft AppSource.
- Open Coefficient from the Extensions menu in Google Sheets, or the add-in menu in Excel.
- Click Import From and select Omnisend. When prompted, enter your Omnisend API key to complete the connection.
- Select the data type (contacts, campaigns, segments), choose fields and apply filters.
- Set a Scheduled Run to refresh data automatically.
Method 4: Omnisend API for programmatic export
The Omnisend API provides access to contact data, campaign statistics, automation reports and e-commerce event data in JSON format. Use it for full account backups, integrating Omnisend data with a BI tool or data warehouse, or building custom reporting on top of Omnisend data.
Import and export method comparison
| Method | Direction | Data covered | Format | Best for |
|---|---|---|---|---|
| CSV contact import | Import | Contacts, tags, custom properties | CSV (UTF-8) | Bulk contact import, migration from another platform |
| Shopify integration sync | Import | Customers, orders, product data | Automatic sync | Continuous e-commerce data sync (no CSV needed) |
| Omnisend API (import) | Import | Contacts, events, cart data | JSON | Automated integrations, custom e-commerce sync |
| Contact export (CSV) | Export | Contacts, tags, properties, status | CSV | One-time list backup or migration export |
| Campaign report export | Export | Campaign metrics and performance | CSV | Reporting on campaign results |
| Coefficient | Export from Omnisend | Contacts, campaigns, segments | Live sync to Sheets or Excel | Recurring exports, live marketing reporting |
| Omnisend API (export) | Export | All contact and campaign data | JSON | Full backups, data warehouse ingestion |
FAQs
Can you import Shopify customer data into Omnisend?
If your Shopify store is connected to Omnisend, customer data syncs automatically — no CSV import needed. For customers not from Shopify, export them from Shopify as CSV, then import into Omnisend via Audience > Import Contacts.
Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.
Get Started
Can you export Omnisend data to Google Sheets automatically?
Yes, with Coefficient. Connect Omnisend, select your data and set a refresh schedule. Contact and campaign data updates in Google Sheets or Excel automatically.
What data format does Omnisend require for contact import?
CSV with UTF-8 encoding. The file must include Email or Phone as the minimum. Download Omnisend’s import template from the import screen for the exact column structure. Tags use a pipe-separated format in a single column.
How do you migrate from Mailchimp to Omnisend?
Export your Mailchimp audience as CSV (Audience > Export Audience). The export includes email, name, subscription status and tags. Import into Omnisend via Audience > Import Contacts. Map the Mailchimp columns to Omnisend properties. Automations and email templates must be rebuilt manually in Omnisend.
Can you export Omnisend campaign reports?
Yes. Open any campaign in Omnisend, click the menu and select Export Report. The CSV includes sent, delivered, opened, clicked, unsubscribed counts and revenue attribution for e-commerce campaigns.
If you need Omnisend marketing data refreshed automatically in a spreadsheet for campaign analysis or list management, try Coefficient free and connect Omnisend in a few clicks.
