---
title: Using Excel with SiteSpect's Data Export
description: SiteSpect has a useful Data Export feature that allows you to export any of the data that SiteSpect collects. You can use the exported data in a variety of third-party applications to further analyze
---
[Skip to content](https://doc.sitespect.com/knowledge/using-excel-with-sitespects-data-export#main-content)
English
Show submenu for translations
- [A/B Testing](https://www.sitespect.com/testing-and-experimentation/)
- [Personalization](https://www.sitespect.com/personalization-targeting/)
- [Recommendations](https://www.sitespect.com/recommendations/)
Open main navigation
Close main navigation
- [A/B Testing](https://www.sitespect.com/testing-and-experimentation/)
- [Personalization](https://www.sitespect.com/personalization-targeting/)
- [Recommendations](https://www.sitespect.com/recommendations/)
- English
Show submenu for translations
How can we help you?
- There are no suggestions because the search field is empty.
1. [Knowledge Base](https://doc.sitespect.com/knowledge?hsLang=en)
2. [Analyze](https://doc.sitespect.com/knowledge/analyze?hsLang=en)
3. [Data Export and Integration](https://doc.sitespect.com/knowledge/analyze?hsLang=en#data-export-and-integration)
# Using Excel with SiteSpect's Data Export
SiteSpect has a useful [Data Export](https://doc.sitespect.com/knowledge/exporting-data?hsLang=en) feature that allows you to export any of the data that SiteSpect collects. You can use the exported data in a variety of third-party applications to further analyze site visits. Some additional information may make it easier for you to use this data in Microsoft Excel.
#### What Happens in Excel?
Make an export file, following the instructions in [Data Export](https://doc.sitespect.com/knowledge/exporting-data?hsLang=en). Then open the resulting file using Excel.
In some cases, for example, if one of the cells in the file contains data for more than one entry, the entries may look like one entry since they are enclosed in quotes.
In the image below, you can see two entries that are surrounded by quotes that contain only numbers, commas, and decimal points. For entries such as those within the red rectangles in the following image, you want to signify that you have multiple entries for this column, but by default, Excel transforms the multiple entries in the column into a single number.
When Excel imports such data it uses automatic formatting, which does not know that there is more than one number within the quotes. It may turn such items into a very large number, such as the one shown in the following image. In cell R8390, Excel has transformed what should be more than one number, i.e., the data within the quotes in the red rectangle on the right above, into one very large number.
#### How to Solve This
There is a way to properly import data exported by SiteSpect while maintaining the integrity of the data. Excel has a built-in utility that allows you to tell it how to treat column data in order to preserve data integrity.
To import SiteSpect's data into Excel:
1. Export data from SiteSpect. When you perform the export, use the following options. Refer to the topic, [Exporting Data](https://sitespect.force.com/onlinehelp/s/article/Data-Export-603020035?r=28&ui-comm-runtime-components-aura-components-siteforce-qb.Quarterback.validateRoute=1&ui-communities-components-aura-components-forceCommunity-richText.RichText.getParsedRichTextValue=1&ui-communities-components-aura-components-forceCommunity-seoAssistant.SeoAssistant.getSeoData=1&ui-force-components-controllers-recordGlobalValueProvider.RecordGvp.getRecord=1&ui-self-service-components-controller.ArticleTopicList.getTopics=1&ui-self-service-components-controller.ArticleView.getArticleHeaderDetail=1) for details on how to do this.
- Text File: Comma Separated Values (CSV)
- Double-quote (") Field Values
- LF (Line Feed)
1. Once you are done with the export, do not open the CSV file.
2. Launch Excel and create a new empty spreadsheet.
3. Select the **Data** ribbon and in the **Get External Data** section of that ribbon, click **From Text**.
4. Navigate to the CSV file and click **Import**. Excel launches its Text Import Wizard, which allows you to tell Excel what type of data you are exporting. It's this part of the process that will preserve the integrity of your data.
1. In the **Original Data Type** section of Step 1 of the wizard, select **Delimited** and click **Next**.
2. Next, specify how the data is delimited. Select **Comma** and make sure all the other boxes in the **Delimiters** section of the page are blank. In the Text Qualifier drop-down, select double-quotes (**"**). Click **Next**.
1. Scroll through the columns of data. For each column that Excel may possibly format incorrectly, select the column and then click the **Text** button, as in the following image.
1. Click **Finish** when you are done.
- [Get Started](https://doc.sitespect.com/knowledge/get-started?hsLang=en#main-content)
- [SiteSpect Support](https://doc.sitespect.com/knowledge/get-started?hsLang=en#sitespect-support)
- [Overview Information](https://doc.sitespect.com/knowledge/get-started?hsLang=en#overview-information)
- [Intro to SiteSpect](https://doc.sitespect.com/knowledge/get-started?hsLang=en#intro-to-sitespect)
- [Account Setup](https://doc.sitespect.com/knowledge/get-started?hsLang=en#account-setup)
- [Artificial Intelligence](https://doc.sitespect.com/knowledge/get-started?hsLang=en#artificial-intelligence)
- [Dashboard](https://doc.sitespect.com/knowledge/dashboard?hsLang=en)
- [Build](https://doc.sitespect.com/knowledge/build?hsLang=en#main-content)
- [Setting Up a Campaign](https://doc.sitespect.com/knowledge/build?hsLang=en#setting-up-a-campaign)
- [Create a Client-Side Campaign](https://doc.sitespect.com/knowledge/build?hsLang=en#create-a-client-side-campaign)
- [Create a Server-Side Campaign](https://doc.sitespect.com/knowledge/build?hsLang=en#create-a-server-side-campaign)
- [Metrics](https://doc.sitespect.com/knowledge/build?hsLang=en#metrics)
- [Audiences](https://doc.sitespect.com/knowledge/build?hsLang=en#audiences)
- [Triggers](https://doc.sitespect.com/knowledge/build?hsLang=en#triggers)
- [Variations](https://doc.sitespect.com/knowledge/build?hsLang=en#variations)
- [Traffic Management](https://doc.sitespect.com/knowledge/build?hsLang=en#traffic-management)
- [Preview](https://doc.sitespect.com/knowledge/build?hsLang=en#preview)
- [Factors](https://doc.sitespect.com/knowledge/build?hsLang=en#factors)
- [Advanced Settings](https://doc.sitespect.com/knowledge/build?hsLang=en#advanced-settings)
- [Omnichannel](https://doc.sitespect.com/knowledge/build?hsLang=en#omnichannel)
- [Regular Expressions (Regex)](https://doc.sitespect.com/knowledge/build?hsLang=en#regular-expressions-regex)
- [WATTS](https://doc.sitespect.com/knowledge/build?hsLang=en#watts)
- [Recommendations](https://doc.sitespect.com/knowledge/build?hsLang=en#recommendations)
- [Monitor](https://doc.sitespect.com/knowledge/monitor?hsLang=en)
- [Analyze](https://doc.sitespect.com/knowledge/analyze?hsLang=en#main-content)
- [Data Export and Integration](https://doc.sitespect.com/knowledge/analyze?hsLang=en#data-export-and-integration)
- [SiteSpect Reports](https://doc.sitespect.com/knowledge/analyze?hsLang=en#sitespect-reports)
- [Site](https://doc.sitespect.com/knowledge/site?hsLang=en#main-content)
- [Tools](https://doc.sitespect.com/knowledge/site?hsLang=en#tools)
- [Configuration](https://doc.sitespect.com/knowledge/site?hsLang=en#configuration)
- [Developers](https://doc.sitespect.com/knowledge/developers?hsLang=en#main-content)
- [API Reference](https://doc.sitespect.com/knowledge/developers?hsLang=en#api-reference)
- [Code Samples](https://doc.sitespect.com/knowledge/developers?hsLang=en#code-samples)
- [Tips & Tricks](https://doc.sitespect.com/knowledge/developers?hsLang=en#tips-tricks)
- [Mobile](https://doc.sitespect.com/knowledge/mobile?hsLang=en)
- [Implementation, Deployment, and Security](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#main-content)
- [How does SiteSpect work with CDNs?](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#how-does-sitespect-work-with-cdns)
- [Single Tenant Implementations](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#single-tenant-implementations)
- [Security Features](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#security-features)
- [Deployment and Implementation Overview](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#deployment-and-implementation-overview)
- [SiteSpect Engine & Admin API](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#sitespect-engine-admin-api)
- [Third-Party Integration](https://doc.sitespect.com/knowledge/third-party-integration?hsLang=en#main-content)
- [Google](https://doc.sitespect.com/knowledge/third-party-integration?hsLang=en#google)
- [Zuko](https://doc.sitespect.com/knowledge/third-party-integration?hsLang=en#zuko)
- [Troubleshooting](https://doc.sitespect.com/knowledge/troubleshooting?hsLang=en)
- [Releases](https://doc.sitespect.com/knowledge/releases?hsLang=en#main-content)
- [Superfresh](https://doc.sitespect.com/knowledge/releases?hsLang=en#superfresh)
- [Feedback](https://doc.sitespect.com/knowledge/feedback?hsLang=en)
- [A/B Testing](https://www.sitespect.com/testing-and-experimentation/)
- [Personalization](https://www.sitespect.com/personalization-targeting/)
- [Recommendations](https://www.sitespect.com/recommendations/)
[](http://monetate.com)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, Monetate