I am working off a document created by someone else in Visio. They have
create a 'spreadsheet' using lines and individual text boxes. I want to
import/copy this text from visio(ideally keeping the formatting, but not
essential) and paste it into Excel cells.

If I select one text box from visio and copy and paste it into excel, it
pastes the text into a cell as text (which is what I want). However, If I
select multiple text boxes it will paste this into excel as an image. I have
tried paste special but this only gives me different image types to paste it
as.

Can anyone assist or point me in the right direction.

Or am I barking up a non-existent tree?

Thanks!