Select to view content in your preferred language

Converting/copying a 5 million row table to csv

650
2
Jump to solution
06-16-2022 08:43 AM
AbhishekSubedi
Emerging Contributor

Hi. I have a table with 5 million rows. How can I export it to 5 excel sheets with 1 million rows each? I am a beginner in ARCGIS Pro and any help would be greatly appreciated. Thank you.

0 Kudos
1 Solution

Accepted Solutions
JayantaPoddar
MVP Alum

One option would be to use Table To Table (Conversion)—ArcGIS Pro | Documentation.

Output Location needs to be a basic folder.

You may use Expression to choose the desired rows.

e.g.

JayantaPoddar_0-1655396236453.png

Alternatively, you may first "Select By Attribute" to select the range of rows, then execute "Table to Table" Geoprocessing tool.



Think Location

View solution in original post

2 Replies
JayantaPoddar
MVP Alum

One option would be to use Table To Table (Conversion)—ArcGIS Pro | Documentation.

Output Location needs to be a basic folder.

You may use Expression to choose the desired rows.

e.g.

JayantaPoddar_0-1655396236453.png

Alternatively, you may first "Select By Attribute" to select the range of rows, then execute "Table to Table" Geoprocessing tool.



Think Location
AbhishekSubedi
Emerging Contributor

Thank you so much! It works just like I needed it to.

0 Kudos