CINXE.COM

<!DOCTYPE html> <html lang="en-GB" class="no-js"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover"> <meta name="theme-color" content="#f9f8f7"> <script>(function(html){html.className = html.className.replace(/\bno-js\b/,'js')})(document.documentElement);</script> <meta name='robots' content='index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1' /> <style>img:is([sizes="auto" i], [sizes^="auto," i]) { contain-intrinsic-size: 3000px 1500px }</style>  <title>Export to Excel StarDrop script - Optibrium</title> <meta name="description" content="The Export to Excel StarDrop script provides a quick and easy way to transfer the contents of a data set straight into Microsoft Excel." /> <link rel="canonical" href="https://optibrium.com/resources/export-to-excel-stardrop-script/" /> <meta property="og:locale" content="en_GB" /> <meta property="og:type" content="article" /> <meta property="og:title" content="Export to Excel StarDrop script - Optibrium" /> <meta property="og:description" content="The Export to Excel StarDrop script provides a quick and easy way to transfer the contents of a data set straight into Microsoft Excel." /> <meta property="og:url" content="https://optibrium.com/resources/export-to-excel-stardrop-script/" /> <meta property="og:site_name" content="Optibrium" /> <meta property="article:modified_time" content="2024-05-27T16:00:20+00:00" /> <meta property="og:image" content="https://optibrium.com/wp-content/uploads/2024/05/integration-venn.jpg" /> <meta property="og:image:width" content="1200" /> <meta property="og:image:height" content="800" /> <meta property="og:image:type" content="image/jpeg" /> <meta name="twitter:card" content="summary_large_image" /> <meta name="twitter:site" content="@optibrium" /> <meta name="twitter:label1" content="Estimated reading time" /> <meta name="twitter:data1" content="1 minute" /> <script type="application/ld+json" class="yoast-schema-graph">{"@context":"https://schema.org","@graph":[{"@type":"WebPage","@id":"https://optibrium.com/resources/export-to-excel-stardrop-script/","url":"https://optibrium.com/resources/export-to-excel-stardrop-script/","name":"Export to Excel StarDrop script - Optibrium","isPartOf":{"@id":"https://optibrium.com/#website"},"primaryImageOfPage":{"@id":"https://optibrium.com/resources/export-to-excel-stardrop-script/#primaryimage"},"image":{"@id":"https://optibrium.com/resources/export-to-excel-stardrop-script/#primaryimage"},"thumbnailUrl":"https://optibrium.com/wp-content/uploads/2024/05/integration-venn.jpg","datePublished":"2023-09-22T20:59:00+00:00","dateModified":"2024-05-27T16:00:20+00:00","description":"The Export to Excel StarDrop script provides a quick and easy way to transfer the contents of a data set straight into Microsoft Excel.","breadcrumb":{"@id":"https://optibrium.com/resources/export-to-excel-stardrop-script/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https://optibrium.com/resources/export-to-excel-stardrop-script/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https://optibrium.com/resources/export-to-excel-stardrop-script/#primaryimage","url":"https://optibrium.com/wp-content/uploads/2024/05/integration-venn.jpg","contentUrl":"https://optibrium.com/wp-content/uploads/2024/05/integration-venn.jpg","width":1200,"height":800},{"@type":"BreadcrumbList","@id":"https://optibrium.com/resources/export-to-excel-stardrop-script/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://optibrium.com/"},{"@type":"ListItem","position":2,"name":"Customer hub","item":"https://optibrium.com/resources/"},{"@type":"ListItem","position":3,"name":"Export to Excel StarDrop script"}]},{"@type":"WebSite","@id":"https://optibrium.com/#website","url":"https://optibrium.com/","name":"Optibrium","description":"Transforming discovery","publisher":{"@id":"https://optibrium.com/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://optibrium.com/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https://optibrium.com/#organization","name":"Optibrium","url":"https://optibrium.com/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https://optibrium.com/#/schema/logo/image/","url":"https://optibrium.com/wp-content/uploads/2024/04/logo.svg","contentUrl":"https://optibrium.com/wp-content/uploads/2024/04/logo.svg","width":187,"height":56,"caption":"Optibrium"},"image":{"@id":"https://optibrium.com/#/schema/logo/image/"},"sameAs":["https://x.com/optibrium","https://www.linkedin.com/company/317193/","https://www.youtube.com/@OptibriumLtd"]}]}</script>  <link rel='dns-prefetch' href='//js-eu1.hs-scripts.com' /> <style id='safe-svg-svg-icon-style-inline-css'> .safe-svg-cover{text-align:center}.safe-svg-cover .safe-svg-inside{display:inline-block;max-width:100%}.safe-svg-cover svg{height:100%;max-height:100%;max-width:100%;width:100%} </style> <style id='restrict-content-pro-content-upgrade-redirect-style-inline-css'> .wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-25{width:calc(25% - .5rem)}.wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-25 .wp-block-button__link{width:100%}.wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-50{width:calc(50% - .5rem)}.wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-50 .wp-block-button__link{width:100%}.wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-75{width:calc(75% - .5rem)}.wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-75 .wp-block-button__link{width:100%}.wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-100{margin-right:0;width:100%}.wp-block-restrict-content-pro-content-upgrade-redirect .wp-block-button__width-100 .wp-block-button__link{width:100%} </style> <link rel='stylesheet' id='granola-styles-css' href='https://optibrium.com/wp-content/themes/optibrium/assets/main.css' media='all' /> <link rel="https://api.w.org/" href="https://optibrium.com/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://optibrium.com/wp-json/wp/v2/resource/2099" /><link rel='shortlink' href='https://optibrium.com/?p=2099' /> <link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://optibrium.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Foptibrium.com%2Fresources%2Fexport-to-excel-stardrop-script%2F" /> <link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://optibrium.com/wp-json/oembed/1.0/embed?url=https%3A%2F%2Foptibrium.com%2Fresources%2Fexport-to-excel-stardrop-script%2F&format=xml" />  <script class="hsq-set-content-id" data-content-id="blog-post"> var _hsq = _hsq || []; _hsq.push(["setContentType", "blog-post"]); </script>  <link rel="preload" href="https://optibrium.com/wp-content/themes/optibrium/assets/static/proxima-nova-regular-subset.woff2" crossorigin="anonymous" type="font/woff2" as="font"> <link rel="preload" href="https://optibrium.com/wp-content/themes/optibrium/assets/static/proxima-nova-semibold-subset.woff2" crossorigin="anonymous" type="font/woff2" as="font"> <link rel="preload" href="https://optibrium.com/wp-content/themes/optibrium/assets/static/proxima-nova-light-italic-subset.woff2" crossorigin="anonymous" type="font/woff2" as="font"> <link rel="preload" href="https://optibrium.com/wp-content/themes/optibrium/assets/images/icons/search.svg" crossorigin="anonymous" as="image">  <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-WMPPB3ZQ');</script>  <script type="text/javascript" id="spai_js" data-cfasync="false"> document.documentElement.className += " spai_has_js"; (function(w, d){ var b = d.getElementsByTagName('head')[0]; var s = d.createElement("script"); var v = ("IntersectionObserver" in w) ? "" : "-compat"; s.async = true; // This includes the script as async. s.src = "https://cdn.shortpixel.ai/assets/js/bundles/spai-lib-bg" + v + ".1.1.min.js?v=3.9.4"; w.spaiDomain = "cdn.shortpixel.ai"; w.spaiData = { version: "3.9.4", key: "spai", quality: "lossless", convert: "auto", lqip: true, rootMargin: "500px", crop: true, sizeBreakpoints: {"on":true,"base":50,"rate":10}, backgroundsMaxWidth: 1920, resizeStyleBackgrounds: false, nativeLazyLoad: false, safeLazyBackgrounds: false, asyncInitialParsing: true, debug: false, doSelectors: [{"selectors":"img","type":"attr","targetAttr":"src","attrType":"url","lazy":true,"resize":true}], exclusions: {"selectors":{"img#4491":{"lazy":0,"cdn":1,"resize":1,"lqip":0,"crop":0},"img#5280":{"lazy":0,"cdn":1,"resize":1,"lqip":0,"crop":0}},"urls":{"regex:\/\\\/\\\/([^\\\/]*\\.|)gravatar.com\\\/\/":{"lazy":0,"cdn":0,"resize":0,"lqip":0,"crop":-1},"regex:\/.*\\.svg$\/":{"lazy":0,"cdn":0,"resize":0,"lqip":0,"crop":-1}}}, sizeFromImageSuffix: true, ajax_url: "https://optibrium.com/wp-admin/admin-ajax.php", }; b.appendChild(s); }(window, document)); </script> <link rel="icon" href="https://cdn.shortpixel.ai/spai/q_lossless+ret_img+to_auto/optibrium.com/wp-content/uploads/2024/04/cropped-optibrium-favicon-dark-new-150x150.png" data-spai-egr="1" sizes="32x32" /> <link rel="icon" href="https://cdn.shortpixel.ai/spai/q_lossless+ret_img+to_auto/optibrium.com/wp-content/uploads/2024/04/cropped-optibrium-favicon-dark-new-300x300.png" data-spai-egr="1" sizes="192x192" /> <link rel="apple-touch-icon" href="https://cdn.shortpixel.ai/spai/q_lossless+ret_img+to_auto/optibrium.com/wp-content/uploads/2024/04/cropped-optibrium-favicon-dark-new-300x300.png" data-spai-egr="1" /> <meta name="msapplication-TileImage" content="https://optibrium.com/wp-content/uploads/2024/04/cropped-optibrium-favicon-dark-new-300x300.png" /> <link href="https://cdn.shortpixel.ai" rel="preconnect" crossorigin></head> <body class="resource-template-default single single-resource postid-2099 wp-embed-responsive">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-WMPPB3ZQ" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div id="site-cookies-notice" aria-hidden="true" class="cookies-notice"> <div class="cookies-notice__banner has-blue-background-color"> <h2 class="cookies-notice__heading">Cookies</h2> <div class="cookies-notice__description"> <p>This website stores cookies on your computer. These cookies collect information about how you interact with our website and allow us to remember you. We use this information to improve and customise your browsing experience and for analytics and metrics about our visitors on this website and other media. To find out more about the cookies we use, see our Privacy Policy.</p> <p>If you decline, your information won’t be tracked when you visit this website. A single cookie will be used in your browser to remember your preference not to be tracked.</p> </div> <form id="cookies-preferences-1" data-feedback-text="{"preferencesSaved":"Cookies consent preferences saved"}" class="cookies-notice__preferences cookies-preferences"> <fieldset id="cookies-preferences-1-consent-groups" class="cookies-preferences__consent-groups js-expandable-element" aria-hidden="true"> <legend class="visually-hidden"> Select cookie consent by type </legend> <div class="cookies-preferences__consent-group"> <label for="cookies-preferences-1-consent-type-ad_storage-input" aria-hidden="true" class="toggle-field" id="cookies-preferences-1-consent-type-ad_storage"> <input id="cookies-preferences-1-consent-type-ad_storage-input" type="checkbox" name="gtm_consent_type_ad_storage" value="granted" /> <span class="toggle-field__indicator" hidden> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 65 52" role="img" aria-hidden="true" width="65" height="52"><g fill="#fff" fill-rule="evenodd"><path d="m55.97.544 8.486 8.485-42.427 42.427-8.485-8.485z"/><path d="m30.456 42.97-8.485 8.486L.757 30.243l8.486-8.486z"/></g></svg> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 52 52" role="img" aria-hidden="true" width="52" height="52"><g fill="#fff" fill-rule="evenodd"><path d="m42.97.544 8.486 8.485L9.029 51.456.544 42.97z"/><path d="m51.456 42.97-8.485 8.486L.544 9.029 9.03.544z"/></g></svg> </span> <span class="toggle-field__label"> <span>Marketing</span> <span>These let us make our marketing more relevant to you.</span> </span> </label> </div> <div class="cookies-preferences__consent-group"> <label for="cookies-preferences-1-consent-type-analytics_storage-input" aria-hidden="true" class="toggle-field" id="cookies-preferences-1-consent-type-analytics_storage"> <input id="cookies-preferences-1-consent-type-analytics_storage-input" type="checkbox" name="gtm_consent_type_analytics_storage" value="granted" /> <span class="toggle-field__indicator" hidden> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 65 52" role="img" aria-hidden="true" width="65" height="52"><g fill="#fff" fill-rule="evenodd"><path d="m55.97.544 8.486 8.485-42.427 42.427-8.485-8.485z"/><path d="m30.456 42.97-8.485 8.486L.757 30.243l8.486-8.486z"/></g></svg> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 52 52" role="img" aria-hidden="true" width="52" height="52"><g fill="#fff" fill-rule="evenodd"><path d="m42.97.544 8.486 8.485L9.029 51.456.544 42.97z"/><path d="m51.456 42.97-8.485 8.486L.544 9.029 9.03.544z"/></g></svg> </span> <span class="toggle-field__label"> <span>Visitor statistics</span> <span>These let us make our website better.</span> </span> </label> </div> <div class="cookies-preferences__consent-group"> <label for="cookies-preferences-1-consent-type-personalization_storage-input" aria-hidden="true" class="toggle-field" id="cookies-preferences-1-consent-type-personalization_storage"> <input id="cookies-preferences-1-consent-type-personalization_storage-input" type="checkbox" name="gtm_consent_type_personalization_storage" value="granted" /> <span class="toggle-field__indicator" hidden> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 65 52" role="img" aria-hidden="true" width="65" height="52"><g fill="#fff" fill-rule="evenodd"><path d="m55.97.544 8.486 8.485-42.427 42.427-8.485-8.485z"/><path d="m30.456 42.97-8.485 8.486L.757 30.243l8.486-8.486z"/></g></svg> <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 52 52" role="img" aria-hidden="true" width="52" height="52"><g fill="#fff" fill-rule="evenodd"><path d="m42.97.544 8.486 8.485L9.029 51.456.544 42.97z"/><path d="m51.456 42.97-8.485 8.486L.544 9.029 9.03.544z"/></g></svg> </span> <span class="toggle-field__label"> <span>Preferences</span> <span>These let us make your visitor experience better</span> </span> </label> </div> </fieldset> <ul class="cookies-preferences__action-list button-list"> <li class="cookies-preferences__action" aria-hidden="true"> <button aria-label="Save preferences for which cookies to consent to" type="submit" class="g-button cookies-preferences__save-consent js-cookies-consent-selected"> Save preferences</button> </li> <li class="cookies-preferences__action"> <button aria-label="Accept all extra cookies" type="submit" class="g-button cookies-preferences__consent js-cookies-consent-all"> Accept all</button> </li> <li class="cookies-preferences__action"> <button aria-label="Reject all extra cookies" type="submit" class="g-button cookies-preferences__reject js-cookies-reject-all"> Reject all</button> </li> <li class="cookies-preferences__action"> <button aria-label="Manage preferences by cookie type" aria-expanded="false" aria-controls="cookies-preferences-1-consent-groups" type="button" class="g-button g-button--blend cookies-preferences__consent-groups-toggler"> Manage preferences</button> </li> </ul> </form> </div> </div> <a href="#main" class="skip-link visually-hidden">Skip to content</a> <header role="banner" class="header"> <div class="header__outer block__outer"> <a title="Optibrium" href="https://optibrium.com" class="header__logo"><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 187.7 56" role="img" aria-hidden="true" width="187.7" height="56"><linearGradient id="a"><stop offset="0" stop-color="#63bbe3"/><stop offset=".06" stop-color="#77c0be"/><stop offset=".2" stop-color="#aacc61"/><stop offset=".28" stop-color="#cad327"/><stop offset=".63" stop-color="#ffd618"/><stop offset=".76" stop-color="#f8c05a"/><stop offset=".82" stop-color="#e7c986"/><stop offset=".9" stop-color="#d1d6bd"/><stop offset=".97" stop-color="#c3dde0"/><stop offset="1" stop-color="#bee0ed"/></linearGradient><linearGradient id="d" gradientTransform="matrix(1 0 0 -1 0 56)" gradientUnits="userSpaceOnUse" x1="0" x2="725.654" xlink:href="#a" y1="40.916" y2="40.916"/><linearGradient id="e" gradientTransform="matrix(1 0 0 -1 0 56)" gradientUnits="userSpaceOnUse" x1="-97.625" x2="187.68" xlink:href="#a" y1="10.998" y2="10.998"/><linearGradient id="b"><stop offset="0" stop-color="#63bbe3"/><stop offset=".06" stop-color="#77c0be"/><stop offset=".2" stop-color="#aacc61"/><stop offset=".28" stop-color="#cad327"/><stop offset=".63" stop-color="#ffd618"/><stop offset=".79" stop-color="#f8c05a"/><stop offset=".84" stop-color="#e7c986"/><stop offset=".92" stop-color="#d1d6bd"/><stop offset=".97" stop-color="#c3dde0"/><stop offset="1" stop-color="#bee0ed"/></linearGradient><linearGradient id="f" gradientTransform="matrix(1 0 0 -1 0 56)" gradientUnits="userSpaceOnUse" x1="0" x2="696.357" xlink:href="#b" y1="47.07" y2="47.07"/><linearGradient id="g" gradientTransform="matrix(1 0 0 -1 0 56)" gradientUnits="userSpaceOnUse" x1="-114.612" x2="187.675" xlink:href="#b" y1="12.816" y2="12.816"/><linearGradient id="c"><stop offset="0" stop-color="#63bbe3"/><stop offset=".06" stop-color="#77c0be"/><stop offset=".2" stop-color="#aacc61"/><stop offset=".28" stop-color="#cad327"/><stop offset=".64" stop-color="#ffd618"/><stop offset=".77" stop-color="#f8c05a"/><stop offset=".83" stop-color="#e7c986"/><stop offset=".91" stop-color="#d1d6bd"/><stop offset=".97" stop-color="#c3dde0"/><stop offset="1" stop-color="#bee0ed"/></linearGradient><linearGradient id="h" gradientTransform="matrix(1 0 0 -1 0 56)" gradientUnits="userSpaceOnUse" x1="-134.896" x2="187.68" xlink:href="#c" y1="14.826" y2="14.826"/><linearGradient id="i" gradientTransform="matrix(1 0 0 -1 0 56)" gradientUnits="userSpaceOnUse" x1=".003" x2="690.463" xlink:href="#c" y1="48.3" y2="48.3"/><path d="M34.8 7.8C20.4 7.8 16.1 14.3 0 22.4c12.8-4.2 18.9-11.2 34.8-11.2 3.2 0 6.2 1.3 9.4 3.7 1.2-.6 2.8-.8 4.2-1-4.6-3.8-8.9-6.1-13.6-6.1z" fill="url(#d)"/><path d="M187.2 36.9c-37.4 4-46.5 16.3-75.2 16.3-18.1 0-31.1-8.4-41.8-18.1-2.6 0-4.1-.2-6.2-1.2 11.6 11.1 26.3 22 47.8 22 27.5.1 43.6-14.8 75.4-19z" fill="url(#e)"/><path d="M55.7 14.4c-6.8-6.4-13.2-11-20.2-11-9.1 0-16.7 5.3-21.2 9.1C21.9 8.1 25.6 6 35.2 6c5.1 0 9.9 3 15.2 7.6 1.6.1 3.3.3 5.3.8z" fill="url(#f)"/><path d="M111.9 51.8c25.1 0 32.4-8.2 56.4-13.2-27.4 4-31.2 10.9-56.2 10.9-14.3 0-25.6-6.6-35.4-14.9-1.4.2-2.1.6-4 .6 10.4 9 22.9 16.6 39.2 16.6z" fill="url(#g)"/><path d="M79 34.6C88.3 42.1 99.1 48 112.6 48c20.5 0 25.3-4.5 39.6-7.9-14 2-19.7 5.8-39.5 5.8-11.9 0-21.6-4.9-30-11.6-1.5.6-2.4.6-3.7.3z" fill="url(#h)"/><path d="M60.5 13.2C52.8 5.8 45.3 0 36.6 0c-3.3 0-5.9 1.4-10.3 4 3.8-1.5 6.3-1.8 10.3-1.8 7.6 0 14.6 5.8 22.2 13.2.6-.9 1.2-1.6 1.7-2.2z" fill="url(#i)"/><path d="M183.1 16.8h.8v2.1h.4v-2.1h.8v-.3h-1.9v.3zm4.1-.4-.6 1.7c0 .1-.1.2-.1.3 0-.1-.1-.2-.1-.3l-.6-1.7h-.5v2.4h.3V17l.6 1.9h.3l.7-1.9v1.9h.4v-2.4h-.4zm-111 10.9H75c-.3 0-.6.2-.6.6-.1.9-1.4 1.3-1.4 1.3-.6.1-1.7.3-2.4.3h-2c-.6 0-1.1-.3-1.7-.9-.4-.4-.5-.8-.5-.8-.2-.8-.2-1.6-.3-2.4v-4.8c0-.4.3-.7.7-.7h5.4c1 0 1.9-.8 1.9-1.8s-.8-1.8-1.9-1.8h-5.4c-.4 0-.7-.3-.7-.7v-.3c0-1-.8-1.9-1.7-1.9-1 0-1.7.8-1.7 1.9v.3c0 .4-.2.7-.3.7-.8 0-1.5.8-1.5 1.8s.7 1.8 1.5 1.8c.1 0 .3.3.3.7v3.7c0 2.6.2 4 .9 5.3 1 2 3.6 2.6 3.7 2.6.7.2 1.9.3 2.6.3h2c1.7 0 3.1-.4 4.2-1.2s1.5-2 1.5-2.1c.2-.5.1-1-.2-1.4-.2-.3-.7-.5-1.2-.5zm-39-9.3c-1.3-1.2-3.7-1.6-3.8-1.6-.9-.1-1.7-.2-2.6-.2H26c-2.1 0-3.8.6-5.1 1.8s-1.7 3.3-1.8 3.4c-.1.9-.2 1.7-.2 2.6v2c0 2 .7 3.6 2 4.8s3.7 1.5 3.8 1.6c.9.1 1.7.2 2.6.2H32c2.1 0 3.8-.6 5.1-1.8s1.7-3.3 1.7-3.4c.1-.9.2-1.7.2-2.6v-2c.1-2-.5-3.6-1.8-4.8zm-1.6 6.1v2.2c0 1-.3 1.6-1 2.2-.6.6-1.6.7-1.7.7-.8.1-1.6.2-2.5.2h-4.3c-1.3 0-2.3-.3-2.9-.8-.5-.5-.7-1.1-.7-1.1-.1-.8-.2-1.6-.2-2.4v-2.2c0-1.2.3-2 .9-2.5.5-.4 1.4-.6 1.7-.7.8-.1 1.6-.1 2.5-.2h4.3c1.3 0 2.3.3 2.9.8.5.5.7 1.3.7 1.3.2.8.3 1.6.3 2.5zm24.5-2.6c0-.1-.4-2.1-1.7-3.3-1.3-1.1-3-1.7-5.1-1.7h-3.8c-.9 0-1.7.1-2.6.2-.1 0-1.3.2-2.4 1-.2-.7-.9-1.2-1.6-1.2-.9 0-1.7.8-1.7 1.9v18.3c0 1 .8 1.9 1.7 1.9s1.7-.8 1.7-1.9v-5.4c.4.4 1.7 1.3 3.6 1.3H52c.9 0 1.7-.1 2.6-.2.1 0 2.5-.4 3.7-1.5 1.3-1.1 1.9-2.7 1.9-4.7v-2c.2-1 .1-1.9-.1-2.7zm-3.2 1.3v2c0 .7 0 1.8-.1 2.5 0 0-.1.8-.6 1.3-.7.6-1.4 1-3.1 1h-3.3c-.8 0-1.6-.1-2.5-.2-.1 0-1.2-.2-1.9-.8-.6-.5-.8-1.2-.8-2.5v-2.4c0-2 .2-2.8.8-3.3.7-.6 1.8-.9 3.1-1h3.3c.8 0 1.6.1 2.4.2.1 0 1 .2 1.7.8.7.4 1 1.3 1 2.4zm23.9-6.4c-.9 0-1.7.8-1.7 1.9v12.2c0 1 .7 1.9 1.7 1.9.9 0 1.7-.8 1.7-1.9V18.3c-.1-1-.8-1.9-1.7-1.9zm-.1-6.1c-.9 0-1.7.8-1.7 1.8s.8 1.8 1.7 1.8 1.7-.8 1.7-1.8-.7-1.8-1.7-1.8zm20.8 7.7c-1.3-1.2-3.6-1.6-3.7-1.6-.9-.1-1.7-.2-2.6-.2h-3.8c-2.1 0-3.6 1.2-3.7 1.2v-5.3c0-1-.8-1.9-1.8-1.9s-1.8.8-1.8 1.9v18.5c0 1 .8 1.9 1.8 1.9.7 0 1.3-.5 1.6-1.1 1.2.7 2.4.9 2.5.9.9.1 1.7.2 2.6.2h3.8c2.3 0 4-.5 5.2-1.6s1.6-3.4 1.6-3.5c.1-.9.2-1.7.2-2.6v-2c0-2-.6-3.6-1.9-4.8zm-1.6 6.1v2c0 1.1-.3 1.9-1 2.5-.5.4-1.7.7-2.1.7-.7.1-1.8.1-2.5.1h-2.8c-1.3 0-2.3-.3-3-.9-.6-.5-.8-1.3-.8-1.3-.1-.8-.2-1.6-.2-2.4v-2c0-1 .3-1.8 1-2.4s1.7-.7 1.8-.7c.8-.1 1.6-.2 2.4-.2h2.8c1.5 0 2.6.3 3.2.9.6.5.8 1.3.8 1.4.3.7.4 1.5.4 2.3zm19.5-6.3c-1.2-1-2.9-1.4-5.3-1.5h-1.7c-2 0-3.3 1.1-3.5 1.2-.2-.7-.9-1.2-1.7-1.2-.9 0-1.7.8-1.7 1.9v12.5c0 1 .8 1.9 1.7 1.9s1.7-.8 1.7-1.9v-6.2c0-2.1.2-3.1.8-3.9.5-.7 1.6-.9 1.6-1 .8-.1 1.6-.2 2.4-.2h.4c1.3 0 2.3.3 2.9.9.5.5.6 1.1.6 1.1.1 1 1 1.8 2 1.8h1c.3 0 .6-.3.6-.6 0-2.2-.6-3.8-1.8-4.8zm5.1-1.4c-.9 0-1.7.8-1.7 1.9v12.2c0 1 .8 1.9 1.7 1.9s1.7-.8 1.7-1.9V18.3c0-1-.8-1.9-1.7-1.9zm0-6.1c-.9 0-1.7.8-1.7 1.8s.8 1.8 1.7 1.8 1.7-.8 1.7-1.8-.7-1.8-1.7-1.8zm19.9 6c-1 0-1.8.8-1.8 1.9v8.2c0 .9-.3 1.6-1 2.2-.6.5-1.5.7-1.5.7-.8.1-1.6.2-2.4.2h-2.6c-1.3 0-2.2-.3-2.8-.8-.5-.5-.6-1.2-.6-1.2-.1-.8-.2-1.6-.2-2.4v-6.7c0-1-.8-1.9-1.8-1.9s-1.8.8-1.8 1.9V26c0 2.1.6 3.8 1.8 4.9 1.3 1.2 3.8 1.5 3.9 1.5.7.1 1.9.1 2.6.1h2.6c1.5 0 2.8-.4 3.9-1.2.2.7.9 1.2 1.6 1.2.9 0 1.7-.8 1.7-1.9V18.2c.1-1-.7-1.9-1.6-1.9zm35.8 1.5c-1.4-1-3.3-1.3-3.4-1.3-.9-.1-1.7-.2-2.6-.2h-3.1c-2.7 0-4.6.8-5.6 2.3-.5-.5-1.3-1-2.2-1.4-1.1-.4-2-.6-2-.6-.9-.2-1.7-.2-2.6-.3h-2.9c-2.3 0-3.9 1.3-4.1 1.4-.1-.8-.8-1.4-1.7-1.4-1 0-1.7.8-1.7 1.9v12.5c0 1 .8 1.9 1.7 1.9s1.7-.8 1.7-1.9v-6.2c0-1.9.3-3.5.7-4.1s1.8-.8 2.5-.9h4.7c1.3 0 2.4.3 3.1.9.4.3.7.8.8 1.3.1.8.2 1.6.2 2.4v6.5c0 1 .8 1.9 1.8 1.9.4 0 .9-.2 1.2-.5.3-.4.5-.8.5-1.4 0-2.6-.1-7.7-.1-7.8 0-.9.3-1.8.8-2.4.4-.6 1.8-.8 2.6-.9.7 0 1.8-.1 2.5-.1h1.9c1.6 0 2.8.4 3.5 1.2s.7 1.6.7 3.7v6.2c0 .5.2 1 .6 1.4.3.3.7.5 1.2.5.9 0 1.7-.9 1.7-1.9V22c0-1.6-.8-3.1-2.4-4.2z" fill="#424346"/></svg></a> <nav class="header__navigation"> <button type="button" aria-controls="header-navigation" aria-expanded="false" aria-label="Open main menu" data-label-opened="Close main menu" data-label-closed="Open main menu" class="burger header__burger js-header-burger"> <span class="burger__line burger__line--1"></span> <span class="burger__line burger__line--2"></span> <span class="burger__line burger__line--3"></span> </button> <div class="header__navigation-outer" id="header-navigation"> <div class="header__navigation-inner"> <ul id="menu-header" class="header__menu"><li id="menu-item-1675" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-4-columns menu-item-1675"><button class="link menu-item-has-icon" aria-controls="header-sub-menu-137" aria-expanded="false">Solutions</button> <div id='header-sub-menu-137' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1671" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-1671"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/solutions/compound-generation/">Compound generation<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/compound-generation.svg')"></span></a></div><div class="menu-item-content nflm">Chemical space is vast. Give yourself the best chance of success, using a range of methods to rigorously explore many ideas and optimisation strategies.</div></li> <li id="menu-item-1672" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-1672"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/solutions/compound-optimisation/">Compound optimisation<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/compound-optimisation.svg')"></span></a></div><div class="menu-item-content nflm">From your initial compounds you want to improve physicochemical and ADME properties, whilst also ensuring good target activity and selectivity.</div></li> <li id="menu-item-1673" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-1673"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/solutions/3d-molecular-design-visualisation/">3D molecular design and visualisation<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/drug-design-visualisation.svg')"></span></a></div><div class="menu-item-content nflm">Understand structure-activity and structure-property relationships in 3D, with cutting-edge computational modelling.</div></li> <li id="menu-item-4085" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-4085"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/products/cerella/">AI data analysis<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/chip.svg')"></span></a></div><div class="menu-item-content nflm">Reveal transformative insights with AI-guided discovery</div></li> <li id="menu-item-1714" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-1714"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/solutions/data-analysis-and-structure-activity-relationships/">Data analysis and SAR<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/predictive-modeling.svg')"></span></a></div><div class="menu-item-content nflm">In discovery, whether your starting point is a compound structure, target or data on literature or proprietary compounds, the first step is to make sense of the information you already have.</div></li> <li id="menu-item-1676" class="menu-item menu-item-type-post_type menu-item-object-page has-icon is-footer-link menu-item-1676"><a class="menu-item-has-icon" href="https://optibrium.com/solutions/">All solutions<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/linked-squares.svg')"></span></a></li> </ul></div></div> </li> <li id="menu-item-1677" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-4-columns menu-item-1677"><button class="link menu-item-has-icon" aria-controls="header-sub-menu-145" aria-expanded="false">Products</button> <div id='header-sub-menu-145' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1720" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-logo has-4-columns menu-item-1720"><div class="menu-item-heading"><a class="menu-item-logo img-fit" title="StarDrop" href="https://optibrium.com/products/stardrop/"><img width="768" src="https://optibrium.com/wp-content/uploads/2024/05/Colour-StarDrop.svg" class="attachment-medium_large size-medium_large" alt="" sizes="auto, 173px" aria-hidden="true" loading="lazy" decoding="async" /></a></div><div class="menu-item-content nflm">A complete platform for molecular design, optimisation and data analysis</div> <div id='header-sub-menu-147' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1715" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1715"><a href="https://optibrium.com/products/stardrop/">Product overview</a></li> <li id="menu-item-1717" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1717"><a href="https://optibrium.com/products/stardrop/#modules">Modules</a></li> <li id="menu-item-1716" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1716"><a href="https://optibrium.com/products/stardrop/#customisation-collaboration">Customisation and collaboration</a></li> <li id="menu-item-1719" class="menu-item menu-item-type-custom menu-item-object-custom has-button menu-item-1719"><a class="g-button is-yellow is-small" href="https://login.stardrop.optibrium.com/">Login</a></li> </ul></div></div> </li> <li id="menu-item-1679" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-logo has-4-columns menu-item-1679"><div class="menu-item-heading"><a class="menu-item-logo img-fit" title="Cerella" href="https://optibrium.com/products/cerella/"><img width="768" src="https://optibrium.com/wp-content/uploads/2024/05/Colour-Cerella.svg" class="attachment-medium_large size-medium_large" alt="" sizes="auto, 173px" aria-hidden="true" loading="lazy" decoding="async" /></a></div><div class="menu-item-content nflm">Transformative insights, revealed, with AI-guided discovery</div> <div id='header-sub-menu-622' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1721" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1721"><a href="https://optibrium.com/products/cerella/">Product overview</a></li> <li id="menu-item-3382" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3382"><a href="https://optibrium.com/knowledge-base/?_tax%5Bproduct%5D%5B%5D=12&_tax%5Bsolution%5D%5B%5D=&_tax%5Bkb-content-type%5D%5B%5D=63&_tax%5Btopic%5D%5B%5D=">Publications</a></li> <li id="menu-item-1722" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1722"><a href="https://optibrium.com/products/cerella/#case-study">Case studies</a></li> </ul></div></div> </li> <li id="menu-item-1678" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-logo has-4-columns menu-item-1678"><div class="menu-item-heading"><a class="menu-item-logo img-fit" title="BioPharmics" href="https://optibrium.com/products/biopharmics/"><img width="768" src="https://optibrium.com/wp-content/uploads/2024/05/Colour-BioPharmics.svg" class="attachment-medium_large size-medium_large" alt="" sizes="auto, 173px" aria-hidden="true" loading="lazy" decoding="async" /></a></div><div class="menu-item-content nflm">Harness cutting edge models for 3D ligand-based and structure-based design</div> <div id='header-sub-menu-626' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1724" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1724"><a href="https://optibrium.com/products/biopharmics/">Product overview</a></li> <li id="menu-item-1725" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1725"><a href="https://optibrium.com/products/biopharmics/#publications">Publications</a></li> </ul></div></div> </li> <li id="menu-item-1680" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-logo has-4-columns menu-item-1680"><div class="menu-item-heading"><a class="menu-item-logo img-fit" title="Semeta" href="https://optibrium.com/products/semeta/"><img width="768" src="https://optibrium.com/wp-content/uploads/2024/05/Colour-Semeta.svg" class="attachment-medium_large size-medium_large" alt="" sizes="auto, 173px" aria-hidden="true" loading="lazy" decoding="async" /></a></div><div class="menu-item-content nflm">Accurate metabolism insights, tailored for DMPK scientists</div> <div id='header-sub-menu-624' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1727" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1727"><a href="https://optibrium.com/products/semeta/">Product overview</a></li> <li id="menu-item-1729" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1729"><a href="#">Publications</a></li> <li id="menu-item-1730" class="menu-item menu-item-type-custom menu-item-object-custom has-button menu-item-1730"><a class="g-button is-yellow is-small" href="https://login.semeta.optibrium.com/">Login</a></li> </ul></div></div> </li> <li id="menu-item-4481" class="menu-item menu-item-type-post_type menu-item-object-page has-icon is-footer-link menu-item-4481"><a class="menu-item-has-icon" href="https://optibrium.com/products/">All products<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/stars.svg')"></span></a></li> </ul></div></div> </li> <li id="menu-item-1683" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children has-4-columns menu-item-1683"><button class="link menu-item-has-icon" aria-controls="header-sub-menu-1683" aria-expanded="false">Resources</button> <div id='header-sub-menu-1683' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-5951" class="menu-item menu-item-type-custom menu-item-object-custom has-icon menu-item-5951"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/knowledge-base-type/drug-discovery-blog/">Blog<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/story.svg')"></span></a></div><div class="menu-item-content nflm">Your questions, answered. Our experts chat science, software set-up, and more</div></li> <li id="menu-item-6472" class="menu-item menu-item-type-taxonomy menu-item-object-kb-content-type has-icon menu-item-6472"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/knowledge-base-type/case-study/">Case studies<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/paper.svg')"></span></a></div><div class="menu-item-content nflm">Discover success stories from our customers and collaborators.</div></li> <li id="menu-item-2328" class="menu-item menu-item-type-taxonomy menu-item-object-kb-content-type has-icon menu-item-2328"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/knowledge-base-type/ebooks/">Ebooks<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/tablet.svg')"></span></a></div><div class="menu-item-content nflm">Want in-depth expertise on the key topics shaping our industry? Browse our latest ebooks.</div></li> <li id="menu-item-2329" class="menu-item menu-item-type-taxonomy menu-item-object-kb-content-type has-icon menu-item-2329"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/knowledge-base-type/poster/">Posters<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/posters.svg')"></span></a></div><div class="menu-item-content nflm">Can’t make it to a conference? You can browse our posters here instead</div></li> <li id="menu-item-2330" class="menu-item menu-item-type-taxonomy menu-item-object-kb-content-type has-icon menu-item-2330"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/knowledge-base-type/publication/">Publications<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/publications.svg')"></span></a></div><div class="menu-item-content nflm">From 3D design to generative chemistry, catch up with the latest developments from our R&D teams.</div></li> <li id="menu-item-1731" class="menu-item menu-item-type-custom menu-item-object-custom has-icon is-footer-link menu-item-1731"><a class="menu-item-has-icon" href="https://optibrium.com/knowledge-base/">All resources<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/head.svg')"></span></a></li> </ul></div></div> </li> <li id="menu-item-1688" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-1688"><a href="https://optibrium.com/webinars/">Webinars</a></li> <li id="menu-item-1689" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children has-4-columns menu-item-1689"><button class="link menu-item-has-icon" aria-controls="header-sub-menu-1689" aria-expanded="false">Customer hub</button> <div id='header-sub-menu-1689' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-6877" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children has-icon has-4-columns menu-item-6877"><div class="menu-item-heading"><a class="menu-item-has-icon" href="#">User Group Meetings<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/multicultural-people.svg')"></span></a></div><div class="menu-item-content nflm">Access lively networking, insightful discussion and interactive workshops at our live, in-person events</div> <div id='header-sub-menu-6877' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-6879" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6879"><a href="https://optibrium.com/optibrium-cambridge-2025/">Cambridge, UK 12 March</a></li> <li id="menu-item-6878" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-6878"><a href="https://optibrium.com/optibrium-san-diego-2025/">San Diego, US 27 March</a></li> </ul></div></div> </li> <li id="menu-item-2718" class="menu-item menu-item-type-taxonomy menu-item-object-resource-content-type menu-item-has-children has-icon has-4-columns menu-item-2718"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/resource-type/videos/">Videos<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/white-board.svg')"></span></a></div><div class="menu-item-content nflm">Watch our tutorials and tips videos to understand how best to use all the features of our software</div> <div id='header-sub-menu-94' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-4331" class="menu-item menu-item-type-taxonomy menu-item-object-resource-content-type menu-item-4331"><a href="https://optibrium.com/resource-type/tutorial-video/">Tutorials</a></li> <li id="menu-item-4330" class="menu-item menu-item-type-taxonomy menu-item-object-resource-content-type menu-item-4330"><a href="https://optibrium.com/resource-type/quick-tip-video/">Quick tips</a></li> </ul></div></div> </li> <li id="menu-item-4548" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children has-icon has-4-columns menu-item-4548"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/resources/?_tax%5Bresource-content-type%5D%5B%5D=47&_tax%5Bresource-content-type%5D%5B%5D=92&_tax%5Bresource-content-type%5D%5B%5D=93&_tax%5Bresource-content-type%5D%5B%5D=90">Integrations, models and collections<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/informatics.svg')"></span></a></div><div class="menu-item-content nflm">Connect to key third-party applications, download pre-built models and scoring profiles, and access vast virtual libraries</div> <div id='header-sub-menu-4548' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-2710" class="menu-item menu-item-type-taxonomy menu-item-object-resource-content-type current-resource-ancestor current-menu-parent current-resource-parent has-icon menu-item-2710"><a href="https://optibrium.com/resource-type/integrations/">Integrations</a></li> <li id="menu-item-2711" class="menu-item menu-item-type-taxonomy menu-item-object-resource-content-type has-icon menu-item-2711"><a href="https://optibrium.com/resource-type/models/">Models</a></li> <li id="menu-item-2713" class="menu-item menu-item-type-taxonomy menu-item-object-resource-content-type has-icon menu-item-2713"><a href="https://optibrium.com/resource-type/virtual-screening-collections/">Virtual screening collections</a></li> <li id="menu-item-2715" class="menu-item menu-item-type-taxonomy menu-item-object-resource-content-type has-icon menu-item-2715"><a href="https://optibrium.com/resource-type/scoring-profile/">Scoring profiles</a></li> </ul></div></div> </li> <li id="menu-item-1691" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-icon has-4-columns menu-item-1691"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/products/support/">Support<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/help.svg')"></span></a></div><div class="menu-item-content nflm">Get all the answers to your specific software and scientific questions through our dedicated Support page.</div> <div id='header-sub-menu-1594' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-5342" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-5342"><a href="https://optibrium.com/products/support/">Contact support</a></li> <li id="menu-item-1695" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-1695"><a href="https://optibrium.com/products/stardrop/open-training/">Open training</a></li> <li id="menu-item-5343" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-5343"><a href="https://optibrium.com/faq">FAQs</a></li> </ul></div></div> </li> <li id="menu-item-1690" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-1690"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/products/product-installation/">Software downloads<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/download.svg')"></span></a></div><div class="menu-item-content nflm">Find your installation files, user and reference guides for smooth software sailing.</div></li> <li id="menu-item-1732" class="menu-item menu-item-type-custom menu-item-object-custom has-icon is-footer-link menu-item-1732"><a class="menu-item-has-icon" href="https://optibrium.com/resources/">All customer hub<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/person.svg')"></span></a></li> </ul></div></div> </li> <li id="menu-item-1700" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-4-columns menu-item-1700"><button class="link menu-item-has-icon" aria-controls="header-sub-menu-1556" aria-expanded="false">About Optibrium</button> <div id='header-sub-menu-1556' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1712" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-icon has-4-columns menu-item-1712"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/about-optibrium/">We are Optibrium<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/people.svg')"></span></a></div><div class="menu-item-content nflm">Find out more about Optibrium’s history, team and collaborators, and learn how we’re transforming discovery</div> <div id='header-sub-menu-1556' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1710" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1710"><a href="https://optibrium.com/team/">Our team</a></li> <li id="menu-item-5793" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-5793"><a href="https://optibrium.com/about-optibrium/our-customers/">Our customers</a></li> <li id="menu-item-1713" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1713"><a href="https://optibrium.com/about-optibrium/our-partners/">Our partners</a></li> </ul></div></div> </li> <li id="menu-item-1701" class="menu-item menu-item-type-custom menu-item-object-custom has-icon menu-item-1701"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/news/">In the news<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/chat.svg')"></span></a></div><div class="menu-item-content nflm">The latest news and updates about our research, products and teams.</div></li> <li id="menu-item-1709" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children has-icon has-4-columns menu-item-1709"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/careers/">Work with us<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/careers.svg')"></span></a></div><div class="menu-item-content nflm">Are you interested in joining the team? See what life is like at Optibrium and browse our jobs</div> <div id='header-sub-menu-1705' class='sub-menu-outer'><div class='sub-menu-inner'><ul class='sub-menu'> <li id="menu-item-1835" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1835"><a href="https://optibrium.com/jobs/">Browse jobs</a></li> </ul></div></div> </li> <li id="menu-item-1711" class="menu-item menu-item-type-post_type menu-item-object-page has-icon menu-item-1711"><div class="menu-item-heading"><a class="menu-item-has-icon" href="https://optibrium.com/about-optibrium/contact-us/">Contact us<span class="menu-item-icon img-fit" aria-hidden="true" style="mask-image: url('https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/email.svg')"></span></a></div><div class="menu-item-content nflm">Our global team is always here to talk and there are a number of ways to get in touch</div></li> </ul></div></div> </li> </ul> <div class="header-search"> <button class="header-search__toggle" type="button" aria-controls="header-search-outer" aria-expanded="false" aria-label="Toggle search"></button> <div id="header-search-outer" class="header-search__outer"> <div class="header-search__inner"> <form role="search" method="get" class="search-form" action="https://optibrium.com/"> <label> <span class="screen-reader-text">Search for:</span> <input type="search" class="search-field" placeholder="Enter a search word..." value="" name="s" /> </label> <input type="submit" class="search-submit" value="Search" /> </form> </div> </div> </div> </div> </div> </nav> </div> </header> <main id="main" class="site-main nflm"> <div class="site-main__inner"> <div class="site-main__content blocks"> <div class="page-header wp-block alignfull has-breadcrumbs is-style-vertical"> <div class="page-header__wrapper"> <div class="page-header__outer"> <nav class="breadcrumbs" aria-label="breadcrumbs"> <span class="breadcrumbs__yoast-wrapper"><span><a href="https://optibrium.com/">Home</a></span> <span class="breadcrumbs__yoast-separator"></span> <span><a href="https://optibrium.com/resources/">Customer hub</a></span> <span class="breadcrumbs__yoast-separator"></span> <span class="breadcrumb_last" aria-current="page">Export to Excel StarDrop script</span></span></nav> <div class="page-header__inner"> <h1 class="page-header__heading">Export to Excel StarDrop script</h1> <ul class="page-header__labels nflm flex-list"> <li> <a href="https://optibrium.com/resource-type/integrations/">Integrations</a> </li> <li> <a href="https://optibrium.com/product/stardrop/">StarDrop</a> </li> </ul> </div> </div> </div> </div> <p>The Export to Excel script provides a quick and easy way to transfer the contents of a data set straight into Microsoft Excel.</p> <h2 class="wp-block-heading">Version</h2> <p>This integration is available to use with the latest version of StarDrop (Windows and macOS). To find out which version you have installed, start StarDrop and select the <strong>Help->About </strong>menu.</p> <p>If you are using an older version of StarDrop, please contact us at <a href="mailto:support@optibrium.com">support@optibrium.com</a> and we will be happy to help install this script on your StarDrop client.</p> <section class="tabs wp-block alignfull"> <div class="tabs__outer"> <div class="tabs__inner"> <h2 class="tabs__heading is-style-typestyle-h1">Installing and using the script</h2> <div class="tabs__tabs"> <div class="tabs__controls automatic" role="tablist" aria-labelledby="tablist-1"> <button type="button" role="tab" id="tab-0" aria-selected="true" aria-controls="tabpanel-0" >Installation files </button> <button type="button" role="tab" id="tab-1" aria-selected="false" aria-controls="tabpanel-1" tabindex="-1" >How to use the script </button> </div> <div class="tabs__panels"> <div role="tabpanel" tabindex="0" id="tabpanel-0" aria-labelledby="tab-0" class="tabs__panel nflm "> <div class="tabs__tiles"> <div class="tabs__tile nflm"> <h3 class="is-style-typestyle-h6">Windows with .zip file</h3> <ul> <li>Exit StarDrop</li> <li>Download <a download="stardrop-script-export-to-excel_py3qt.zip" href="https://optibrium.com/wp-content/uploads/2024/05/StarDrop-Script-Export-To-Excel_py3Qt.zip" target="_blank" rel="noopener">StarDrop Script – Export To Excel_py3Qt.zip</a></li> <li>In your user area, navigate to the StarDrop Python folder in <strong>C:\Users\username\AppData\Roaming\StarDrop</strong></li> <li>Extract the contents of <strong>the zip file</strong> into this folder overwriting any existing files</li> <li>You should now see the following folders in the <strong>StarDrop</strong> folder:<br /> <b><strong>py3\Export To Excel<br /> </strong></b><strong>site-packages\xlwt</strong><br /> <strong>py3\Utils</strong></li> <li>Start StarDrop</li> </ul> </div> <div class="tabs__tile nflm"> <h3 class="is-style-typestyle-h6">macOS with .zip file</h3> <ul> <li>Exit StarDrop</li> <li>Download <a download="stardrop-script-export-to-excel_py3qt.zip" href="https://optibrium.com/wp-content/uploads/2024/05/StarDrop-Script-Export-To-Excel_py3Qt.zip" target="_blank" rel="noopener">StarDrop Script – Export To Excel_py3Qt.zip</a></li> <li>Extract the contents of <strong>the zip file</strong> into this folder overwriting any existing files, you should now see the following folders in the StarDrop folder:<br /> <b><strong>py3\Export To Excel<br /> </strong></b><strong>site-packages\xlwt</strong><br /> <strong>py3\Utils</strong></li> <li>In your user area, navigate to the StarDrop folder: <strong>/Users/username/StarDrop</strong></li> <li>Move the unzipped folders, sub-folders, and files into the <strong>StarDrop</strong> folder, overwriting any existing files</li> <li>Start StarDrop</li> </ul> </div> <div class="tabs__tile nflm"> <h3 class="is-style-typestyle-h6">Windows with .exe file</h3> <ul> <li>Exit StarDrop</li> <li>Download <a download="stardrop-script-export-to-excel_py3qt.exe" href="https://optibrium.com/wp-content/uploads/2024/05/StarDrop-Script-Export-to-Excel_py3Qt.exe" target="_blank" rel="noopener">StarDrop Script – Export to Excel_py3Qt.exe</a></li> <li>When the download is complete, double-click the file to run it and follow the instructions (we recommend that you accept the default options provided)</li> <li>Start StarDrop</li> </ul> </div> </div> </div> <div role="tabpanel" tabindex="0" id="tabpanel-1" aria-labelledby="tab-1" class="tabs__panel nflm is-hidden"> <p>Click on the<strong> Custom Scripts->Export to Excel</strong> menu item in StarDrop. If there is no data set open it will give a message saying that there is nothing to export. If there is a data set open, the contents will be copied into a Microsoft Excel worksheet and Microsoft Excel will automatically be opened to display the file.</p> <p><strong>Please note:</strong> StarDrop contains a number of data types that are not supported by Microsoft Excel, however, an accurate numerical or textual representation of each data point is exported wherever possible.</p> <p>It is possible to customise the formatting that appears in the Microsoft Excel file and some examples are provided which will be visible if you open the example StarDrop file <strong>StarDropDemo.add</strong> (the default installation path for this is <strong>C:\Program Files\StarDrop\Examples\StarDropDemo.add</strong>) and export the complete file using this script. To change the formatting you must manually edit the file <strong>myCriteria.py</strong> that is installed in<strong> C:\Users\\AppData\Roaming\StarDrop\py </strong>choosing any colours, fields and any criteria you wish to set define how a column of data should be displayed.</p> </div> </div> </div> <div class="tabs__accordion"> <details name="tabs-accordion-installing-and-using-the-script" > <summary class="tabs__accordion-title">Installation files</summary> <div class="tabs__accordion-panel nflm"> <div class="tabs__tiles"> <div class="tabs__tile nflm"> <h3 class="is-style-typestyle-h6">Windows with .zip file</h3> <ul> <li>Exit StarDrop</li> <li>Download <a download="stardrop-script-export-to-excel_py3qt.zip" href="https://optibrium.com/wp-content/uploads/2024/05/StarDrop-Script-Export-To-Excel_py3Qt.zip" target="_blank" rel="noopener">StarDrop Script – Export To Excel_py3Qt.zip</a></li> <li>In your user area, navigate to the StarDrop Python folder in <strong>C:\Users\username\AppData\Roaming\StarDrop</strong></li> <li>Extract the contents of <strong>the zip file</strong> into this folder overwriting any existing files</li> <li>You should now see the following folders in the <strong>StarDrop</strong> folder:<br /> <b><strong>py3\Export To Excel<br /> </strong></b><strong>site-packages\xlwt</strong><br /> <strong>py3\Utils</strong></li> <li>Start StarDrop</li> </ul> </div> <div class="tabs__tile nflm"> <h3 class="is-style-typestyle-h6">macOS with .zip file</h3> <ul> <li>Exit StarDrop</li> <li>Download <a download="stardrop-script-export-to-excel_py3qt.zip" href="https://optibrium.com/wp-content/uploads/2024/05/StarDrop-Script-Export-To-Excel_py3Qt.zip" target="_blank" rel="noopener">StarDrop Script – Export To Excel_py3Qt.zip</a></li> <li>Extract the contents of <strong>the zip file</strong> into this folder overwriting any existing files, you should now see the following folders in the StarDrop folder:<br /> <b><strong>py3\Export To Excel<br /> </strong></b><strong>site-packages\xlwt</strong><br /> <strong>py3\Utils</strong></li> <li>In your user area, navigate to the StarDrop folder: <strong>/Users/username/StarDrop</strong></li> <li>Move the unzipped folders, sub-folders, and files into the <strong>StarDrop</strong> folder, overwriting any existing files</li> <li>Start StarDrop</li> </ul> </div> <div class="tabs__tile nflm"> <h3 class="is-style-typestyle-h6">Windows with .exe file</h3> <ul> <li>Exit StarDrop</li> <li>Download <a download="stardrop-script-export-to-excel_py3qt.exe" href="https://optibrium.com/wp-content/uploads/2024/05/StarDrop-Script-Export-to-Excel_py3Qt.exe" target="_blank" rel="noopener">StarDrop Script – Export to Excel_py3Qt.exe</a></li> <li>When the download is complete, double-click the file to run it and follow the instructions (we recommend that you accept the default options provided)</li> <li>Start StarDrop</li> </ul> </div> </div> </div> </details> <details name="tabs-accordion-installing-and-using-the-script" > <summary class="tabs__accordion-title">How to use the script</summary> <div class="tabs__accordion-panel nflm"> <p>Click on the<strong> Custom Scripts->Export to Excel</strong> menu item in StarDrop. If there is no data set open it will give a message saying that there is nothing to export. If there is a data set open, the contents will be copied into a Microsoft Excel worksheet and Microsoft Excel will automatically be opened to display the file.</p> <p><strong>Please note:</strong> StarDrop contains a number of data types that are not supported by Microsoft Excel, however, an accurate numerical or textual representation of each data point is exported wherever possible.</p> <p>It is possible to customise the formatting that appears in the Microsoft Excel file and some examples are provided which will be visible if you open the example StarDrop file <strong>StarDropDemo.add</strong> (the default installation path for this is <strong>C:\Program Files\StarDrop\Examples\StarDropDemo.add</strong>) and export the complete file using this script. To change the formatting you must manually edit the file <strong>myCriteria.py</strong> that is installed in<strong> C:\Users\\AppData\Roaming\StarDrop\py </strong>choosing any colours, fields and any criteria you wish to set define how a column of data should be displayed.</p> </div> </details> </div> </div> </div> </section> </div> </div> </main> <footer class="site-footer"> <div class="site-footer__inner alignwide"> <div class="site-footer__top"> <div class="site-footer__logo"> <a href="https://optibrium.com/"><img src="https://optibrium.com/wp-content/themes/optibrium/assets/images/logo.svg" alt="Optibrium" loading="lazy" width="187" height="56"></a> </div> <nav class="site-footer__nav"> <ul id="menu-footer" class=""><li id="menu-item-360" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-360"><h2 class="site-footer__nav-heading has-icon">Products<span class="menu-item-icon img-fit" aria-hidden="true"><img src="https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/stars.svg" alt="" loading="lazy" width="24" height="24"></span></h2> <ul class="sub-menu"> <li id="menu-item-930" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-930"><a href="https://optibrium.com/products/stardrop/">StarDrop</a></li> <li id="menu-item-931" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-931"><a href="https://optibrium.com/products/cerella/">Cerella</a></li> <li id="menu-item-932" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-932"><a href="https://optibrium.com/products/biopharmics/">BioPharmics</a></li> <li id="menu-item-933" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-933"><a href="https://optibrium.com/products/semeta/">Semeta</a></li> </ul> </li> <li id="menu-item-934" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-934"><h2 class="site-footer__nav-heading has-icon">Optibrium<span class="menu-item-icon img-fit" aria-hidden="true"><img src="https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/people.svg" alt="" loading="lazy" width="40" height="40"></span></h2> <ul class="sub-menu"> <li id="menu-item-1737" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1737"><a href="https://optibrium.com/careers/">Careers</a></li> <li id="menu-item-1735" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1735"><a href="https://optibrium.com/products/support/">Customer support</a></li> <li id="menu-item-1736" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1736"><a href="https://optibrium.com/about-optibrium/contact-us/">Contact</a></li> <li id="menu-item-1741" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-privacy-policy menu-item-1741"><a rel="privacy-policy" href="https://optibrium.com/privacy-policy/">Privacy and cookies policies</a></li> </ul> </li> <li id="menu-item-936" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-936"><h2 class="site-footer__nav-heading has-icon">Social<span class="menu-item-icon img-fit" aria-hidden="true"><img src="https://optibrium.com/wp-content/themes/optibrium/assets/images/theme-icons/chat.svg" alt="" loading="lazy" width="40" height="40"></span></h2> <ul class="sub-menu"> <li id="menu-item-938" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-938"><a target="_blank" href="https://www.linkedin.com/company/317193">Linkedin</a></li> <li id="menu-item-939" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-939"><a target="_blank" href="https://www.youtube.com/@OptibriumLtd">YouTube</a></li> <li id="menu-item-937" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-937"><a target="_blank" href="https://www.twitter.com/optibrium">X</a></li> </ul> </li> </ul> </nav> </div> <div class="site-footer__bottom nflm"> <p><img class="alignright wp-image-2191 iso-27001" src="data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZpZXdCb3g9IjAgMCA3NSA3NSIgd2lkdGg9Ijc1IiBoZWlnaHQ9Ijc1IiBkYXRhLXU9Imh0dHBzJTNBJTJGJTJGb3B0aWJyaXVtLmNvbSUyRndwLWNvbnRlbnQlMkZ1cGxvYWRzJTJGMjAyNCUyRjA1JTJGMjcwMDEtTU9OTy1XaGl0ZS0xLmpwZyIgZGF0YS13PSI3NSIgZGF0YS1oPSI3NSI+PC9zdmc+" data-spai="1" alt="ISO 27001" width="75" height="75" />Optibrium © 2024 All Rights Reserved.<br /> Optibrium™, StarDrop™, Inspyra™, Augmented Chemistry®, Cerella™, Semeta™, Glowing Molecule™, WhichP450™, <span class="ui-provider eo blf bhq bun buo bup buq bur bus but buu buv buw bux buy buz bva bvb bvc bvd bve bvf bvg bvh bvi bvj bvk bvl bvm bvn bvo bvp bvq bvr bvs" dir="ltr">WhichEnzyme™,</span> Auto-Modeller™, Nova™, MPO Explorer™ and Card View® are trademarks of Optibrium Ltd.<br /> Matsy™ is a trademark of NextMove Software Ltd, BIOSTER™ is a trademark of iKem Szolgáltató és Kereskedelmi BT, Derek Nexus™ is a trademark of Lhasa Ltd, BioPharmics™, eSim™, ForceGen™, QuanSA™ and Surflex™ are all trademarks of BioPharmics LLC, and SeeSAR™ is a trademark of BioSolveIT GmbH. US Patent Numbers 9,224,098 and 9,367,812</p> </div> </div> </footer> <link rel='stylesheet' id='tabs-styles-css' href='https://optibrium.com/wp-content/themes/optibrium/assets/components/tabs/styles/block.css' media='all' /> <script id="leadin-script-loader-js-js-extra"> var leadin_wordpress = {"userRole":"visitor","pageType":"post","leadinPluginVersion":"11.1.73"}; </script> <script src="https://js-eu1.hs-scripts.com/26508147.js?integration=WordPress&ver=11.1.73" id="leadin-script-loader-js-js"></script> <script id="granola-scripts-js-extra"> var params = []; </script> <script src="https://optibrium.com/wp-content/themes/optibrium/assets/main.js" id="granola-scripts-js" defer data-wp-strategy="defer"></script> </body> </html>