eSalesTrack Help Menu
       Getting Started
          New User Guide
          Default Modules
          Contact Manager Template
          Business to Consumer Template
          Business to Business Template
          CRM Lite Template
          CRM Product Manager Template
          CRM Template
          My Information
             Personal Preferences
                Change Password
                Edit Information
          Home Page
             Creating Dashboards
                Creating Widgets
                   Links List
                Publish Dashboard
                Subscribing to Dashboards
             Quick Access
                My Documents
                   Upload Documents
                   Publish Documents
                   Subscribe to Documents
                My Email
                Recycle Bin
          Types of Modules
             Editing Records in eView
             Search eView A-Z
             Creating Reports
             Report Manager
             Edit a Report
             Copy a Report
             Clone a Report
             Publish a Report
             Subscribe to a Report
             Delete a Report
          Creating New Data
             Creating Records
                Primary Records
             Editing Records
             Cloning Records
             Collapse Sections
             What is a view
             Creating a View
             Searching for Records
             Creating Reports from a View
             Creating a View to Show all Records
             Manage Views
                Clone Views
                Copy Views
                Publish Views
                Subscribe to Views
             View Groups
                Editing View Groups
          Manage Data
             Deleting Records
             Recycle Bin
             Activate Records
             Inactive Records
                Activate Records from the Recycle Bin
                Activate Records from the Profile Page
                Inactive Records View
             Permanently Delete Records
                Formatting an Excel Spreadsheet for importing
                Import Troubleshooting
                Import Log
             Creating a Task
             Request Additional Calendars
             Sharing Calendar
             Creating Appointments
             Recurring Appointments
       Email and Marketing
             Creating Document Templates
             Using Document Templates
             Creating Email Tempaltes
             Using Email Templates
             Image Gallery
             Click-Through Links
             Word Plugin
             Add Notification
             Manage Notifications
             Email Settings
                Setting Up Your E-mail in Microsoft Outlook - POP 
                Setting Up Your E-mail in Microsoft Outlook - IMAP 
             Mass Email
                Mass Email Queue
             Sending Emails
             Creating Email Campaigns
             Outlook Plug-in
             Outlook Plug-in Troubleshooting
          Free Daily Training Webinars
          eSalesTrack Advanced Customer Services
          Additional Tabs
          Adding Tasks
          Editing Records
          Finding Records
          Adding Appointments
          Add Module
             Normal Module
             URL Module
             Delete Module
             Stacked View
                Sales Funnel
             View Only Module
          Field Creator
                Creating an eFormula Field
                Formula - Date
                Formula - Text
                Formula - Currency and Numeric
                Formula - Converting
             Creating Fields
                Picture Fields
             Editing Feilds
             Field Creator
          Unassigned Records
          Form Manager
                Creating New Layouts
                Assigning Layouts
                Multi-page Layouts
                   Multi-page Layouts
                   Linear Layout
             Putting Fields on Form
                Adding One to One Fields
                Adding Parent Fields
             Key Fields
             Form Objects
             Additional Tabs
                Activities Tab
                Content Tab
                Email Tab
                Notes Tab
                Team Member Tab
                Deleting Tabs
             Add Mapping
          Portal and Web Forms
             Create a Web Form
             Manage Web Fomrs
             Hidden Fields
             View Relationships
             Mobile Layouts
             Mobile Settings
       My Company Profile
          Company Profile
       Display and Themes
          Change Header
          Change Colors
       Company Information
             Manage Subscriptions
             Delete Subscription
             Creating Roles
             Sharing Records
             Assigning Roles
             Add User
             Reassigning Records
             Manage Users
             Inactivate User


Home > eSalesTrack Help Menu > User > Data > Manage Data > Importing > Formatting an Excel Spreadsheet for importing


Formatting an Excel Spreadsheet for importing

Ready to import a spreadsheet into a Module in eSalesTack? Great! But first, let’s make sure the spreadsheet is formatted correctly. Depending on where you get the spreadsheet from, you may need to do a little formatting to it. If it has any HTML formatting to it, (colors on the header, on lines on the grid, Hyperlinks on email or website), that will need to be reformatted.

To easily do this, click on a cell, click “Ctrl” and “A” at the same time to select all. Then click “Ctrl” and “C” at the same time to copy it all. Then Click the Windows Icon in the top left hand corner (or File if using older versions of Excel) and click “New” to open up a new sheet. .

Click on cell “A1,” (the very first cell intersecting the First Column and Row). Once you are on cell A1, right click and click “Paste Special,” (please note it is Paste SPECIAL, not just normal Paste). Another Menu screen will pop up and click the bullet that says Values, then click “OK”.

Your data should know look like this:

You are now ready to import clean data.

Does your data look like this and you are still having problems? This may be caused Field Level formatting issues.


• Make sure your “Key Field” has data in it for every record. (Please see the Key Field help article if you require clarification on what the Key Field is. It is important you know what your Key Field is before you clean your data for import.)

• If you don’t have data for the Key Field, it is ok to just put “unknown,” or whatever phrase makes sense to you.

• Make sure that if you have email addresses or websites, that you do not have hyperlinks on them. (Should not look like Should look like )

• If you have a date, make sure it is formatted like 1/01/2011, (not Oct. 12 or 10/12).

• If you have a phone number field, make sure it does not have any text letters in it. It should only have numbers, “(),” and “-“.

• If you have an eFusion field, make sure that the two fields that are combined to make that field have the correct data in them. (If you have Full Name, which concatenates First Name and Last Name, make sure you have the correct data all three fields.

Finally, but most importantly, please make sure that your Excel Spread Sheet is saved as a “CSV” file or an “Excel 97-2003 Workbook.”


**Think some one-on-one training may help you better with this? Or would you just like eSalesTrack to do the clean up and import for you? Contact eSalesTrack Training at for pricing.**

See also