Importing contacts from a .TXT to .CSV - Gmail compatible

ExcelNovice18Help

New Member
Joined
Nov 10, 2018
Messages
1
Hi,

I have a .txt file of around 700 contacts (email addresses only) each separated by a ','.


As I am unable to import a .txt file to Gmail I have imported these contacts into a CSV file via Excel.


However when I try to import this into Gmail the import fails.


Could anyone please tell me what I can do to correct this?


At the moment each of my contacts are all displaying in separate cells, across two rows in Excel.


I notice from exporting Gmail contacts that each email address is displayed in a separate cell vertically down one column. I am not so great with Excel so do not know how to do this. Could anyone please advise? Would this solve the issue?


Many thanks for your help & looking forward to hearing from you.:biggrin:
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,090,045
Messages
5,412,026
Members
403,409
Latest member
IHRAcer

This Week's Hot Topics

Top