{"id":2854352,"date":"2025-07-01T13:09:58","date_gmt":"2025-07-01T20:09:58","guid":{"rendered":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2854352"},"modified":"2025-11-04T16:16:54","modified_gmt":"2025-11-05T00:16:54","slug":"using-arcgis-for-excel-to-edit-referenced-data","status":"publish","type":"blog","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data","title":{"rendered":"Using ArcGIS for Excel to Edit Referenced Data"},"author":252692,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_searchwp_excluded":""},"categories":[23341,23851,22851,22841,23051],"tags":[766102,761562,763732,780162,767792],"industry":[],"product":[766382,770122],"class_list":["post-2854352","blog","type-blog","status-publish","format-standard","hentry","category-analytics","category-data-management","category-national-government","category-local-government","category-water","tag-arcgis-for-excel","tag-arcgis-for-microsoft-365","tag-database","tag-edit-arcgis-layer-data-in-excel","tag-enterprise-geodatabase","product-arcgis-for-excel","product-microsoft-365"],"acf":{"show_article_image":true,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/07\/ArcGIS-for-Microsoft-365-BANNER-Edit-Referenced-Data-Non-hosted-layers-in-ArcGIS-for-Excel-ArcGIS-Enterprise-CARD.jpg","wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-for-Microsoft-365-BANNER-Edit-Referenced-Data.jpg","authors":[{"ID":252692,"user_firstname":"Gaurav","user_lastname":"Singh","nickname":"Gaurav Singh","user_nicename":"gsingh","display_name":"Gaurav Singh","user_email":"gsingh@esri.com","user_url":"","user_registered":"2021-07-16 23:07:37","user_description":"Sr. Product Engineer in the ArcGIS for Microsoft365 group.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"},{"ID":371702,"user_firstname":"Taylor","user_lastname":"Campbell-Koratzanis","nickname":"Taylor Campbell-Koratzanis","user_nicename":"tcampbell-koratzanis","display_name":"Taylor Campbell-Koratzanis","user_email":"tcampbell-koratzanis@esri.com","user_url":"","user_registered":"2025-05-14 14:13:18","user_description":"Taylor is a Product Designer for the ArcGIS for Microsoft 365 team. She designs with the aim of providing clarity to complex information. In her spare time she enjoys bookbinding and playing Riichi Mahjong.","user_avatar":"<img data-del=\"avatar\" src='https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/Campbell-Taylor_Headshot-465x465.jpg' class='avatar pp-user-avatar avatar-96 photo ' height='96' width='96'\/>"}],"short_description":"Edit referenced data (non-hosted feature layer) in Excel, directly updating ArcGIS Enterprise layers and databases with proper permissions.","flexible_content":[{"acf_fc_layout":"content","content":"<p><strong>Overview<\/strong><\/p>\n<p>ArcGIS for Excel makes it easy to work and edit your spatial data directly within the familiar Excel interface. This blog demonstrates the process of setting up a workflow that allows you to edit referenced layers in Excel. In ArcGIS Enterprise, services including feature layers, can be published with reference to the original datastore.\u00a0 The data is not copied and is accessed in its original location.\u00a0 The data store must be <a href=\"https:\/\/enterprise.arcgis.com\/en\/server\/latest\/manage-data\/linux\/registering-your-data-with-arcgis-server-using-arcgis-for-desktop.htm\">registered with your ArcGIS Server site<\/a>.<\/p>\n<p>We will walk through publishing referenced layers from ArcGIS Pro to ArcGIS Enterprise. Next, you can connect with ArcGIS Enterprise using ArcGIS for Excel and bring referenced feature layer data to Excel for editing. Edits made in the Excel worksheet directly update the ArcGIS layer in Enterprise and the database or Enterprise geodatabase, depending on which source database you are connected to. Currently, editing reference layers using ArcGIS for Excel is supported for layers created by Microsoft SQL Server, Oracle, PostgreSQL databases. Check the <a href=\"https:\/\/doc.arcgis.com\/en\/excel\/latest\/get-started\/install-and-manage-arcgis-for-excel.htm\">documentation<\/a> for supported ArcGIS Enterprise versions with ArcGIS for Excel.<\/p>\n"},{"acf_fc_layout":"content","content":"<p>&nbsp;<\/p>\n<p><strong>Publishing Non hosted Feature layers from ArcGIS Pro to Enterprise<\/strong><\/p>\n<ul>\n<li>In the Catalog pane, right-click on Databases and select &#8220;Add Database Connection&#8221; &#8211; Enter your database connection parameters including server name, instance, authentication details, and database name. Once connected, you&#8217;ll see your database feature classes and tables in the Catalog pane.<\/li>\n<\/ul>\n<ul>\n<li>Add the Database Layer to your Map &#8211; Drag and drop the database feature class from the Catalog onto your map.<\/li>\n<\/ul>\n<ul>\n<li>Publish as a Reference Layer to Enterprise &#8211; On the Share tab, click on &#8220;Web Layer&#8221;. Select &#8220;Feature&#8221; as the layer type. Select the \u201cReference registered data&#8221; option instead of &#8220;Copy all data&#8221;. Configure sharing settings for your organization. Complete the publishing operation to create your reference layer in ArcGIS Enterprise.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"content","content":"<p><strong>Bringing your Non hosted Feature layers of Enterprise into Excel<\/strong><\/p>\n<p>Sign-In to ArcGIS for Excel, open Layers and select \u2018Add from ArcGIS\u2019.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2858562,"id":2858562,"title":"ArcGIS forExcel_AdddataArcGIS","filename":"ArcGIS-forExcel_AdddataArcGIS.jpg","filesize":68032,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\/arcgis-forexcel_adddataarcgis","alt":"","author":"252692","description":"","caption":"","name":"arcgis-forexcel_adddataarcgis","status":"inherit","uploaded_to":2854352,"date":"2025-06-25 20:29:30","modified":"2025-06-25 20:29:30","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":647,"height":564,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS.jpg","medium-width":299,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS.jpg","medium_large-width":647,"medium_large-height":564,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS.jpg","large-width":647,"large-height":564,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS.jpg","1536x1536-width":647,"1536x1536-height":564,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS.jpg","2048x2048-width":647,"2048x2048-height":564,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS-533x465.jpg","card_image-width":533,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-forExcel_AdddataArcGIS.jpg","wide_image-width":647,"wide_image-height":564}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>After selecting \u00a0to add the attribute data to Excel and layer to map , the attribute data from your ArcGIS layer will be added to a new Excel worksheet, and the ArcGIS layer will be added to the ArcGIS for Excel map.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2858272,"id":2858272,"title":"ArcGISForExcel_AddAttributedata3","filename":"ArcGISForExcel_AddAttributedata3.jpg","filesize":80331,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\/arcgisforexcel_addattributedata3","alt":"","author":"252692","description":"","caption":"","name":"arcgisforexcel_addattributedata3","status":"inherit","uploaded_to":2854352,"date":"2025-06-25 20:12:31","modified":"2025-06-25 20:12:31","menu_order":0,"mime_type":"image\/jpeg","type":"image","subtype":"jpeg","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":699,"height":605,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3.jpg","medium-width":302,"medium-height":261,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3.jpg","medium_large-width":699,"medium_large-height":605,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3.jpg","large-width":699,"large-height":605,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3.jpg","1536x1536-width":699,"1536x1536-height":605,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3.jpg","2048x2048-width":699,"2048x2048-height":605,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3-537x465.jpg","card_image-width":537,"card_image-height":465,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGISForExcel_AddAttributedata3.jpg","wide_image-width":699,"wide_image-height":605}},"image_position":"left-center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":"<p>Any edits made in the spreadsheet, on this \u00a0attribute data, will be synchronized with the layer in ArcGIS and updated in the non-hosted layer in both ArcGIS Enterprise and the source database. Any delete operations on the Excel \u00a0spreadsheet will require confirmation \u00a0through a dialog prompt in the add-in task pane, before the delete is synchronized to the database<\/p>\n<p>Editing in ArcGIS for Excel requires that editing is enabled for your non hosted feature layer. Editing feature layer attribute data in Excel requires a user type of Contributor or higher. Once the data is in Excel, any edits you make directly update the ArcGIS layer in ArcGIS Enterprise and its underlying database, provided you have the necessary read and write permissions. Remember that field management operations set in ArcGIS will be honored in Excel. For example, if a field has &#8220;Unique&#8221; set to &#8220;Yes&#8221; in ArcGIS, you won&#8217;t be able to add duplicate values in Excel.<\/p>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"content","content":"<p><strong>Known Limitations<\/strong><\/p>\n<p>Even \u00a0as the owner of the layer, you can&#8217;t add new columns, rename column names, or delete columns, if those operations are restricted. In ArcGIS for Excel, non-hosted (reference) layers have restrictions on \u00a0schema modifications to maintain data source integrity. If you need to add new columns, rename column names, or delete columns, \u00a0it should be done directly in the original database.<\/p>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"content","content":"<p><strong>Benefits of using ArcGIS Reference layers in Excel<\/strong><\/p>\n<ul>\n<li>Provides familiar interface for Excel users to edit ArcGIS reference layers in Excel without leaving the Excel environment.<\/li>\n<li>Changes made in Excel are written directly back to the source database through the reference layer connection. Users can combine both Excel&#8217;s data analysis features and ArcGIS for Excel&#8217;s GIS capabilities to perform spatial data analysis directly in Excel.<\/li>\n<li>You can add new rows to the ArcGIS reference layer data in Excel, which will be directly added to the source database table as new entries. The corresponding features associated with these new rows will be added to the map. For more details on adding new rows to a feature layer attribute table in an Excel worksheet, please refer to the <a href=\"https:\/\/doc.arcgis.com\/en\/microsoft-365\/latest\/excel\/add-arcgis-layer-data-to-excel.htm#ESRI_SECTION1_C666F5A207FD435A87A9792530079216\">documentation.<\/a><\/li>\n<li>Allows \u00a0editing of reference layers from various databases within a single workbook, saving time and making data management easier.<\/li>\n<li>Make consistent changes across hundreds of records is much faster and simpler in Excel, especially with the ability to copy, cut, and paste data functions.<\/li>\n<li>Excel&#8217;s built-in data validation tools help maintain data quality and integrity before it is saved in the database.<\/li>\n<li>Data management and no data duplication &#8211; data remains in its original source such as database is reference by web services so whatever edit you&#8217;re performing on the reference data in the Excel is directly reflected in the database and you&#8217;re not creating a copy of your database data in the Excel.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n"},{"acf_fc_layout":"content","content":"<p><strong>Demonstration<\/strong><\/p>\n<p>In the video shown below, the following operations are demonstrated:<\/p>\n<ul>\n<li>Publishing ArcGIS referenced layer from ArcGIS Pro to Enterprise,<\/li>\n<li>Bringing ArcGIS referenced layer from Enterprise to Excel for editing,<\/li>\n<li>Adding a new row to the ArcGIS referenced data in Excel,<\/li>\n<li>Excel Filtering,<\/li>\n<li>Using the Spatial Filtering tool with ArcGIS referenced data.<\/li>\n<\/ul>\n"},{"acf_fc_layout":"kaltura","video_id":"1_kix1r2aa","time":false,"start":0,"stop":""},{"acf_fc_layout":"content","content":"<p>&nbsp;<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>In this article, we have reviewed how easily it is to add your ArcGIS non hosted feature layer data in Excel for data editing. Please try\u00a0<a href=\"https:\/\/doc.arcgis.com\/en\/microsoft-365\/latest\/excel\/get-started-with-arcgis-for-excel.htm\">ArcGIS for Excel<\/a>\u00a0and share your experience and feedback in the comment area below. Your feedback can be used to help improve the software.<\/p>\n"}],"related_articles":[{"ID":2039302,"post_author":"252692","post_date":"2023-08-01 13:59:36","post_date_gmt":"2023-08-01 20:59:36","post_content":"","post_title":"Add and Edit ArcGIS Layer Attribute Data in an Excel Worksheet","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"add-and-edit-arcgis-layer-attribute-data-in-an-excel-worksheet","to_ping":"","pinged":"","post_modified":"2025-11-05 11:37:29","post_modified_gmt":"2025-11-05 19:37:29","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=2039302","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"8","filter":"raw"},{"ID":1790052,"post_author":"252692","post_date":"2022-12-08 12:33:44","post_date_gmt":"2022-12-08 20:33:44","post_content":"","post_title":"Visualize Aggregated Pivot Table data in ArcGIS for Excel","post_excerpt":"","post_status":"publish","comment_status":"open","ping_status":"closed","post_password":"","post_name":"pivot-table-data-in-arcgis-for-excel-map","to_ping":"","pinged":"","post_modified":"2024-10-18 16:44:56","post_modified_gmt":"2024-10-18 23:44:56","post_content_filtered":"","post_parent":0,"guid":"https:\/\/www.esri.com\/arcgis-blog\/?post_type=blog&#038;p=1790052","menu_order":0,"post_type":"blog","post_mime_type":"","comment_count":"0","filter":"raw"}]},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using ArcGIS for Excel to Edit Referenced Data<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using ArcGIS for Excel to Edit Referenced Data\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\" \/>\n<meta property=\"og:site_name\" content=\"ArcGIS Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/esrigis\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-05T00:16:54+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ESRI\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\"},\"author\":{\"name\":\"Gaurav Singh\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32\"},\"headline\":\"Using ArcGIS for Excel to Edit Referenced Data\",\"datePublished\":\"2025-07-01T20:09:58+00:00\",\"dateModified\":\"2025-11-05T00:16:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\"},\"wordCount\":8,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"keywords\":[\"ArcGIS for Excel\",\"ArcGIS for Microsoft 365\",\"database\",\"Edit ArcGIS Layer data in Excel\",\"enterprise geodatabase\"],\"articleSection\":[\"Analytics\",\"Data Management\",\"Government\",\"Local Government\",\"Water\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\",\"name\":\"Using ArcGIS for Excel to Edit Referenced Data\",\"isPartOf\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\"},\"datePublished\":\"2025-07-01T20:09:58+00:00\",\"dateModified\":\"2025-11-05T00:16:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.esri.com\/arcgis-blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using ArcGIS for Excel to Edit Referenced Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#website\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"name\":\"ArcGIS Blog\",\"description\":\"Get insider info from Esri product teams\",\"publisher\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#organization\",\"name\":\"Esri\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png\",\"width\":400,\"height\":400,\"caption\":\"Esri\"},\"image\":{\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/esrigis\/\",\"https:\/\/x.com\/ESRI\",\"https:\/\/www.linkedin.com\/company\/5311\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32\",\"name\":\"Gaurav Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg\",\"contentUrl\":\"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg\",\"caption\":\"Gaurav Singh\"},\"description\":\"Sr. Product Engineer in the ArcGIS for Microsoft365 group.\",\"url\":\"https:\/\/www.esri.com\/arcgis-blog\/author\/gsingh\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using ArcGIS for Excel to Edit Referenced Data","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data","og_locale":"en_US","og_type":"article","og_title":"Using ArcGIS for Excel to Edit Referenced Data","og_url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data","og_site_name":"ArcGIS Blog","article_publisher":"https:\/\/www.facebook.com\/esrigis\/","article_modified_time":"2025-11-05T00:16:54+00:00","twitter_card":"summary_large_image","twitter_site":"@ESRI","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#article","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data"},"author":{"name":"Gaurav Singh","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32"},"headline":"Using ArcGIS for Excel to Edit Referenced Data","datePublished":"2025-07-01T20:09:58+00:00","dateModified":"2025-11-05T00:16:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data"},"wordCount":8,"commentCount":0,"publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"keywords":["ArcGIS for Excel","ArcGIS for Microsoft 365","database","Edit ArcGIS Layer data in Excel","enterprise geodatabase"],"articleSection":["Analytics","Data Management","Government","Local Government","Water"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data","url":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data","name":"Using ArcGIS for Excel to Edit Referenced Data","isPartOf":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#website"},"datePublished":"2025-07-01T20:09:58+00:00","dateModified":"2025-11-05T00:16:54+00:00","breadcrumb":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.esri.com\/arcgis-blog\/"},{"@type":"ListItem","position":2,"name":"Using ArcGIS for Excel to Edit Referenced Data"}]},{"@type":"WebSite","@id":"https:\/\/www.esri.com\/arcgis-blog\/#website","url":"https:\/\/www.esri.com\/arcgis-blog\/","name":"ArcGIS Blog","description":"Get insider info from Esri product teams","publisher":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.esri.com\/arcgis-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.esri.com\/arcgis-blog\/#organization","name":"Esri","url":"https:\/\/www.esri.com\/arcgis-blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2018\/04\/Esri.png","width":400,"height":400,"caption":"Esri"},"image":{"@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/esrigis\/","https:\/\/x.com\/ESRI","https:\/\/www.linkedin.com\/company\/5311\/"]},{"@type":"Person","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/e581c3c49c1f598179c1ef658d86ec32","name":"Gaurav Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.esri.com\/arcgis-blog\/#\/schema\/person\/image\/","url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg","contentUrl":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/12\/Ph3-213x200.jpg","caption":"Gaurav Singh"},"description":"Sr. Product Engineer in the ArcGIS for Microsoft365 group.","url":"https:\/\/www.esri.com\/arcgis-blog\/author\/gsingh"}]}},"text_date":"July 1, 2025","author_name":"Multiple Authors","author_page":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-for-excel\/data-management\/using-arcgis-for-excel-to-edit-referenced-data","custom_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2025\/06\/ArcGIS-for-Microsoft-365-BANNER-Edit-Referenced-Data.jpg","primary_product":"ArcGIS for Excel","tag_data":[{"term_id":766102,"name":"ArcGIS for Excel","slug":"arcgis-for-excel","term_group":0,"term_taxonomy_id":766102,"taxonomy":"post_tag","description":"","parent":0,"count":16,"filter":"raw"},{"term_id":761562,"name":"ArcGIS for Microsoft 365","slug":"arcgis-for-microsoft-365","term_group":0,"term_taxonomy_id":761562,"taxonomy":"post_tag","description":"","parent":0,"count":30,"filter":"raw"},{"term_id":763732,"name":"database","slug":"database","term_group":0,"term_taxonomy_id":763732,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":780162,"name":"Edit ArcGIS Layer data in Excel","slug":"edit-arcgis-layer-data-in-excel","term_group":0,"term_taxonomy_id":780162,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":767792,"name":"enterprise geodatabase","slug":"enterprise-geodatabase","term_group":0,"term_taxonomy_id":767792,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"}],"category_data":[{"term_id":23341,"name":"Analytics","slug":"analytics","term_group":0,"term_taxonomy_id":23341,"taxonomy":"category","description":"","parent":0,"count":1329,"filter":"raw"},{"term_id":23851,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":23851,"taxonomy":"category","description":"","parent":0,"count":920,"filter":"raw"},{"term_id":22851,"name":"Government","slug":"national-government","term_group":0,"term_taxonomy_id":22851,"taxonomy":"category","description":"","parent":0,"count":413,"filter":"raw"},{"term_id":22841,"name":"Local Government","slug":"local-government","term_group":0,"term_taxonomy_id":22841,"taxonomy":"category","description":"","parent":0,"count":557,"filter":"raw"},{"term_id":23051,"name":"Water","slug":"water","term_group":0,"term_taxonomy_id":23051,"taxonomy":"category","description":"","parent":0,"count":463,"filter":"raw"}],"product_data":[{"term_id":766382,"name":"ArcGIS for Excel","slug":"arcgis-for-excel","term_group":0,"term_taxonomy_id":766382,"taxonomy":"product","description":"","parent":36591,"count":21,"filter":"raw"},{"term_id":770122,"name":"ArcGIS for Microsoft 365","slug":"microsoft-365","term_group":0,"term_taxonomy_id":770122,"taxonomy":"product","description":"","parent":36591,"count":44,"filter":"raw"}],"primary_product_link":"https:\/\/www.esri.com\/arcgis-blog\/?s=#&products=arcgis-for-excel","_links":{"self":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2854352","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/types\/blog"}],"author":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/users\/252692"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/comments?post=2854352"}],"version-history":[{"count":0,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/blog\/2854352\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/media?parent=2854352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/categories?post=2854352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/tags?post=2854352"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/industry?post=2854352"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.esri.com\/arcgis-blog\/wp-json\/wp\/v2\/product?post=2854352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}