topic Re: Copy-pasting table into Excel with correct columns in ArcGIS Pro Questions

Copy-pasting table into Excel with correct columns

AlfredBaldenweck — Thu, 02 Sep 2021 19:38:49 GMT

I have a quality of life question.

If I select rows in a table and press "Copy", then paste them into Excel, sometimes they will paste correctly as separate columns, but frequently they'll all paste into one column.

So for example, my nice table that should look like this

Name	Parcel	Acreage	Last updated
Smith, J.	10123	45.03	9/01/2021
Doe, J.	98235	22.10	8/31/2021
Stone, M.	78723	240.00	7/26/2021

is pasted as

Name Parcel Acreage Last updated
Smith, J.1012345.039/01/2021
Doe, J. 9823522.108/31/2021
Stone, M. 78723240.007/26/2021

I haven't figured out if there's a pattern to it happening or not, but I'd like it to stop. It will happen on a dataset one day, then later in the day it'll work perfectly on the same set.

Is there an easy way to get it to not concatenate into a single column like this?

Thanks!

Re: Copy-pasting table into Excel with correct columns

DanPatterson — Thu, 02 Sep 2021 19:54:04 GMT

Your first nice table looks like every column is text given the left justification... or is that an artifact of the forum copy/paste

Re: Copy-pasting table into Excel with correct columns

AlfredBaldenweck — Thu, 02 Sep 2021 19:58:55 GMT

That's just because I made up this data to write the post. It's been happening with a mix of column types; Text and Numbers will both get squished like this.

I will also say that I've had this issue in Pro and in ArcMap in the past.

Re: Copy-pasting table into Excel with correct columns

DanPatterson — Thu, 02 Sep 2021 20:03:52 GMT

Ahh... ok. I usually use Table To Excel (Conversion)—ArcGIS Pro | Documentation

after making a selection in Pro or export to csv if using other applications.

I have noticed flakey copy/paste in other applications also but usually when a cell is blank/ <null>