I have an email address that people send to that I am in need of exporting and viewing the messages in Apple Numbers.
When I export the emails, they are placed in a .mbox file that I cannot seem to find a way to get the email data for view in a spreadsheet.
Does anyone know of a way to convert the .mbox file into a .csv file so that I can gain access to the emailed data so that it can be viewed in Apple Numbers>
MacBook Pro 16″, macOS 10.15
Just a simple export of the Mailbox(Inbox). It auto saved it to a .CSV and I opened it with Excel.
Flawless
I attempted your work around, but this will not work as the data is severely scatter.
The emails are all structured the same exact way. That method just doesn’t work.
It was intended to be "step 1". I was thinking there might be a pattern to the madness that would allow you to extract the information you want using formulas.
Have you asked in whatever forum covers Apple Mail? Maybe someone there will have a better answer.
What did you do in Outlook? I ask out of curiosity.
It seems that what you are asking for could be scripted with AppleScript. I don't know enough to do it but it sure looks possible.
No, I think I was late to the party posting the script. I do not understand what the solution actually was.
The solution was the script I posted in that thread and you reposted here that transfers data from selected messages in Mail to a Number table. No need to go through mbox and csv.
SG
Ahh. Same OP. I get it now. That threw me off.
I'm keeping your thread around for the next time a similar question comes up.
If you want to save the MBOX file to a CSV file then you have need to use the MBOX Migrator tool that saves up to 50 items per folder for free.
convert mbox to csv
