{"id":12617,"date":"2021-07-23T11:40:29","date_gmt":"2021-07-23T09:40:29","guid":{"rendered":"https:\/\/www.mydral.com\/?p=12617"},"modified":"2026-08-24T15:38:38","modified_gmt":"2026-08-24T13:38:38","slug":"white-paper-from-excel-to-knime","status":"publish","type":"post","link":"https:\/\/www.mydral.com\/en\/white-paper-from-excel-to-knime\/","title":{"rendered":"White Paper : from Excel to KNIME"},"content":{"rendered":"<div class=\"entry-header\">\r\n<h2 class=\"entry-title\" style=\"text-align: center;\"><span style=\"color: #ff6600;\">&#x1f4d8; From Excel to KNIME : translating Excel Functionality into KNIME Analytics Platform.<\/span><\/h2>\r\n<\/div>\r\n&nbsp;\r\n<h5>Download our whitepaper about the the most commonly used Excel functions to their KNIME equivalents<\/h5>\r\n&nbsp;\r\n\r\n<span style=\"font-weight: 300;\">This easy to follow guide can help you transition <span style=\"color: #000000;\">from Excel to KNIME.<\/span> It maps the most commonly used Excel functions and techniques to their KNIME equivalents, taking you through the steps you\u2019d take in Excel and showing you how they can be done in <span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/www.mydral.com\/en\/knime-uk\/\">KNIME Analytics Platform<\/a><\/span>. Find out, for example, how data reading, filtering, sorting, pivoting, math formulas, and commonly used functions such as vlookup are handled in KNIME.\u00a0<\/span>\r\n<div class=\"entry-header\">\r\n\r\nNo previous knowledge of KNIME is required.\r\n\r\n<\/div>\r\n<h3><\/h3>\r\n<div class=\"ossBlockGroup\" data-children-count=\"0\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"ossBlock col-sm-12\">\r\n<div class=\"ossElement\">\r\n<h4 class=\"field field--name-field-heading field--type-text-long field--label-hidden margin-bottom-none text--centered\" style=\"text-align: center;\"><strong><span style=\"color: #ff6600;\">Download your free copy here <\/span><\/strong><strong><span style=\"color: #ff6600;\">&#x1f447;<\/span><\/strong><\/h4>\r\n<p style=\"text-align: center;\"><div class='_form_441'><\/div><script type='text\/javascript' src='https:\/\/analyticslm.activehosted.com\/f\/embed.php?static=0&id=441&6B00B8BD78E31&nostyles=0&preview=0'><\/script><\/p>\r\n\r\n<\/div>\r\n&nbsp;\r\n\r\n<span style=\"color: #ff6600;\">About KNIME\u00a0<\/span>\r\n\r\nKNIME is designed to provide fast, simple and interactive access to data prep and data science. Allowing companies to embrace innovation. KNIME Analytics Platform is the solution to explore the potential of your data, to easily create workflows to prepare, clean, and enrich your data, to obtain insights for stronger analysis. The solution is unique with a global community gathering more than 60 countries using the solution.\r\n\r\nFollow Mydral on <span style=\"color: #ff6600;\"><a style=\"color: #ff6600;\" href=\"https:\/\/www.linkedin.com\/showcase\/mydral-uk\/\">LinkedIn<\/a><\/span> ! Get can\u2019t-miss events, webinars, insignts and the latest Mydral news.\r\n\r\nRead our latest\u00a0<em>blogs<\/em> posts on the data preparation or other data topics that your business faces. Read hints and tips !\r\n\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<figure class=\"wp-block-image\"><\/figure>\r\n<!-- \/wp:post-content -->","protected":false},"excerpt":{"rendered":"D\u00e9couvrez tout ce qu&rsquo;implique la pr\u00e9paration des donn\u00e9es gr\u00e2ce \u00e0 notre guide !","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"pad_hide_post_author":"","_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[82],"tags":[60,89],"class_list":["post-12617","post","type-post","status-publish","format-standard","hentry","category-actualites","tag-data-prep","tag-knime"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>From Excel to KNIME: white paper to translate the most common functions<\/title>\n<meta name=\"description\" content=\"From Excel to KNIME or from Spreadsheets to Workflows ! KNIME is a great alternative to combine data, automate or analyze in a scalable way.\" \/>\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.mydral.com\/en\/white-paper-from-excel-to-knime\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"From Excel to KNIME: white paper to translate the most common functions\" \/>\n<meta property=\"og:description\" content=\"From Excel to KNIME or from Spreadsheets to Workflows ! KNIME is a great alternative to combine data, automate or analyze in a scalable way.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mydral.com\/en\/white-paper-from-excel-to-knime\/\" \/>\n<meta property=\"og:site_name\" content=\"MYDRAL - DATA IS POWER\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/mydral\/?fref=ts\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-23T09:40:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-24T13:38:38+00:00\" \/>\n<meta name=\"author\" content=\"Sylvana AH-LAYE\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/ah_sylvana\" \/>\n<meta name=\"twitter:site\" content=\"@MYDRAL_COM\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sylvana AH-LAYE\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/\"},\"author\":{\"name\":\"Sylvana AH-LAYE\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/ed81c117e4d8d6ae601b61af933c7b5b\"},\"headline\":\"White Paper : from Excel to KNIME\",\"datePublished\":\"2021-07-23T09:40:29+00:00\",\"dateModified\":\"2026-08-24T13:38:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/\"},\"wordCount\":231,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"keywords\":[\"data prep\",\"Knime\"],\"articleSection\":[\"Actualit\u00e9s\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/\",\"name\":\"From Excel to KNIME: white paper to translate the most common functions\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\"},\"datePublished\":\"2021-07-23T09:40:29+00:00\",\"dateModified\":\"2026-08-24T13:38:38+00:00\",\"description\":\"From Excel to KNIME or from Spreadsheets to Workflows ! KNIME is a great alternative to combine data, automate or analyze in a scalable way.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/white-paper-from-excel-to-knime\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.mydral.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"White Paper : from Excel to KNIME\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#website\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/\",\"name\":\"MYDRAL - DATA IS POWER\",\"description\":\"DATA IS POWER\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mydral.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#organization\",\"name\":\"Mydral\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/Mydral_logo.png\",\"contentUrl\":\"https:\\\/\\\/www.mydral.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/Mydral_logo.png\",\"width\":1718,\"height\":1394,\"caption\":\"Mydral\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/mydral\\\/?fref=ts\",\"https:\\\/\\\/x.com\\\/MYDRAL_COM\",\"https:\\\/\\\/www.instagram.com\\\/mydral_com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/10898136\\\/admin\\\/\",\"https:\\\/\\\/www.pinterest.fr\\\/mydral_com\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCpJqoSrQX5b0PRf0H6VRhdg\\\/videos?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mydral.com\\\/#\\\/schema\\\/person\\\/ed81c117e4d8d6ae601b61af933c7b5b\",\"name\":\"Sylvana AH-LAYE\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/15352cb449d94c9bf5c95a7984d04208df83708ca4f6b4b3a0ddffa572e539d9?s=96&d=retro&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/15352cb449d94c9bf5c95a7984d04208df83708ca4f6b4b3a0ddffa572e539d9?s=96&d=retro&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/15352cb449d94c9bf5c95a7984d04208df83708ca4f6b4b3a0ddffa572e539d9?s=96&d=retro&r=g\",\"caption\":\"Sylvana AH-LAYE\"},\"description\":\"Hello ! Passionn\u00e9e du marketing digital, je travaille quotidiennement avec les diff\u00e9rents services de Mydral. Retrouvez dans mes publications du contenu sur le secteur du Big Data, de la BI et de l'IA. Le SEO ou l'e-r\u00e9putation n'ont pas de secrets pour moi !\",\"sameAs\":[\"https:\\\/\\\/www.mydral.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sylvana-ah-laye\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/ah_sylvana\"],\"url\":\"https:\\\/\\\/www.mydral.com\\\/en\\\/author\\\/sylvana\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"From Excel to KNIME: white paper to translate the most common functions","description":"From Excel to KNIME or from Spreadsheets to Workflows ! KNIME is a great alternative to combine data, automate or analyze in a scalable way.","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.mydral.com\/en\/white-paper-from-excel-to-knime\/","og_locale":"en_GB","og_type":"article","og_title":"From Excel to KNIME: white paper to translate the most common functions","og_description":"From Excel to KNIME or from Spreadsheets to Workflows ! KNIME is a great alternative to combine data, automate or analyze in a scalable way.","og_url":"https:\/\/www.mydral.com\/en\/white-paper-from-excel-to-knime\/","og_site_name":"MYDRAL - DATA IS POWER","article_publisher":"https:\/\/www.facebook.com\/mydral\/?fref=ts","article_published_time":"2021-07-23T09:40:29+00:00","article_modified_time":"2026-08-24T13:38:38+00:00","author":"Sylvana AH-LAYE","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/ah_sylvana","twitter_site":"@MYDRAL_COM","twitter_misc":{"Written by":"Sylvana AH-LAYE","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/#article","isPartOf":{"@id":"https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/"},"author":{"name":"Sylvana AH-LAYE","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/ed81c117e4d8d6ae601b61af933c7b5b"},"headline":"White Paper : from Excel to KNIME","datePublished":"2021-07-23T09:40:29+00:00","dateModified":"2026-08-24T13:38:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/"},"wordCount":231,"commentCount":0,"publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"keywords":["data prep","Knime"],"articleSection":["Actualit\u00e9s"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/","url":"https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/","name":"From Excel to KNIME: white paper to translate the most common functions","isPartOf":{"@id":"https:\/\/www.mydral.com\/#website"},"datePublished":"2021-07-23T09:40:29+00:00","dateModified":"2026-08-24T13:38:38+00:00","description":"From Excel to KNIME or from Spreadsheets to Workflows ! KNIME is a great alternative to combine data, automate or analyze in a scalable way.","breadcrumb":{"@id":"https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mydral.com\/white-paper-from-excel-to-knime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.mydral.com\/"},{"@type":"ListItem","position":2,"name":"White Paper : from Excel to KNIME"}]},{"@type":"WebSite","@id":"https:\/\/www.mydral.com\/#website","url":"https:\/\/www.mydral.com\/","name":"MYDRAL - DATA IS POWER","description":"DATA IS POWER","publisher":{"@id":"https:\/\/www.mydral.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mydral.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.mydral.com\/#organization","name":"Mydral","url":"https:\/\/www.mydral.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.mydral.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.mydral.com\/wp-content\/uploads\/2017\/09\/Mydral_logo.png","contentUrl":"https:\/\/www.mydral.com\/wp-content\/uploads\/2017\/09\/Mydral_logo.png","width":1718,"height":1394,"caption":"Mydral"},"image":{"@id":"https:\/\/www.mydral.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/mydral\/?fref=ts","https:\/\/x.com\/MYDRAL_COM","https:\/\/www.instagram.com\/mydral_com\/","https:\/\/www.linkedin.com\/company\/10898136\/admin\/","https:\/\/www.pinterest.fr\/mydral_com\/","https:\/\/www.youtube.com\/channel\/UCpJqoSrQX5b0PRf0H6VRhdg\/videos?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/www.mydral.com\/#\/schema\/person\/ed81c117e4d8d6ae601b61af933c7b5b","name":"Sylvana AH-LAYE","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/15352cb449d94c9bf5c95a7984d04208df83708ca4f6b4b3a0ddffa572e539d9?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/15352cb449d94c9bf5c95a7984d04208df83708ca4f6b4b3a0ddffa572e539d9?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15352cb449d94c9bf5c95a7984d04208df83708ca4f6b4b3a0ddffa572e539d9?s=96&d=retro&r=g","caption":"Sylvana AH-LAYE"},"description":"Hello ! Passionn\u00e9e du marketing digital, je travaille quotidiennement avec les diff\u00e9rents services de Mydral. Retrouvez dans mes publications du contenu sur le secteur du Big Data, de la BI et de l'IA. Le SEO ou l'e-r\u00e9putation n'ont pas de secrets pour moi !","sameAs":["https:\/\/www.mydral.com\/","https:\/\/www.linkedin.com\/in\/sylvana-ah-laye\/","https:\/\/x.com\/https:\/\/twitter.com\/ah_sylvana"],"url":"https:\/\/www.mydral.com\/en\/author\/sylvana\/"}]}},"views":1750,"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/12617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/comments?post=12617"}],"version-history":[{"count":8,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/12617\/revisions"}],"predecessor-version":[{"id":33639,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/posts\/12617\/revisions\/33639"}],"wp:attachment":[{"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/media?parent=12617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/categories?post=12617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mydral.com\/en\/wp-json\/wp\/v2\/tags?post=12617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}