Main Content

Import Excel Files into the Safety Analysis Manager

If you have safety analysis spreadsheets in Microsoft® Excel® files, you can import the spreadsheets into the Safety Analysis Manager. You can also import spreadsheets with document attributes into the Safety Analysis Manager.

Configure and Import a Spreadsheet

To import a spreadsheet from Excel, first configure the spreadsheet by following these steps:

  1. Create and save a new Excel file. If you import an Excel spreadsheet file with more than one sheet, the Safety Analysis Manager imports only the sheet in the first tab.

  2. Enter the headings for each column. For each heading cell, in the Number section, the number format list menu is General. Each sheet column must include a heading.

  3. In the rows below the headings, enter content that corresponds to each column. Use the same format for each cell in the column:

    • To define a check box column, enter TRUE or FALSE into the column cells.

    • Otherwise, the importer interprets the cell columns as text.

For example, this spreadsheet includes two text columns and one check box column.

An example spreadsheet in Excel. The spreadsheet has three columns, two are text, and the third is a Boolean. Each column specifies values for four rows. The headings are filled in, and the columns contain content.

Next, import the spreadsheet.

  1. Close the Excel file.

  2. Open the Safety Analysis Manager. On the Apps tab, under Model Verification, Validation, and Test, click Safety Analysis Manager.

  3. In the app, close the Safety Analysis Manager subwindow.

  4. In the File section, click Import.

Importing the spreadsheet shown above produces this Safety Analysis Manager spreadsheet.

The import results from the previously shown spreadsheet in Excel. The spreadsheet has three columns, two are text, and the third is a check box. Each column specifies values for four rows. The headings are filled in, and the columns contain content.

Import Document Attributes

To create a spreadsheet that includes document attributes:

  1. In the cell in the first row and column of the spreadsheet, enter DOCUMENT ATTRIBUTES. DOCUMENT ATTRIBUTES is case sensitive.

  2. In the cells in the DOCUMENT ATTRIBUTES column, enter the names of the document attribute properties. In the next column, enter the values.

  3. Leave an empty row between the document attributes and the spreadsheet.

  4. In the row below the empty row, in the same column as the document attribute properties, enter the word SPREADSHEET. SPREADSHEET is case sensitive.

  5. In the next row, enter the headings for each column. For each heading cell, in the Number section, the number format list menu is General. Each section column must include a heading.

  6. In the rows below the headings, enter content that corresponds to each column.

For example, this image shows the spreadsheet for the previous example with two document attributes.

An example document in Excel that includes document attributes. The document has two sections, one with the heading, DOCUMENT ATTRIBUTES, and SPREADSHEET. The DOCUMENT ATTRIBUTES section has two columns, and two rows below the heading. The section labeled SPREADSHEET has three columns.

Importing this spreadsheet also imports the document attributes.

The document attributes from the previously shown Excel document. The panel shows two properties, each with a value.

See Also

Related Topics