I have a CSV I'd like to join to a shapefile. I brought the CSV into ArcMap, realized it had an error, fixed it and saved the file with the same name. I removed the CSV from my map document, refreshed the CSV's enclosing folder, and brought the CSV into the map document again. It is still the old CSV, with error. I verified that I had saved it correctly. I had. I closed Excel, and reopened the CSV: still correct. I 'reloaded' the CSV in ArcMap's table of contents. Still the old version.

I know I can resave the CSV with a new name to get around this issue but I want to figure it out. What am I doing wrong? How can I get ArcMap to recognize the updated CSV file?

  • Have you restarted ArcMap? Have you tried reloading cache in the attribute table? – BERA Oct 14 '18 at 15:55
  • @BERA I have reloaded the cache but have not restarted ArcMap – is that really something I have to do? Thanks – Unrelated Oct 14 '18 at 16:00
  • I've had weird trouble with ArcMap 10.6 and CSV files that did not get resolved on restarting Arc or my computer (mostly on it reading the data type [e.g., short vs. double] wrong from the schema file, so a bit different than your issue). Try having the new CSV in a temp folder--does it load correctly then? – a11 Oct 14 '18 at 16:02

Go into Windows File Explorer and look at the folder where your CSV is saved. There is likely an associated XML file that was created when you first added it to ArcMap - they create this supplemental file to manage table headers etc. If you remove the CSV from your table of contents, delete the XML and reload, it should update.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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