What is ArcGIS Online?

ArcGIS Online is a cloud-based mapping and analysis solution designed as a software as a service (SaaS) platform. It serves as an integral tool for a variety of spatial analysis workflows, facilitating the creation, management, and sharing of geographic information and maps. As a SaaS platform, it offers users the convenience of secure and scalable mapping capabilities without the need for extensive infrastructure.

With ArcGIS Online, users can engage in data collection and management, and apply intuitive analysis tools to gain insights for improved decision-making. The platform supports collaborative efforts through a configurable sharing model, allowing for the easy exchange of maps, apps, and data analysis results. Its integrated apps and smart mapping tools enhance data visualization and exploration, making it an agile and flexible service for different organizational needs.

The service extends its capabilities by providing access to authoritative location-based data, including ArcGIS Living Atlas of the World, and offers enterprise-ready features such as security and user management. In essence, ArcGIS Online stands as a comprehensive tool for spatial data analysis, visualization, and collaboration, enabling users to work with the most up-to-date information for their mapping and analytical needs.

ArcGIS Online Plugins for Excel

ArcGIS for Excel Add-In

ArcGIS for Excel is an add-in designed to enhance the capabilities of Microsoft Excel. It is accessible to standard users and fully compatible with all Microsoft Excel functionalities. The add-in allows for the integration of coordinate data directly from spreadsheets, making it possible to create maps and perform spatial analysis within Excel. When logged in with an ArcGIS Account, users can unlock additional features to augment their mapping and analysis capabilities.

Capabilities with an ArcGIS Account

Upon purchasing an ArcGIS Account from the Azure Marketplace, users can leverage enhanced features within the ArcGIS for Excel add-in. These capabilities include adding layers, conducting various analyses, and sharing projects on ArcGIS. The availability of these advanced features enables a more comprehensive and collaborative geospatial working environment within Excel.

Data Upload and File Support

The add-in streamlines the data upload process by including a progress bar that visually indicates the progress of data uploads, ensuring that users can monitor their data upload status effectively. Moreover, the add-in supports the import and use of CSV files, allowing users to work with a common data file format for geospatial data.

ArcGIS Online Excel Integration

Integrating Excel with ArcGIS Online is a straightforward process that can be completed in four steps. Users must have the necessary privileges to publish hosted feature layers in ArcGIS Online. If such privileges are lacking, users should contact their ArcGIS Online administrator or sign up for a free trial. Once spreadsheet data is added to ArcGIS Online, users can engage in further data collection, perform analytics, and share their maps as web apps with enriched layers.

Customized Functions and Language Support

The ArcGIS for Excel add-in is equipped with customized functions tailored for geocoding, geoenriching, and routing operations, providing a robust set of tools for geospatial data manipulation. Additionally, the add-in caters to a global audience with its availability in multiple languages, ranging from Arabic to Ukrainian, making it accessible to a diverse user base around the world.

Printing and Exporting Maps

Users of the ArcGIS for Excel add-in can print maps directly from Excel in various formats, including PDF, PNG, JPEG, GIF, EPS, and SVG. This feature ensures that users can easily share their geospatial insights in a format that suits their needs, whether for digital sharing or physical printouts.

Common Use Cases

• A

  
  Creating maps from spreadsheet data
• A

  
  Plotting and styling locations based on attributes like revenue
• A

  
  Performing visual analysis of business leads
• A

  
  Assessing proximity of potential customers to business locations
• A

  
  Sharing and presenting geographic analyses

Frequently Asked Questions

What is the ArcGIS for Excel add-in?

ArcGIS for Excel is an add-in for Microsoft 365 that integrates ArcGIS mapping capabilities into Microsoft Excel, allowing users to create interactive maps using data from Excel and ArcGIS services.

How do I get started with mapping in Excel using the ArcGIS add-in?

To get started, install the add-in which adds the ArcGIS tab and the Map data tab to Excel. You can access public ArcGIS content and layers without a subscription, but full access requires signing into an ArcGIS account.

Can I use the ArcGIS for Excel add-in without an ArcGIS subscription?

Yes, without a subscription you can access public ArcGIS content and layers from the ArcGIS Living Atlas of the World. However, private layers and analysis tools are not available without a subscription.

What are the capabilities of standard users using the ArcGIS for Excel add-in?

Standard users can add x,y points, pan and zoom the map, and view pop-ups. They can use a curated set of layers from the ArcGIS Living Atlas of the World, but cannot access private layers and analysis tools without a subscription.

How can I access full ArcGIS Online Excel plugin features?

Full access to map tools and content requires signing into an ArcGIS account with the necessary privileges to create, analyze, and share content. Users can sign up for a free trial ArcGIS Online subscription to gain additional access.