Exporting Data

Table data and chemical search results may be exported in one of four formats:

• Comma-separated text file (.csv)
• Microsoft Excel formatted text (.xls)
• Microsoft Excel unformatted text (.xls)
• HTML file (.html)

A maximum of 50 rows may be exported at any one time using the options below.

• Row Range - type a row range into the min-max fields.  The rows will be exported by the row number displayed in the table, ignoring any applied filtering or sorting.
• Selected Rows - Any selected rows in the table or chemical search results will be exported.  This option respects any ordering applied to the table/search results.
• Current Page - Exports the current page.  This option is only available for pages of 50 or fewer rows.

A maximum of 50 rows may be exported at any one time.

Select the file type to which you wish export then click Export Data.

Printing

If you wish to print table data then it is recommended that you use the HTML option since it will retain the formatting in the original table.

Export Formats

Your browser settings will determine how the resulting file is opened or saved.  Please refer to your web browser help for more information on saving or opening files.

Comma-separated text file

• A simple flat text file which can be opened in most spreadsheet applications.
• All html markup is retained and any MathML equations present will display in markup form.
• Structures are not exported.

Microsoft Excel

• Two options are available for Excel documents, formatted and unformatted.
• Unformatted documents are exported with html tags.
• Formatted documents will display bold, italics etc.
• Choose auto-column width to automatically set the width of each column to fit the data.
• Structures are not exported.

HTML file

• A simple html file. This may be the best option if you just wish to copy formatted text into another application.
• HTML exports will show as fully formatted text, including any MathML equations.
• Structures are exported if the structure field is included in the search result table.
• Your browser settings will determine how the resulting file is opened or saved.  Please refer to your web browser help for more information on saving or opening files.