How To: Convert a raster dataset to an XYZ table
Several software packages can import data from an XYZ format. Information provided describes converting a raster dataset into an XYZ table for that purpose. This process requires a Spatial Analyst license.
- Open ArcMap and add the raster dataset.
- Open the Sample tool from ArcToolbox > Spatial Analyst Tools > Extraction > Sample.
- Select the raster dataset as the Input Rasters.
- Select the raster dataset again in the Input location raster or point features field.
- Make sure Resampling technique is set to NEAREST.
- Specify an output table.
- Click OK.
- Open the new table in ArcMap.
- Select Options > Export.
- Set Export to All records.
- Click the browser button next to the Output Table field.
- Set Save As Type to Text File and set an output location and filename.
- Click Save.
- Click OK on the Export Data menu.
- The output text file is in the following format:
OID, Z, X, Y
The following is an example of the output file:
- Use a spreadsheet program such as Microsoft Excel to rearrange the columns as necessary.
- ArcGIS for Desktop Help: Sample
- Convert a grid to a text file of x-, y- and z-values of the center of each cell with the SAMPLE function
- Convert a grid to a text file of x-, y- and z-values of the center of each cell with the Grid to Features function in the Spatial Analyst toolbar