Versions Compared

Key

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

...

At this point your table has everything you need and nothing extra, but it is always recommended to clear all formatting and programming before bringing the Excel file into ArcGIS. In addition, columns B, G, and H currently have formulas, which need to be converted to text before ArcGIS can read them properly. To get rid of all formatting and programmingformulas, you will copy all of the data into a new blank worksheet as text.

  1. Click the Select All button in the top left corner of the spreadsheet.

...


  1. Image Added

  2. In the Home tab, click Copy.

...

  1. Rename the Output Table "US_LandCover".
  2. Make sure the Geoprocessing pane looks like the picture below and then click Run at the bottom right corner of the pane.

...


  1. Image Added

  2. In the Catalog pane, double-click the Folders folder to show the TabularTutorialData folder.
  3. In the Contents pane, right-click the US_LandCover standalone table and selectOpen.

...