I have 4 shapefiles in total, and for 3 of my attributes tables, I was able to directly copy it (including the formatting) into Excel. I do this by using 'Select All' and 'Copy Selected'. When I went to copy my last table, which has 57 features, it copied, but it loses its formatting when pasted (it became one long line to text) into Excel. I'm pasting into a new spreadsheet for every table and they're all point shapefiles. Does anyone know why sometime copy and pasting keeps the formatting while other times it does not?
I'm running ArcMap 10.3 and using Excel 2010.