{"id":2655,"date":"2012-09-07T09:41:54","date_gmt":"2012-09-07T09:41:54","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=2655"},"modified":"2012-09-07T09:41:54","modified_gmt":"2012-09-07T09:41:54","slug":"gumu-for-sage-crm-advanced-excel-import","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/","title":{"rendered":"GUMU for Sage CRM- Advanced Excel Import"},"content":{"rendered":"<p>Greytrix has launched a new add-on \u201c<strong>GUMU&#x2122; for Sage CRM &#8211; Advanced Excel import<\/strong>\u201d, which unlocks the capability to import large Excel data into Sage CRM. This tool imports data for Company, Person, Address, Email and Phone entities from Excel to Sage CRM and is very simple and easy to use tool. This tool will works with Sage CRM Desktop as well as Cloud version.<\/p>\n<p style=\"text-align: center;\">\u00a0<a title=\"Export your ACT Notes with Greytrix Sage ACT Export Notes Utility\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/07\/export-your-act-notes-with-greytrix-sage-act-export-notes-utility\/\" target=\"_blank\">Export your ACT Notes with Greytrix Sage ACT Export Notes Utility<\/a><\/p>\n<p style=\"text-align: center;\">\u00a0<a title=\"Migration of Sage ACT notes in Sage CRM using GUMU\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/06\/07\/migration-of-sage-act-notes-in-sage-crm-using-gumu\/\" target=\"_blank\">Migration of Sage ACT notes in Sage CRM using GUMU<\/a><\/p>\n<p>You just have to specify the excel file, map the Source Field with Target CRM Field (on Standard Field Mapping Screen) and click on the start button.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg\" target=\"_blank\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-2656\" title=\"Advanced Excel Import Screen\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg\" alt=\"\" width=\"557\" height=\"271\" \/><\/a><\/p>\n<p style=\"text-align: left;\"><strong>Key features of Advance Excel import are as follows:<\/strong><\/p>\n<p style=\"text-align: left;\"><strong><\/strong>1.\u00a0Excel supported version 2003 and higher (i.e.\u00a0 XLS and XLSX files)<br \/>\n2. Import data from any worksheet from multiple worksheets.<br \/>\n3.\u00a0Imports Entities like Company and Person with related address, phone and email entities.<br \/>\n4.\u00a0Allow User to import bulk data from Excel.<br \/>\n5.\u00a0User can Map (any column) fields with Sage CRM fields.<br \/>\n6.\u00a0User can save mapping setting and load the saved mapping for future use of the utility.<br \/>\n7.\u00a0Setting can be easily modified with Mapping Screen.<\/p>\n<p style=\"text-align: left;\"><strong>A glimpse of the Standard Mapping Screen;<\/strong><\/p>\n<p style=\"text-align: left;\"><strong><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/2.MappingScreen1.jpg\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-2662\" title=\"Standard Field mapping Screen\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/2.MappingScreen1.jpg\" alt=\"\" width=\"586\" height=\"415\" \/><\/a><\/strong><\/p>\n<p style=\"text-align: center;\">\n<p style=\"text-align: left;\">Below Sage CRM Screen shows how Excel data will look after importing into Sage CRM.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/3.bmp\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter  wp-image-2663\" title=\"SageCRM _SummaryScreen\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/3.bmp\" alt=\"\" width=\"716\" height=\"297\" \/><\/a><\/p>\n<p style=\"text-align: center;\">\n<p style=\"text-align: left;\">If there is any additional requirement, the utility can always be customized as per the needs. For more detail you can write to us on<strong> <a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Greytrix has launched a new add-on \u201cGUMU&#x2122; for Sage CRM &#8211; Advanced Excel import\u201d, which unlocks the capability to import large Excel data into Sage CRM. This tool imports data for Company, Person, Address, Email and Phone entities from Excel to Sage CRM and is very simple and easy to use tool. This tool will\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[184,244],"tags":[498,838,1108,2010],"class_list":["post-2655","post","type-post","status-publish","format-standard","hentry","category-import-sage-crm","category-migration-2","tag-act-notes","tag-crmmig","tag-excel-import","tag-sage-crm"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GUMU for Sage CRM- Advanced Excel Import - Sage CRM \u2013 Tips, Tricks and Components<\/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.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GUMU for Sage CRM- Advanced Excel Import - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Greytrix has launched a new add-on \u201cGUMU&#x2122; for Sage CRM &#8211; Advanced Excel import\u201d, which unlocks the capability to import large Excel data into Sage CRM. This tool imports data for Company, Person, Address, Email and Phone entities from Excel to Sage CRM and is very simple and easy to use tool. This tool will\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-09-07T09:41:54+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/\",\"name\":\"GUMU for Sage CRM- Advanced Excel Import - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg\",\"datePublished\":\"2012-09-07T09:41:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GUMU for Sage CRM- Advanced Excel Import\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GUMU for Sage CRM- Advanced Excel Import - Sage CRM \u2013 Tips, Tricks and Components","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.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/","og_locale":"en_US","og_type":"article","og_title":"GUMU for Sage CRM- Advanced Excel Import - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Greytrix has launched a new add-on \u201cGUMU&#x2122; for Sage CRM &#8211; Advanced Excel import\u201d, which unlocks the capability to import large Excel data into Sage CRM. This tool imports data for Company, Person, Address, Email and Phone entities from Excel to Sage CRM and is very simple and easy to use tool. This tool will\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-09-07T09:41:54+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/","name":"GUMU for Sage CRM- Advanced Excel Import - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg","datePublished":"2012-09-07T09:41:54+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/09\/1.Excel-format.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/09\/07\/gumu-for-sage-crm-advanced-excel-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"GUMU for Sage CRM- Advanced Excel Import"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/2655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=2655"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/2655\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=2655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=2655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=2655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}