Feb 17 2018 02:00 PM
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 numbers, for some reason, and commas after some last names (not all), as well as a few email addresses associated with some names (again, not all).
My problem is when I import it to Excel 2016 the data just comes in as one long column, as opposed to a column with the names, another with the addresses, another with phone numbers, etc..
Is there a way to automate this to quickly create separate columns with the appropriate headings and pertinent data in them? I don't want to spend too much time cleaning up the text file line by line of all the little issues it has.
Any help is appreciated.
Feb 18 2018 05:32 PM
Hi Marco
Maybe try this?
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
Apr 09 2021 04:10 AM
you can save text file as csv
open in notepad
go to save as
change file extension to csv
choose all files
import from this csv file