Extracting Information From Excel Spreadsheet

Terrysdelight

Hi
I am being asked by a friend to extract email addresses from a spreadsheet.  Basically the spreadsheet is a record of clients details set-out across columns.
Is there an easy/quick way that I can extract this information?  I think there are about 5000 email addresses?
Many thanks
Terrysdelight

stragglebod

If you have a column of email addresses, why would it be anything but quick and easy?

lesalanos

Extract to what?  What do they want to do with them? 

Terrysdelight

Extract the email addresses so that they can be used for bulk emails.   I know I can copy and paste each address but there are 5000 of them.

Heedtheadvice

You generally will need to extract the addresses (names too?) from the sheet in a clean fashion.

If the addresses are in a particular column(along with other data in other columns), copy and paste those column cells into a new clean spreadsheet (or if you prefer use function equals to pastelink - ask if you need to). Save that new spreadsheet for safety. Then also save as a comma separated values file (CSV file).

If the addresses are in cells with other info it is more complicated!

That is a first step to being able to import as contacts into many an email package. Any more depends on which package etc. (in line with question posted above) : more detail is needed from you.

There are also ways to use the data directly from within the spreadsheet with things like Outlook but that is very likely to be far too complicated for you (given your question) and for a one off excercise.

stragglebod

Terrysdelight said:

Extract the email addresses so that they can be used for bulk emails.   I know I can copy and paste each address but there are 5000 of them.

So select the entire column, copy and paste.

Why don't you tell us what you actually want to do and why you think it's difficult?

Terrysdelight

Thank you.  I am just waiting on the spreadsheet to arrive.  Will post back if I have problems.   I've had sight of the spreadsheet before and I thought the information really should be created as a database.  Thre are so many ways he should be using the information.

Terrysdelight

stragglebod said:

Terrysdelight said:

Extract the email addresses so that they can be used for bulk emails.   I know I can copy and paste each address but there are 5000 of them.

So select the entire column, copy and paste.

Why don't you tell us what you actually want to do and why you think it's difficult?

Hi
I'm not saying it is difficult - I am trying to find how I should do it.  I am nowhere near as techy as I was 15 years ago!

Terrysdelight

Heedtheadvice said:

You generally will need to extract the addresses (names too?) from the sheet in a clean fashion.

If the addresses are in a particular column(along with other data in other columns), copy and paste those column cells into a new clean spreadsheet (or if you prefer use function equals to pastelink - ask if you need to). Save that new spreadsheet for safety. Then also save as a comma separated values file (CSV file).

If the addresses are in cells with other info it is more complicated!

That is a first step to being able to import as contacts into many an email package. Any more depends on which package etc. (in line with question posted above) : more detail is needed from you.

There are also ways to use the data directly from within the spreadsheet with things like Outlook but that is very likely to be far too complicated for you (given your question) and for a one off excercise.

Hi
Have copied and pasted the column into a new clean spreadsheet, have also saved a copy as a CSV file.
Scrolling down the column there are 7500 cells. about 5000 have addresses, the remaining cells are empty (ie, no email address recorded).  It is going to be fairly painful to delete the empty cells.   Is there a quick method to do this?
Many thanks.

Terrysdelight

Terrysdelight said:

Heedtheadvice said:

You generally will need to extract the addresses (names too?) from the sheet in a clean fashion.

If the addresses are in a particular column(along with other data in other columns), copy and paste those column cells into a new clean spreadsheet (or if you prefer use function equals to pastelink - ask if you need to). Save that new spreadsheet for safety. Then also save as a comma separated values file (CSV file).

If the addresses are in cells with other info it is more complicated!

That is a first step to being able to import as contacts into many an email package. Any more depends on which package etc. (in line with question posted above) : more detail is needed from you.

There are also ways to use the data directly from within the spreadsheet with things like Outlook but that is very likely to be far too complicated for you (given your question) and for a one off excercise.

Hi
Have copied and pasted the column into a new clean spreadsheet, have also saved a copy as a CSV file.
Scrolling down the column there are 7500 cells. about 5000 have addresses, the remaining cells are empty (ie, no email address recorded).  It is going to be fairly painful to delete the empty cells.   Is there a quick method to do this?
Many thanks.

I've managed to work out how to delete all the blanks - that saved a lot of time!
I'm now ready with a column full of email addresses.   How to I get the email addresses from the spreadsheet into an email message please?

DoaM

So many questions ......

What email utility?
Or is it a web-based bulk emailer? If yes, which one?
What script functionality is available? (e.g. PHP ... it's not too difficult to cycle through a list of entries in a CSV file and send emails)
Is there an email sending limit with the provider? (i.e. to prevent spamming)
Is the exact same message going to each recipient? Any customisation needed?
Etc.