CHEMCATS - Information on Submitting an Excel File

Each record should contain:
  • Chemical name (required)
  • CAS Registry Number® 
  • Unique catalog or order number

To maximize visibility in SciFinder®, the following product details are strongly encouraged:

  • Availability (Maintained in stock, Typically in stock, Limited or intermittent availability, Synthesis on demand) new
  • Ships Within (1 week, 2 weeks, 4 weeks, 8 weeks, Over 8 weeks) new
  • Price
  • Quantity

Please send your Excel® file in a format similar to the example below or click to download the CHEMCATS Excel template:

 


  • Each product is contained in one row with one column dedicated to a particular data type.
  • If multiple pieces of information are to be contained in a cell, use a semicolon to delimit each new piece of information (see example above).
  • For price and quantity information, only include one price per quantity of product.
  • Before importing CAS Registry Numbers into Microsoft Excel, make sure the column-data format is selected as "Text" to avoid the problem of CAS RNs turning into dates.
  • If your CAS Registry Numbers are converted to date-format in Microsoft Excel while typing (ex. 2015-11-4 appears as 11/4/2015), place a single quote before the CAS Registry Number in your spreadsheet to prevent erroneous auto-formatting.
  • Do not use special characters such as Greek, Chinese or Japanese characters, special chemical symbols, trademark or copyright characters, etc.  Instead of special characters, write out the text equivalent for such characters.
  • Do not send files with images.

Please note: Suppliers with large catalogs may be required to submit information using the SDF format.

Send inquiries to chemcats@cas.org.