Geoprocessing considerations for delimited files

In geoprocessing tools, you can access and write data in delimited text files and work with them as tables.

Any geoprocessing tool that accepts a table as input can read a delimited text file. In addition, any geoprocessing tool that can create a table can write directly to a delimited text file. Geoprocessing tools support the following delimited text file formats:

  • Comma-delimited text files (.txt, .csv, and .asc) in which a comma character (,) separates each value.
  • Tab-delimited text files (.tsv and .tab) in which a tab character separates each value.
  • Pipe-delimited text files (.psv) in which a pipe character (|) separates each value.

The first row of a text file contains the column headings, and the subsequent rows contain coordinates and attributes. The following is an example of a comma-delimited text file:

99.3,77.0,002,blue and red

Related topics