AnsweredAssumed Answered

Losing Data When an Excel File is Imported in ArcGIS Desktop 10.1

Question asked by dr.jasraj on Aug 13, 2014
Latest reply on Aug 14, 2014 by dr.jasraj

Hi All,


I have an excel file which I am trying to join to a shapefile. The field on which the join will be based is Census Block ID - a 15 digit number.


When I import this excel file in ArcGIS Desktop 10.1, ArcMap automatically converts the 15 digit number into a 13 digit number (losing the 14th and 15th digit). This results in an incorrect join.


In order to have 15 digit numbers back, I tried the following with no success -


1. Change the numeric format in ArcMap. Although this produces more digits, it replaces last two digits (14th & 15th) with zeros.


2. Tried importing the file in Text and CSV format.


3. Exported the Shapefile attributes to a table. Combined my Excel file with that table. And, imported it back to ArcMap as a CSV.


The issue of losing last two digits still persists.


Does anyone have any clue? I would appreciate any suggestions you might have.