JChem for Office

Making chemistry happen in Excel, Word, PowerPoint & Outlook

JChem for Office integrates chemical structure handling, data analyzing, visualizing and reporting capabilities within the Microsoft Office environment. Structures can be edited and also copy/pasted throughout Excel spreadsheets, Word documents, PowerPoint slides and even Outlook e-mails. The JChem add-on equips your Excel with robust chemistry handling. It provides ultra fast loading or scrolling throughout virtually thousands of structure rows. Structure based calculations, R-group decomposition, library enumeration and SAR-table generation belong to the more advanced functionalities that JChem for Office can offer.
Play video play_arrow

Live chemical structures throughout Office

You can enrich documents with reactions, calculations and live chemical structures. 'Live' means that you can modify molecules, and values in related Excel cells will automatically change instantaneously. You can keep pre-defined display settings when copying or pasting a structure, and local settings can be applied respectively.

JChem for Office without a license

When it comes to; Word documents, PowerPoint slides, and e-mails sent from Outlook, if created using JChem for Office - they can be conveniently read without a license. Excel files with structures and JChem for Excel functions are also visible without installation or license.

Editable chemical structures in MS Office using JChem technology

Import and export content

JChem for Office can connect to different database engines (Oracle, MySQL, MSSQL and PostgreSQL). When importing a database, you have the option to pre-filter the data; you can include internal compound IDs as well. If you have a list of compound IDs only, without actual structures, JChem for Office can retrieve the IDs for you from your database. JChem for Office can handle all standard chemical file formats (sdf, rdf, IUPAC name, smiles, mrv) at import and export. Importing and managing thousands of rows with chemical and non-chemical data won't affect its robust performance.
You can connect JChem for Office to our Instant JChem Enterprise software; and receive selections and projects via a bridge. By using our Document to Structure tool, you can additionally extract chemical names and structures from documents (pdf, txt, html, xml, MS Office, OpenOffice ODT etc.) as live structures into JChem for Office.

Import chemical compounds by their ID into JChem for Excel

Extending Excel features for chemistry

Our structure-based calculations are integrated into MS Excel's custom functions. One of our add-on products, the Calculator Plugins makes it possible to populate your cells with physico-chemical properties, molecular descriptors or topology analysis results. This integration means that dependent colums are automatically updated if a new row is added or a chemical structure is edited. Chemical Terms, a language for combining and extending Calculator Plugins is also natively integrated. You can easily set up complex structure based arguments.
Structures can be filtered from the active worksheet available additionally. You can search for structures by query structure and specified search options. Similarity, substructure, full structure, superstructure and duplicate searches are directly available in JChem for Excel. To narrow down the hit list, it's possible to apply further structure filtering. Chemical data-sets can be easily divided and rows can be selected or exported into standard chemical files that can be further processed by other applications.

Chemical functions used in JChem for Excel

Structure-Activity Relationship table generation

There are also KNIME nodes and Pipeline Pilot components to handle JChem for Excel workbooks in batch mode. Exporting data from these applications can be further analysed also by R-group decomposition to generate either Markush tables providing input for virtual library generators; or Structure-Activity Relationship (SAR) tables that are often used during the drug development phases. The resulting R-group table can further be characterized using the JChem for Excel functions together with the Excel functions; frequently occurring substituents and their contributions to the biological activity can be statistically evaluated. The results can be presented in JChem for Word or Powerpoint by simply copying the SAR-table together with conditional formatting and live structures.

SAR table in JChem for PowerPoint

Virtual library generation

JChem for Excel uses ChemAxon’s Reactor, synthesis engine for virtual library generation. The Reactor engine is available via a simple JChem for Excel function in a single Excel sheet. The general reaction and the reactants are given in the excel sheet and reagents can be arranged in a sequential or combinatorial mode. Products or the whole reaction can be visualized. ChemAxon’s empirical smart rules are available in JChem for Excel, predicting the reactivity and selectivity and can be specified by the user through a generic reaction. For more about generating generic reactions see reaction rules. ChemAxon’s enumeration technology allows applying empirical smart rules in JChem for Excel, predicting the reactivity and selectivity.

Virtual library generation in JChem for Excel

Reporting Capabilities with JChem for Office

Direct import to Word, PowerPoint and Outlook is possible, or if you would like to create a report for a subset of compound IDs by connecting to a previously defined database connection in Excel and copy-paste the data to a Word or Powerpoint document. Imported data can be pre-formatted in Excel eg. by creating an SAR-table or a chart and then copy them to other Office applications. The report can be created in two different types of layouts.

Supported Office versions

Supported MS Office version of JChem for Office