Confluence Retirement

In an effort to consolidate USGS hosted Wikis, myUSGS’ Confluence service is scheduled for retirement on January 27th, 2023. The official USGS Wiki and collaboration space is now SharePoint. Please migrate existing spaces and content to the SharePoint platform and remove it from Confluence at your earliest convenience. If you need any additional information or have any concerns about this change, please contact Thank you for your prompt attention to this matter.

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Text (.csv, .tab, .txt)

Tables in text formats can be read directly by ArcGIS. ArcMap and ArcCatalog interpret files with a txt, csv, or asc extension as comma delimited by default. Files that have a .tab extension are interpreted as tab delimited by default.

You can control how the text file is read by editing a the file schema.ini.

Microsoft Excel files (.xls, .xlsx)

ArcGIS can open Excel files directly. Remember: Excel is not a database. You have been warned.

MS Access can easily link data from Excel spreadsheets, which allows a bit of the best of both worlds.

For more information, and a warning:

MS Access (.mdb, .accdb)

Although it appears to work most of the time, and seems very convenient, ESRI does not recommend opening access .mdb files in both ArcGIS and Access... it's best to use .mdb format files for one, or the other.

Why? ArcGIS thinks all .mdb files are personal geodatabases, and will add things like index files that Access will not recognize. The same is true the other way – Access will put files in there that ArcGIS does not expect, or omit files ArcGIS expects, since ArcGIS thinks it's a geodatabase.

ESRI instead recommends accessing Access tables using ODBC (ie creating a data source using Windows). This has an additional benefit – you can open dynamic queries as well as tables. This is important because things like cross tabs or other complex joins are very slow and inefficient in ArcGIS – doing the same operation in Access could be 10x (or 1000x) faster. Access also allows access to much more powerful SQL queries than ArcGIS supports, so you can do things like summary and union queries.


(this page is under construction, feel free to add to it)

What is the Anaconda distribution?

Anaconda is an open-source Python distribution that makes is possible to easily install many pre-packaged third party Python modules. 

It has some big advantages over using Esri's distributions:

  • Very useful add-ons not in Esri's standard distribution are available (iPython, pandas, etc).
  • You can install and update Python as a regular user
  • You can install and remove, and update third party packages easily (and without admin access)
  • A single Python install stack can be used to set up different "virtual environments"



How to do a separate Python installation with ArcGIS? (GIS Stack Exchange)

Using ArcPy with Anaconda (PyMorton)