Steps to convert content from a TXT or CSV file into Excel

The steps to import a TXT or CSV file into Excel are similar for Excel 2007, 2010, 2013, and 2016:

  1. Open the Excel spreadsheet where you want to save the data and click the Data tab.
  2. In the Get External Data group, click From Text.

    Data Tab and From Text Button
  3. Select the TXT or CSV file you want to convert and click Import.

    Insert Button
  4. Select “Delimited”. A delimiter is just a fancy way of saying that your TXT file uses tabs or your CSV file uses commas to separate and group your data.  
  5. Click Next.

    Delimited Option and Next Button
  6. Select the delimiter that groups your data into individual columns in the Data preview field. Typically you want to select “Tab” when converting a TXT file, and “Comma” when converting a CSV file.
    Note: If you select “Space” it can sometimes split a single column into multiple columns if the column header text has multiple words. For example, a “First Name” column becomes a “First” column and a “Name” column. Look carefully at the Data preview to make sure your data is aligned with the intended column header!
  7. Click Next.

    Delimiters Options and Next Button
  8. Select “General”.    
  9. Click Finish.

    General Option and Finish Button
  10. Choose “Existing Worksheet”.
  11. Add “=$A$1” to the field. This ensures your data begins in the Row 1, Column A cell of the spreadsheet. If there are any blank rows in the spreadsheet above your data, it can cause a file import error.
  12. Click OK.

    Existing Worksheet Option, Cell Coordinates, and OK Button
  13. Click Save.

    Save Button

You can now make edits to the column headers to make sure they match the standard contact headings in Constant Contact, correct spelling, or update the formatting and remove special characters to prevent import errors. When you’re ready, save your file and import your contacts.

Need more help saving a supported file as an Excel file? Please see Microsoft’s Support.

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.