Select to view content in your preferred language

Excel to Table not functioning

07-03-2017 06:26 AM
New Contributor II

Hello! I am trying to convert an Excel file to Table. Worked last night, not anymore. No error code, see screenshot. Ideas?

Tags (1)
0 Kudos
4 Replies
Occasional Contributor III


The error could be because of mismatched fields and data type. Make sure there is no space in the beginning of each FieldName, no space between FieldNames (for e.g. not Feature Name but Feature_Name). Make sure there are no annotations such as N/A in the field values especially if that field's data type is numeric.

If possible, show us a snapshot of your excel spreadsheet.    

Occasional Contributor III

I just noticed your excel file is in xlsx format. Save the excel file in xls format. You should have no issues provided there are no mismatched fields and data types. 

MVP Regular Contributor

Additionally, field names cannot begin with a number.

MVP Esteemed Contributor

What version is your ArcMap?

Could you attach a sample of the excel sheet? I hope the table is simple, i.e., the first row of the excel contains the name of the fields, and no merged cells anywhere.

Think Location
0 Kudos