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:
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,213,538
Messages
6,114,218
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top