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; } } }

Attribute table to CSV

RonMan

Hi, I have an attribute table with 5 million rows. I would like to export this to csv. Unfortunately my first tries are not successful. I have tried table to excel and export to txt file & dbf file. From my searches in google and here in the community, I cannot believe that just a csv export will require python or an additional install or a third party software. Am I missing any built in tool? . I would appreciate if you can guide a beginner since I have no idea how to run a python program. Or could give me any guidance how to achieve a CSV from table.

Thank you.

Ronald

UAE

Find more posts tagged with

Accepted answers

JayantaPoddar

You can use Export Feature Attribute to ASCII tool to achieve the desired output.

See below snapshot.

All comments

JpersonalLundquist

Well, I believe current Excel and Libre Office Calc can only handle 1,000,000 records. So, they just can't read it. dbf and txt are the next choice from my experience. Good topic, thanks.

ErinGrimm1

Hey Ron,

Glad the "to ascii" worked for you. I will have to try that. I had a table recently with 3.8 million records and was having a heck of a time finding a solution. While the help page from the Table to Table tool mentioned .csv was possible, there weren't any examples that jumped out at me. I forgot where I found it, but it was as simple as adding ".csv" to the file name for my exported table which allowed the Table to Table tool to recognize I wanted CSV and not a DBF.

Sounds like you found a solution, but wanted to document this here in case someone else is looking for answers.

RonMan

Thank you all for suggesting the different methods. All your responses are very informative.

The export feature attributes to ascii was able to export successfully a csv file as big as 11 million records.

Regards,

Ron

RobertBorchert

Try exporting it first to a personal geodatabase.

Then go to the database in Access and export it from there as .csv

JoeBorgione

Saw the table to table tool listed but didn't notice that it accepts csv or txt files as input. While I avoid txt or csv files as much as I can, sometimes the need arises. I notice the table to table tool doesn't care for pipe ( | ) delimited files which is often times what I get. The Access import wizard is great for those:

Dan_Patterson - I was just wondering out loud....

JayantaPoddar

Joe,

Are you looking for Table To Table—Help | ArcGIS for Desktop ?

This tool supports the following table formats as input:
Geodatabase
dBASE (.dbf)
Comma-separated values (.csv)
Tab-delimited text (.txt)
Microsoft Excel worksheets (.xls or .xlsx)
INFO
VPF
OLE database
In-memory table views

DanPatterson_Retired

Joe... I have ascii imports but ascii, do you mean ascii to raster?? If it is for tabular data, then use NumPyArrayToTable to bring in tabular data and TableToNumPyArray to go back, And to get the text data into numpy... it has lots of cool tools for importing data into structured and/or recarrays (check my blog, or email me with specifics of format you are working with)

JoeBorgione

Jayanta Poddar‌ - just wondering if there is an import from ascii to table tool. I've been searching but haven't come across one. You can add a csv as a data source, and then I guess you can export that as a table. It would be cool to have a utility like in Access that takes it straight in.

JayantaPoddar

You can use Export Feature Attribute to ASCII tool to achieve the desired output.

See below snapshot.

TimWitt2

It is a little more involved. Within the MXD where your data is, open ArcToolbox. Within the toolbox window right click some white space and choose "Add toolbox". NAvigate to the folder where you unzipped the attached file and select the "Excel and CSV Conversion Tools.tbx" toolbox.

RonMan

Thank Tim, I'll try it tomorrow. I'll see if I can make it work, I have not used any python tool before. I hope it is just an install.

TimWitt2

I have attached what I use. It is a python toolbox.

Excel_and_CSV_Conversion_Tools (1).zip

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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