search
Partners Support Log In
Solutions
Ontraport’s solutions work together to give you everything you need to run your business in one centralized, easy-to-use platform.
Check Out Pricing
Give each customer a tailored experience to drive sales while eliminating busy work for your team.
Send emails that keep your customers engaged so your sales continue to grow with your list.
Land more leads and customers with web pages that promote your products and show off your brand.
Use visual analytics to make confident decisions for smarter marketing and more profits.
Create a custom subscription site and manage it from one place to earn recurring revenue with ease.
Optimize your entire sales process to generate more prospects, nurture your leads, and close more sales.
Online sales to seamlessly manage payments and subscriptions.
Personalize every customer interaction to generate more sales using all-inclusive customer data.
Automate your team’s most time-consuming, repetitive tasks to create more freedom in your business.
Drive and track revenue generated by referral partners who receive commissions for helping you grow.
Solutions
Resources
Find free content on the latest marketing strategies, using Ontraport in your business, and finding the right software solutions.
Visit the Blog
Marketing Strategies
Browse a collection of articles on marketing automation, email marketing, CRM, membership sites and more.
Implement proven marketing processes with our easy-to-follow worksheets and checklists
Download our best-practice guides, complete with data-driven insights and tactics to help you optimize your marketing.
Listen in as Ontraport CEO Landon Ray talks with with a star-studded cast of entrepreneurs, marketers and thought leaders.
Learn everything you need to know to develop fundamental marketing strategies with our digital handbooks.
Using Ontraport in Your Business
See if Ontraport is the right fit for you — compare the top marketing automation and CRM software on the market.
See exactly what you can do with Ontraport, and learn how you can personalize it to perform your specific needs.
View the most frequently asked questions about Ontraport so you can get clarity and feel confident in your buying decision.
Take a guided tour through the five phases of the customer lifecycle in a simulated business powered by Ontraport.
Get an honest estimate of the return you can expect from an investment in Ontraport's software.
Resources
Customers
Ontraport empowers businesses large and small, all over the globe, and in every industry, to succeed.
Read the Reviews
Hear From Our Customers
Don’t just take our word for it. See why businesses from every industry love Ontraport’s marketing automation and CRM software.
Find out how our users have created thriving businesses and transformed their lives with Ontraport.
Industries We Serve
Personal Services
Professional Services
Online Retail
Coaches & Speakers
Author & Bloggers
Brick & Mortal Retail
Technology
Manufacture & Wholesale
Your Unique Business
Your Unique Business
Customers
Chat With Us chat
Start Free Trial
menu
close
Why
Ontraport?
Solutions keyboard_arrow_down keyboard_arrow_up
Marketing Automation
CRM
Email Marketing
Landing Pages
Marketing Analytics
Sales Force Automation
Ecommerce
Business Process Automation
Membership Sites
Referral Programs
Resources keyboard_arrow_down keyboard_arrow_up
Ontraport Blog
Step-by-Step Templates
In-Depth Guides
Modern Ontrapreneur Podcast
Marketing Blueprints
Software Comparisons
Feature Use Cases
Get the Facts
Exploring Ontraport
Calculate Your ROI
Customers keyboard_arrow_down keyboard_arrow_up
Customer Reviews
Success Stories
Support Center
Partner With Ontraport
Chat With Us chat
Check Out Pricing
Frank Hagan
Updated

Contents

    Back to Top

    Importing Contacts: Capitalizing Proper Names

    About

    Applies to: All ONTRAPORT accounts.

    In some cases, you may find your old service had contact names in a mix of formats including all upper or all lower case. ONTRAPORT does not convert these formats upon import, but Excel, Libre Office and Open Office have a formula to do this easily. This article uses screen shots from the free Libre Office spreadsheet program that is nearly identical to Excel and Open Office.

    Capitalizing Proper Names

    1. Add a column next to the column containing the names to be reformatted. In this example we'll add a new column that becomes column B. In column B, cell number 2, type the formula =PROPER(A2):


    2. Press ENTER to see the name properly capitalized. Hover over the cell to expose the small black square in the lower right corner, click and drag it to copy the formula to the bottom of the column.

    3. Release the black square to copy the formula to the rest of the cells.
    4. Next, we will change these cells to contain just the name, and not the formula. Right click the column heading B and select Copy.


    5. Right click the column again and select Paste Special (or Paste as Text)



    6. In Excel, the choose the Paste 123 icon


    7. Approve pasting the data as text or values in the dialog that pops up.


    8. Approve any existing warnings about overwriting the data. When finished, check to see that the formula bar contains just the name and not the formula when you click on a displayed name in column B.


    9. When satisfied that column B contains only the names, and not the formula, delete column A.

    In some cases you will want to keep the original data format. ONTRAPORT also provides the ability to change the capitalization when using merge fields without changing the underlying data. See Formatting Merge Fields for more information.

    After import, ONTRAPORT will keep a copy of your uploaded CSV file in Contacts > Settings > Import Contacts. This copy is discarded after 60 days. Archive a copy on your local computer if you want to keep a permanent copy.

    Articles in this section

    See more
    Created - Updated
    Have more questions? Submit a request

    Comments