I was sent an e-mail with some data from an excel sheet embedded in it. I want to extract that data to another Excel spreadsheet. When I try to copy and paste it, it insists on pasting it as an object which does not allow me to work with the data.

  • You're pasting it after opening it and doing a Select All... Copy? – joeqwerty Jul 1 '14 at 21:40
  • If you right click on the embedded worksheet, is there a "Save as..." option? – P Fitz Jul 1 '14 at 23:36
  • The right click only gives a save as picture option. I am not doing a select all copy. Just clicking the data and copying it. – Sonny Navaratnam Jul 2 '14 at 0:16
  1. Copy the table in the outlook email.
  2. open a new excel sheet and select Paste Special
  3. Paste as text

enter image description here


Found a trick copy your table in the Outlook email command+C then paste the table into a new document in evernote. Then copy the table in evernote and paste it into excel. This worked for me. I'm using Office for Mac 2011

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.