0

I have a Number's file. Each row has details for a different person. One of the columns is their email address. How can I extract these addresses and put them in a simple, unformatted text file - each address on a new line?

Improve this question

1 Answer 1

Reset to default
1

Create a new Numbers file and create a single table in it with only one column. Copy & paste the email addresses from the original Numbers file to the new Numbers file with one table of one column. Then, while within the new Numbers file, go to File > Export To and select CSV and then click on Save.

The below screenshot shows, as an example, a Numbers file with a single table of single column with randomly generated ten email addresses and the CSV file (then opened by TextEdit) that comes out when that Numbers file is exported as described above.

The Numbers file is created and exported using Numbers 14.0 under macOS Sonoma 14.4.1.

enter image description here

Improve this answer
6
  • Hi, thanks for your suggestion. I have followed your instructions but I still have a file that is 'formatted' (i.e. each address is in a separate (single-column) spreadsheet box. I'm wanting to have each email on a separate line in plain text...?
    – Dan
    Commented Apr 8 at 15:55
  • @Dan - with which program you open csv file?
    – Aivar Paalberg
    Commented Apr 8 at 15:57
  • Textedit (on the Mac)
    – Dan
    Commented Apr 8 at 16:54
  • @Dan Not sure exactly where but you are probably doing a small mistake somewhere in the process. I will update my answer to show a screenshot of the example files created as described in the answer. Hopefully those might help.
    – Alper
    Commented Apr 9 at 18:24
  • @Alper - Hi and thanks so much for your extra info. It looks like my problem maybe that my MacBook can only run OSX 12.7.4... (I've tried doing exactly as your extra info suggests)
    – Dan
    Commented Apr 10 at 22:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .