Exporting Exact Columns you want with no extras

102
1
Jump to solution
3 weeks ago
Labels (3)
GISDepartmentMFM
New Contributor II

Good Afternoon All,

I am working on exporting a standalone table to an excel file. I have used the right click--->Data-->export Table--> name the file with .csv---> and chose the desired fields.

However after I export and open the CSV I get an extra OID column. I do not want to have the column exported with the fields I selected.

Does anyone know a work around for this or am I stuck Exporting the file and deleting the OID column within Excel?

See picture for explanation. In the picture column A is not needed and needs to be deleted.

Thanks!

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
DanPatterson
MVP Notable Contributor

Hide the field(s) you don't want.

TableToExcel .... save it to an xls or xlsx

Table To Excel (Conversion)—ArcGIS Pro | Documentation

The tools in ArcToolbox are better than shortcuts.

Save to csv from there


... sort of retired...

View solution in original post

1 Reply
DanPatterson
MVP Notable Contributor

Hide the field(s) you don't want.

TableToExcel .... save it to an xls or xlsx

Table To Excel (Conversion)—ArcGIS Pro | Documentation

The tools in ArcToolbox are better than shortcuts.

Save to csv from there


... sort of retired...

View solution in original post