You have access to more data than ever before!<\/p>\n
In today\u2019s data-driven world, we are surrounded by a remarkable wealth of information. As a GIS professional, you engage with diverse data types, collection methods, and storage formats.\u00a0\u00a0With countless external data sources\u2014such as Microsoft Excel\u2014available at your fingertips, the potential for uncovering fresh insights and enhancing your geospatial projects is boundless.<\/p>\n
While the topic Install the drivers to work with Microsoft Excel files in ArcGIS Pro<\/a> guides you through the installation and use of Excel files in ArcGIS Pro, I understand that you might have lingering questions, such as:<\/p>\n <\/p>\n Let\u2019s dive in and uncover the answers together!<\/p>\n"},{"acf_fc_layout":"content","content":" Using Excel data can enhance or add value to other geographic information you\u2019re working with. Microsoft Excel can help you organize, calculate, and analyze data in a spreadsheet format. Adding an Excel spreadsheet to ArcGIS Pro allows you to combine tabular data with spatial data, enhance analysis and visualization capabilities, and uncover insights that may not be immediately apparent from the data table alone, such as the following map, which displays confirmed COVID-19 cases reported worldwide during the height of the pandemic.<\/p>\n"},{"acf_fc_layout":"image","image":{"ID":2624802,"id":2624802,"title":"WorldMap_Coronavirus_cases","filename":"WorldMap_Coronavirus_cases-scaled.jpg","filesize":266436,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-scaled.jpg","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/guide-to-connecting-to-excel-files-in-arcgis-pro\/worldmap_coronavirus_cases","alt":"World map of Coronavirus Covid-19, Covid-19 map confirmed cases reported worldwide globally.","author":"12901","description":"World map of Coronavirus Covid-19, Covid-19 map confirmed cases reported worldwide globally.","caption":"World map of Coronavirus Covid-19, Covid-19 map confirmed cases reported worldwide globally.","name":"worldmap_coronavirus_cases","status":"inherit","uploaded_to":1012592,"date":"2024-12-13 10:06:56","modified":"2024-12-31 19:56:36","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":2560,"height":1211,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-213x200.jpg","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-scaled.jpg","medium-width":464,"medium-height":219,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-scaled.jpg","medium_large-width":768,"medium_large-height":363,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-scaled.jpg","large-width":1920,"large-height":908,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-1536x727.jpg","1536x1536-width":1536,"1536x1536-height":727,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-2048x969.jpg","2048x2048-width":2048,"2048x2048-height":969,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-826x391.jpg","card_image-width":826,"card_image-height":391,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2022\/06\/WorldMap_Coronavirus_cases-1920x908.jpg","wide_image-width":1920,"wide_image-height":908}},"image_position":"center","orientation":"horizontal","hyperlink":""},{"acf_fc_layout":"content","content":" You do not<\/strong> need Microsoft Office installed on your machine to access an Excel spreadsheet from ArcGIS Pro.<\/p>\n"},{"acf_fc_layout":"content","content":" The ArcGIS Pro 3.4 and 3.3 releases require<\/strong> a software component called the Microsoft .NET Desktop Runtime (version 8.0.2) 64-bit to be installed on your computer before ArcGIS Pro can be installed. If you have an earlier version, such as ArcGIS Pro 3.2 – 3.0, the Microsoft .NET Desktop Runtime (version 6.0.5) 64-bit must be installed.<\/p>\n"},{"acf_fc_layout":"blockquote","content":" The only requirement to access and work with\u00a0Excel\u00a0files in\u00a0ArcGIS Pro is that the appropriate Microsoft drivers must be downloaded and installed correctly on the computer on which ArcGIS Pro\u00a0is installed.<\/p>\n"},{"acf_fc_layout":"content","content":" Are you curious about which Microsoft drivers you might need to install? Read on to question 4<\/a>!<\/p>\n Some configurations may require you to install an additional driver silently before you can access Excel files from ArcGIS Pro. See question 7<\/a>\u00a0to learn more about silent installations.<\/p>\n"},{"acf_fc_layout":"content","content":" Depending on whether your machine has Microsoft Office, you might need to install additional software called drivers to access Excel files properly. Microsoft drivers help bridge communication and data transfers between files proprietary to the Microsoft Office system and other non-Microsoft Office applications, such as ArcGIS Pro.<\/p>\n Two primary Microsoft drivers can be installed if needed:<\/p>\n To determine the best driver to install, you must first answer the following questions about the machine where ArcGIS Pro is installed.<\/p>\n Microsoft Office is installed in one of two ways: MSI or Click-to-Run (CTR). A Microsoft Installer (MSI) file, which more recently is referred to as a Windows Installer file, is typically one large download file containing the installer and all the Office components. Microsoft Office (CTR) is an alternative to the traditional (MSI) installer-based method and uses streaming and virtualization technology to install and launch Office products faster. Knowing the type of installer used is important because Microsoft Office products installed using CTR (such as Microsoft Office 365) can prevent the installation of specific drivers if your Microsoft Office is already set up with it.<\/span> You also need to know the bit-level installed for these Microsoft products. This information is essential because if you try to install the downloaded AccessDatabaseEngine.exe file on a machine that already has a Microsoft 64-bit application, you will get an error message saying you can’t install a 32-bit version of the database engine because you currently have 64-bit Office products installed. A similar error message will display if you try installing the AccessDatabaseEngine_X64.exe file on a machine with a Microsoft 32-bit application.\u00a0\u00a0<\/span><\/span><\/p>\n For more information,\u00a0choose<\/span><\/a><\/span>\u00a0between the 64-bit or 32-bit version of Office<\/a>. Instructions:<\/span> Click the\u00a0About Word<\/span><\/strong> icon. Clicking the icon will open the About Microsoft Word<\/strong> window. The top line contains the combined version and build number; at the end, it displays 32-bit or 64-bit.<\/span><\/span><\/p>\n<\/details>\n"},{"acf_fc_layout":"image","image":{"ID":1014792,"id":1014792,"title":"AboutWord_bit_level_combo1","filename":"AboutWord_bit_level_combo1.png","filesize":11741,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/guide-to-connecting-to-excel-files-in-arcgis-pro\/aboutword_bit_level_combo1","alt":"About Microsoft Word for Office full version number","author":"12901","description":"","caption":"","name":"aboutword_bit_level_combo1","status":"inherit","uploaded_to":1012592,"date":"2020-09-21 17:51:22","modified":"2020-09-21 17:59:15","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":399,"height":217,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1-213x200.png","thumbnail-width":213,"thumbnail-height":200,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","medium-width":399,"medium-height":217,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","medium_large-width":399,"medium_large-height":217,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","large-width":399,"large-height":217,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","1536x1536-width":399,"1536x1536-height":217,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","2048x2048-width":399,"2048x2048-height":217,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","card_image-width":399,"card_image-height":217,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png","wide_image-width":399,"wide_image-height":217}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_bit_level_combo1.png"},{"acf_fc_layout":"content","content":" 5. How do I use the decision tree guides?<\/strong><\/p>\n Based on your answers to the above questions, use the following decision tree guides to help you determine if a driver needs to be installed and, if so, which driver(s) should be installed.<\/p>\n Some configurations may require a silent installation<\/a> to successfully install an additional driver before accessing Excel files from ArcGIS Pro.<\/p>\n ArcGIS Pro 3.4<\/strong><\/a><\/p>\n ArcGIS Pro 3.3\u00a0<\/a><\/strong><\/p>\n ArcGIS Pro 3.0 – 3.2<\/a><\/strong><\/p>\n\n
1. What are the advantages of using Excel tables with ArcGIS Pro?<\/strong><\/h3>\n
Click here to access a list of blogs and tutorials using Excel data in ArcGIS.<\/span><\/strong><\/span><\/summary>\n
\n
\n
2. Do I need to have Microsoft Office installed to open Excel files in ArcGIS Pro?<\/strong><\/h3>\n
3. Are there prerequisites I must complete before I can open Excel files in ArcGIS Pro?<\/strong><\/h3>\n
4. How do I determine the right Microsoft driver to install?\u00a0<\/strong><\/h3>\n
Supported Microsoft Drivers<\/strong><\/h4>\n
\n
\n
\n
Client machine details<\/strong><\/h4>\n
\n
\n
\n
\n
\n
Click here to learn more about MSI vs. Click-to-Run (CTR) installers and how to identify the type used for Microsoft products on your machine.<\/u><\/span><\/summary>\n
\n
\n<\/strong>Follow these instructions to determine if the installer type is MSI or Click-to-Run (CTR) for your Microsoft products.
\n<\/strong>Note: These instructions apply to any Office app (Word, Excel, etc.).<\/em><\/span>
\n<\/strong>
\n<\/strong>Instructions:\u00a0Using Word, choose\u00a0<\/span>File<\/span><\/strong>\u00a0and then select\u00a0<\/span>Account<\/span><\/strong>. The Product Information section within About Word will either show Click-to-Run or nothing after the build number. If nothing is after the build number, it’s an MSI install; otherwise, “Click-to-Run” will display if this installer type was used.
\n<\/span><\/span><\/p>\n<\/details>\n"},{"acf_fc_layout":"image","image":{"ID":1013622,"id":1013622,"title":"AboutWord_Combo_msi_ctr","filename":"AboutWord_Combo_msi_ctr.png","filesize":9254,"url":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","link":"https:\/\/www.esri.com\/arcgis-blog\/products\/arcgis-pro\/data-management\/guide-to-connecting-to-excel-files-in-arcgis-pro\/aboutword_combo_msi_ctr","alt":"Microsoft Word version, build and installer type details","author":"12901","description":"","caption":"","name":"aboutword_combo_msi_ctr","status":"inherit","uploaded_to":1012592,"date":"2020-09-19 07:22:42","modified":"2020-09-19 07:22:59","menu_order":0,"mime_type":"image\/png","type":"image","subtype":"png","icon":"https:\/\/www.esri.com\/arcgis-blog\/wp-includes\/images\/media\/default.png","width":403,"height":193,"sizes":{"thumbnail":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr-213x193.png","thumbnail-width":213,"thumbnail-height":193,"medium":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","medium-width":403,"medium-height":193,"medium_large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","medium_large-width":403,"medium_large-height":193,"large":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","large-width":403,"large-height":193,"1536x1536":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","1536x1536-width":403,"1536x1536-height":193,"2048x2048":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","2048x2048-width":403,"2048x2048-height":193,"card_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","card_image-width":403,"card_image-height":193,"wide_image":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png","wide_image-width":403,"wide_image-height":193}},"image_position":"center","orientation":"horizontal","hyperlink":"https:\/\/www.esri.com\/arcgis-blog\/app\/uploads\/2020\/09\/AboutWord_Combo_msi_ctr.png"},{"acf_fc_layout":"content","content":"\n
Click here to learn more about 64-bit and 32-bit levels and how to identify the bit level of the Microsoft products installed on your machine<\/span>.<\/span><\/span><\/summary>\n
\n
\n<\/strong>Follow these instructions to determine if the Microsoft products were installed as 64-bit or 32-bit.
\n<\/strong>N<\/em><\/span>ote: These instructions apply to any Office app (Word, Excel, etc.).<\/em><\/span>
\n<\/strong><\/span><\/p>\nArcGIS Pro version-specific driver decision guide<\/strong><\/h4>\n
\n
\n
\n
\n
\n
\n
\n