Share this page

# Guidelines for formatting

When formatting requirements, tests, or defects in your Google Sheets spreadsheet, consider the following:

- Arrange the records that you want to upload in rows.

- For each field that you want to upload, designate a column. Make sure to include all the required fields for requirements, tests, and defects, as defined in your ALM project.

- You can manually map ALM fields to spreadsheet columns, or the Google Sheets add-on can automatically map them. To enable automatic mapping:

  - Include a header row with heading names that are identical to the ALM field names.

  - The automatic mapping scans the header row for matching fields until the first empty cell. Make sure not to leave empty cells in the header row.

- Make sure that each requirement, test, or defect contains data for all the required fields, as defined in your ALM project. For details about the system and user fields defined in your project, see Customizing ALM Projects.

- To upload multiple values to ALM fields that support multiple values, separate the values with a semicolon (;) character.

- Field data must not exceed the field size in ALM.

- Data intended for ALM fields that have selection lists must match the entries in those selection lists exactly. For example, the Priority field can accept only one of the following values: 5-Urgent, 4-Very High, 3-High, 2-Medium, or 1-Low.

- You can upload attachments for requirements, tests, or defects. For more information, see Format attachments.

- You can upload design steps for tests.

- You cannot upload information indirectly related to requirements, tests, or defects. For example, if uploading tests, you cannot specify the requirements covered by each test.

  However, if you modify or add tests in Google Sheets and upload the data again to ALM, the existing tests are updated in the test plan module, and any test coverage to requirements is preserved.

- Each requirement, test, or design step on the same hierarchical level must have a unique name. If a name is not unique, it will be overwritten. For example, if your spreadsheet contains two requirements on the same hierarchical level with the same name, only one is created.

See also:

- Format attachments
- Format requirements
- Format defects
- Format tests

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 16.00 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: