We'd like to remind Forumites to please avoid political debate on the Forum. This is to keep it a safe and useful space for MoneySaving discussions. Threads that are - or become - political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
We're aware that dates on the Forum are not currently showing correctly. Please bear with us while we get this fixed, and see Site feedback for updates.
How to export Gmail data into Excel?

foxystoat69
Posts: 367 Forumite
in Techie Stuff
Hi all, Can anyone advise if there is an easy way to extract data from an incoming Gmail into Excel.
I am about to organise an event where I will be receiving the following information in an email.
Person's Name
Person's Address
Email Address
Number of people attending
I could do with a quick way of extracting the data received from each Gmail received.
Thanks all
I am about to organise an event where I will be receiving the following information in an email.
Person's Name
Person's Address
Email Address
Number of people attending
I could do with a quick way of extracting the data received from each Gmail received.
Thanks all
0
Comments
-
Copy this into Notepad from each mail
"Person's Name
Person's Address
Email Address
Number of people attending"
Modify with a delimiter (=)
"Person's Name
=Person's Address
=Email Address
=Number of people attending"
Once you have all the data, use <End> <Delete> to put each record on one line
"Person's Name=Person's Address=Email Address=etc"
Save this text file, and go to Excel. With the cursor at the point where you want the data to start, go to Data menu, select Import External Data, Import Data, and follow the dialog boxes to indicate the file you've just saved, the delimiter you're using, etc.
Does this help?0 -
Seems to work yes!
That's a start, whether or not I'd be able to copy and paste it quicker will depend on the format of the email I receive, but that's really useful, thanks0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 348.4K Banking & Borrowing
- 252.1K Reduce Debt & Boost Income
- 452.4K Spending & Discounts
- 241K Work, Benefits & Business
- 617.3K Mortgages, Homes & Bills
- 175.7K Life & Family
- 254.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 15.1K Coronavirus Support Boards