nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcMap concatenates feature class fields when copy/pasting to Excel

RickBombaci

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.

Encontre mais publicações marcadas com

Desktop

Accepted answers

All comments

RickBombaci

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.

RickBombaci

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.

RickBombaci

There's nothing unusual in the attribute table. No tabs, no newlines.

RickBombaci

Thanks for the suggestion. I know I could, but that actually takes more time than copy/paste when copy/paste works properly. And usually copy/paste does work properly.

Mary_Murphy

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.

danretired

or blanks in one of the columns, it may treat the two fields as one.

ClayDonaldsonSWCA

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.

JoeBorgione

Why not use Table to Excel on the selected records so you don't have to rely on copy and paste?

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.