I'm trying to join a shapefile with an Excel file I converted into a CSV. I had done this before with the same shapefile but with a different CSV but this time when I try to select the column it's removed from the join list. I have tried exporting the CSV as DBF then turning it back into a CSV as well which did not work. I have included two screenshots below. I want to use the column PCODE3 because it shares the same data as MUN_P_6. Screenshots:

Full list of fields:

enter image description here

Limited list of fields:

enter image description here


1 Answer 1


Verify that the field type of PCODE3 is the same as the field type of MUN_P_. You can't join fields with different types.

  • How do I do that? I set it to text in excel but I didn't think CSVs kept any formatting data like that.
    – Amuro Ray
    Commented Apr 9, 2014 at 12:52
  • 1
    Look at the field properties of the csv in ArcGIS, you will see how ArcGIS reads it. It will be text anyway if there are alphanumeric values. If the field types are different, add a new field with the right format to your shapefile and copy the values from the join field (MUN_P_6) to it.
    – GISGe
    Commented Apr 9, 2014 at 15:16

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.