ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Creating a database from a spreadsheet

Data model information is provided as an Excel spreadsheet for most of the data models included with Esri Defense Mapping. This is a format not usually accepted in ArcCatalog for data models; they are accepted as Access databases or XML files.

The Geodatabase Builder tool allows you to create a personal or file geodatabase from an Excel spreadsheet. The spreadsheet used with the tool should contain all the required information regarding feature classes, feature datasets, and domains.

Learn more about the Excel files used to create geodatabases

  1. Start ArcCatalog.
  2. On the main menu, click Customize > Toolbars > Defense Mapping.
  3. Click the Geodatabase Builder button Geodatabase Builder on the Defense Mapping toolbar.

    The Geodatabase Builder dialog box appears.

    Geodatabase Builder dialog box

  4. If necessary, click the Excel to GDB tab.
  5. Click Select XLS.
  6. Navigate to the Excel file to be used to build your geodatabase.

    The Excel files can be found in the <Defense Mapping installation location>\ESRIDefenseMapping\Desktop10.3\[ProductName]\Schema\XLS directory.

  7. Click Add.
  8. Click Select GDB.
  9. Navigate to the directory where you want to create the new geodatabase.
  10. Type a name for the geodatabase in the File name text box.
  11. Click Save.

    The Geodatabase Builder dialog box appears.

  12. Click Process.

    The geodatabase is created using the designated Excel file.

    When processing is complete, the Excel to Geodatabase message appears.

  13. Click Yes to view the log file or No to close the message.

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal