I'm using ArcMap 10.8.1 and Excel 2010. I frequently copy and paste records from attribute tables into Excel in order to perform calculations.
Generally, this works fine, but sometimes the pasted data, which (for example) may consist of 20 different fields, is concatenated into a single very long text string for each record. These concatenated fields can be very difficult to parse in Excel.
I have not been able to determine what causes this to happen. Anyone else observe this obnoxious phenomenon? Can anyone think of a fix?
Thanks for thinking about this.
Are there tabs or newlines in the long text? I have found both do cause issues when copying and pasting.
The alternative would be to use Table to Excel as Joe mentioned. Alternatively, you could use python and pandas if you want more customized outputs.
I don't think blanks in one of the columns can be the cause, because it's not just two fields that are getting concatenated as one. All twenty fields are getting concatenated into one long text string.
Are you using the "Copy Selected" option from within the table in order to copy the items to the clipboard?
If so, when you double click into a cell in Excel, then paste, it will typically paste everything into one cell. However, if you click once on the cell that will be the origin cell [e.g. A1] in Excel > then paste, it SHOULD paste the individual columns.
I always use the second method you described: Click once on a cell in Excel, then right-click and choose paste. You're right, it SHOULD paste the individual columns. I'm wondering if this is something that cropped up in 10.8.1, because until recently I was able to consistently use copy/paste without a problem. However, it now seems to consistently not work. At first I thought maybe it made a difference whether I was copying from a shapefile vs. a feature class, but that does not seem to be the case.