I am trying to join an Excel table to my parcel attribute table in ArcMap.
I have run a validation and all checks out except it says there are no matches.
What would cause this?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Exporting to a dbf works most of the time and is the easier way, but it doesn't really identify the problem.
Ensure the Excel Table in your spreadsheet (the xls or xlsx file) is viewable, has the expected number of records, and you receive no errors (i.e. you see your data values when previewing).
Compare the Data Types for your parcel attribute table and your Excel Table and ensure they match (i.e. text is text and floats are floats).
Another quick and easy check is to find a value that you know should match between the two tables. Simply copy/paste the value (ctrl-c, ctrl-v) into something like notepad and make sure there are no spaces or any other characters. Do a Select by Attribute on your copy/pasted value and see if you get a result in both tables.
You're going to want to export your excel table as a .dbase or .dbf file, then your join should work as expected.
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.