---
title: "How can I efficiently separate customer emails exported from ServiceTitan into Excel cells?"
slug: "how-can-i-efficiently-separate-customer-emails-exported-from-servicetitan-into-e"
updated: 2026-10-15T01:23:22Z
published: 2026-10-15T01:23:22Z
canonical: "help.servicetitan.com/how-can-i-efficiently-separate-customer-emails-exported-from-servicetitan-into-e"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.servicetitan.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How can I efficiently separate customer emails exported from ServiceTitan into Excel cells?

## Introduction

Exporting customer emails from ServiceTitan into Excel can be tricky. This article shows how to make it easier.

## Problem

When exporting reports to Excel from ServiceTitan, all customer emails for an account are placed in the same cell. This makes the data hard to use with other programs. How can this be fixed without manually editing thousands of records?

## Solution

### Workflow Summary

To separate customer emails into different cells in Excel, follow these steps.

### Separate customer emails

1. In MS Excel, use the *Text to Columns* feature to Split the emails into separate cells. For more, see [Split text into different columns with the Convert Text to Columns Wizard](https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7).
2. If you have Marketing Pro, build your audience in the Audience Builder. For more, see [Manage Marketing Pro Audiences](/construction/docs/manage-marketing-pro-audiences).
3. Export that list to Excel. Each cell will contain one email address.

Split determines how much credit each technician is getting for the job. For example: If two technicians perform work on a job, the split could be an even 50%-50%, or it could be 75%-25% if the first technician did a bulk of the work. By default 100% of the technician split will go to the first technician assigned to the job.

[Learn more →](https://help.servicetitan.com/docs/servicetitan-glossary) · [See the full glossary →](https://help.servicetitan.com/docs/glossary-overview)

ServiceTitan's integrated marketing automation platform for email, SMS, direct mail, and digital ad campaigns.

**What it does:** Drives new customer acquisition and repeat revenue by automating targeted campaigns across multiple channels — all tied to actual job revenue.

**Also called:** ST Marketing, Marketing automation

**Tags:** Marketing Pro

[See the full glossary →](https://help.servicetitan.com/docs/glossary-overview)