topic Re: How to export simple dbf for import into Excel in ArcGIS Pro Questions

How to export simple dbf for import into Excel

MalcolmLittle — Tue, 08 Jan 2019 02:58:12 GMT

Hello,

I'm used to exporting an attribute table in ArcMap (version 10.4 in particular) for further analysis in Excel. Normally, I open the attribute table in ArcMap, click on the top-left icon, choose Export, and send everything to a DBASE table:

This produces a dbf file I can drag-and-drop right into Excel, and get a readymade table just as it was in ArcMap.

Tried the same in ArcPro (version 2.1.3), and figured out how to export to a DBF. However, instead of the above simple table of 3 columns, I get a lot of extraneous columns related to XML. Is there any way to replicate the same method that was so simple from ArcMap in ArcPro?

Re: How to export simple dbf for import into Excel

DanPatterson_Retired — Tue, 08 Jan 2019 03:08:49 GMT

new world, but it works... total time 1 minute including screen grab stuff

Re: How to export simple dbf for import into Excel

MalcolmLittle — Tue, 08 Jan 2019 04:57:02 GMT

That didn't work for me without adding a ton of extraneous XML schema columns. Nonetheless, I found out how to export to txt, which provides the result I need after Text-to-Columns

Re: How to export simple dbf for import into Excel

DanPatterson_Retired — Tue, 08 Jan 2019 05:34:52 GMT

Ahhh, you need some tools to test for me then

Table Tools for ArcGIS Pro

Table to csv, table to txt, to npy, excel to table

Lots of toys..

Re: How to export simple dbf for import into Excel

XanderBakker — Tue, 08 Jan 2019 12:44:43 GMT

Just a question? Is the DBF intermediate format really necessary? Wouldn´t Table To Excel—Conversion toolbox | ArcGIS Desktop do the job to export a table to Excel?