FNA Process: Export the attribute table

Author

Sarah Hagen

Exporting the attribute table to .csv format

Exporting your attribute table to CSV (comma separated value) format makes your data versatile and accessible in various programs, such as Microsoft Excel, R, ArcGIS Pro, and QGIS. Follow these steps to export your table in ArcGIS Pro.

Step-by-step process

**Screenshots of the process are included below the written instructions for those who find them useful.*

  1. Open the Attribute Table
    • Open the attribute table for the combined raster you just used to join fields.
  2. Access the Export Option

    • Click the hamburger (three lines) menu in the top right corner of the attribute table window.

    • Select the “Export” option from the menu.

  3. Set Input Table
    • In the Export Table dialogue window, ensure the input table is set to the combined table you just used to join fields.
  4. Set Output Table

    • Use the folder icon to choose a meaningful location to save your output table.

    • Important: Make sure you set the file extension to .csv. If you don’t do this, ArcGIS Pro will default to a .dbf format, which can be read by GIS but is harder to open with spreadsheet programs such as Excel.

  5. Complete the Export
    • Confirm your settings and click Export to save the attribute table as a CSV file.

This process ensures your data is saved in a versatile format, making it easy to use in various applications for further analysis and visualization.

Screenshots of exporting the attribute table to .csv

The ArcGIS Pro window showing the attribute table. A box highlights the three lines hamburger menu in the upper right corner of the attribute table window and another box highlights the Export option at the bottom of the subsequent pop-up menu.

Export the table.

 

The Export Table window showing the combined raster as the Input Table and the Output Table with the same name as the combined raster but the file extension .csv

Save the table as a .csv file on your computer.

Still have questions? LANDFIRE is here to help.