Forum Discussion

Marco Salvatori's avatar
Marco Salvatori
Copper Contributor
Feb 17, 2018

Import txt file into Excel to create contacts list

Hello, I was given a list of contacts by a user as a text file.  It is formatted loosely as comma delimited values (CSV) but not very consistently.  It has some semicolons inserted after phone numb...
excel
office 365
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Feb 19, 2018

Hi Marco

 

Maybe try this?

 

  1. In your Excel spreadsheet, go to Data tab > From Text.
  2. Locate and open the CSV file you want to import.
  3. By default it will have Delimited selected. 
  4. If your CSV has headers, tick the My data has headers box.
  5. Click the Next button.
  6. Untick Tab anbd tick Comma in the Delimiters section. When you make this change, you will see the CSV data change in the Data preview section below (hopefully the data is looking to be grouped right).
  7. Click the Next button.
  8. You can choose how you want the columns to be formatted.
  9. Click the Finish button when complete.

If there are still issues with the data, then it could be that the CSV wasn't consistently formatted which is throwing things off.

 

See how you go and let us know?

 

Cheers

Damien

Resources