5

I have a large Excel spreadsheet that contains lots of numeric data that I would like to import to ArcGIS 10.2 as a table using the Excel To Table (Conversion) tool.

The frustrating thing is that the numeric fields in Excel are repeatedly not recognised and are assumed as being text. I have set the cell format to numeric, cleared any possible blank cells, tried importing as CSV, removed invalid characters in the field headers. yet any possible iota of success evades me.

Does anyone know why this may be happening and/or how it can be resolved?

PolyGeo ♦
65.5k29 gold badges115 silver badges349 bronze badges
asked Apr 14, 2015 at 15:22
2
  • 1
    Is your Excel file .xls or .xlsx? I believe the tool, at least originally, was set up to just read .xls, although that may have changed. Commented Apr 14, 2015 at 15:41
  • I'm pretty sure it accepts xlsx but I'll test the xls format again. Commented Apr 14, 2015 at 15:49

2 Answers 2

7

If you use the Table to Table tool, which can import Excel files to geodatabase tables, you can manually set the data type of each field during the import process using the field map. Right-click the field you're having trouble with, click Properties, then change the type:

enter image description here

answered Apr 14, 2015 at 16:10
2

Ok so maybe I was too hasty with my angst.

I followed the CSV route found on this page and it worked fine. The frustration is still there however as to why you can't bring in an Excel sheet direct and retain the formatting.

answered Apr 14, 2015 at 15:41

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.