![\"\"](\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/03\/211.png?resize=630%2C348&ssl=1\")
<\/figure>\n\n\n\nWhat you have to\nknow…<\/strong> <\/p>\n\n\n\n Excel to Table supports the input of Excel Workbook (.xlsx)\nand Microsoft Excel 5.0 \/ 95 (.xls) Workbook formats. <\/p>\n\n\n\n The tool assumes that the tabular data is sorted vertically.\nThe first line is used for the field names of the output\ntable. These field names can be renamed during the validation\nprocess to avoid errors or duplication of names. The\nempty columns between the data are kept and a generic field name is assigned to\nthem (for example, field_4). In our example, we have to start\nby eliminating the title lines and keep only the data table with the field\nnames row. <\/p>\n\n\n\n Each field must have a uniform data type. Supported\ndata types include floating, text, date, and Boolean fields. However Boolean fields are stored as short paths. \n\nThe example table has\nmultiple sheets. In\nthis case, do not forget to eliminate the title lines in all the sheets you\nwant to use in ArcMap. \n\n\n\n<\/p>\n\n\n\n How to import the\nExcel table<\/strong> \n\nYou will find the Excel import\nand export commands in the Conversion Tools -> Excel<\/em> toolbox \n\n\n\n<\/p>\n\n\n\n \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe\nsetting window opens: \n\n\n\n<\/p>\n\n\n\n You specify the input Excel file. <\/p>\n\n\n\n You specify the output table. There\nyou have two options. The ideal is a table in a\ngeodatabase. You will have comprehensive field\nnames as well as all the commands linked to the geodatabases SQL.\nThe worst is a dbf table. If\nyou choose this option, you will enter a table name in a directory (not in a\ngeodatabase) and, most importantly, you should not forget to add the .dbf\nextension. If you don\u2019t, it will not work. However,\nremember that dbf tables have field name length limits and a limited version of\nsql commands. <\/p>\n\n\n\n Tip: If you have not already done this, switch to geodatabase\nmode … <\/p>\n\n\n\n You select the sheet you want to import from the drop-down\nmenu, and click OK \n\nYou find your table in ArcMap: \n\n\n\n<\/p>\n\n\n\n How to convey an\nArcGis table to an Excel table<\/strong> \n\nNow, we will discuss the\nopposite command: we will create an Excel table from our new ArcGis table. Easy peasy: input table and Excel workbook as output.\n\n\nWe find an Excel table quite right: \n\n\n\n<\/p>\n\n\n\n There is an increasing co-work between ArcGis and Excel. Indeed, the information management is infinitely richer with a spreadsheet such as Excel than with an ArcGis tabular view. It has always been possible to load an…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1260],"tags":[],"class_list":["post-8360","post","type-post","status-publish","format-standard","hentry","category-non-classe-en"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-2aQ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/8360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=8360"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/8360\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=8360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=8360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=8360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/03\/212.png?resize=630%2C338&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/03\/213.png?resize=339%2C190&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/03\/214.png?resize=630%2C315&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/03\/215.png?resize=630%2C153&ssl=1\")
<\/figure>\n\n\n\n
\nTo\nperform this action, we click on the other tool of the toolbox Data\nManagement-> Excel-> Table to Excel<\/em><\/p>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/03\/216.png?resize=630%2C314&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/03\/217.png?resize=630%2C339&ssl=1\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"