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

Imported csv data is different on ArcGIS Pro than what is on my Excel sheet?

Emberlynn

I'm doing an assignment for my ArcGIS Pro class, and we were required to download data from data.census.gov, clean up the data in Excel, save as a csv file, and import that csv into a new map on ArcGIS Pro. However, when I upload my csv file to ArcGIS Pro (using table to table tool in geoprocessing), I'm missing a heading for my data in ArcGIS Pro, which resulted in all of my headings being pushed one column to the left. I made sure to change all my numeric data to numeric form, but when I open the table in ArcGIS, all of my numeric values became text fields. I can't change the data type from text to numeric in the fields view of the table and I can't fix the issue no matter how many times I try.

I've attached two screenshots of my data below.

If anyone knows how to fix this, I would really appreciate your help!

pushed data.jpg

excel data.jpg

431101947_410593798227426_7326126807502340727_n.jpg

Dale_Honeycutt_0-1713723166924.png

Find more posts tagged with

Geodatabase

Accepted answers

All comments

DanPatterson

Excel To Table (Conversion)—ArcGIS Pro | Documentation .

Also make sure that you have no blanks in your spreadsheet. and I would explicitly format each column that is numeric as numeric.

jcarlson

A spreadsheet, unlike a Feature Class or a database table, doesn't have an explicit type for each column, and it's not uncommon for the column's data type to be incorrectly inferred, or for a single value in the column to throw off the the way the rest are stored.

Without making any significant changes to your input CSV, just spend some time going through every field in the Field Map section of the tool. This allows you to explicitly state the type for each field in the new feature class.

Alternatively, you could also create the new table first, then use Append to copy the CSV rows into it.

And lastly, if you want to tackle this a different way altogether, you can query the Census API directly and the resulting JSON can be converted directly into a FeatureSet that can then be written to a Feature Classs, merged with other data, etc.

RolandDuhaime

It is hard to tell what is going on without having a copy of the data... but I suggest renaming the field "Geographic Name Area" to Geographic_Name_Area... to eliminate the spaces. Also, there is an Excel to table tool in ArcGIS Pro that might work better for importing your Excel spreadsheet.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/excel-to-table.htm

Best Wishes, Roland

Emberlynn

I tried renaming the field "Geographic Name Area" to Geographic_Name_Area like you suggested, then using the Table to Table tool (my professor uses Table to Table because she wants us to convert the xlsx file to a csv and import it as a csv file).

I then tried using Excel to Table tool and that worked! Thank you so much!

MicZatorsky_AEC

Check to see if you have a schema.ini file in the same folder as your csv that references you CSV. It can set column names and type columns.

Anonymous User

I'd never opened this file and honestly never wondered about it. Lo and behold, the fields I was interested in were set to Text. Changing them to "Double" worked. Thanks for the solution!

BrendanDijkstra

This was incredibly helpful! I couldn't wrap my head around the fact that some csv loaded properly as doubles and some got randomly converted to text. I wonder what initially made this schema.ini file, is it excel of ArcGIS Pro?

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.