Share this page

# Format defects

Before you upload your defects to the ALM Defects module, you format the defects in your spreadsheet.

To format a defect:

1. Open your Google Sheets spreadsheet.

2. Define each defect on a separate row. For each defect, you must define all required fields as defined in your ALM project.

Consider the following points when formatting defects:

- If you enter data in a Detected in Release, Detected in Cycle, Target Release, or Target Cycle field, you must include the path preceding the release or cycle. Separate each hierarchical level with a backslash (\) character.

  Example: parent1\parent2\TC1

  Make sure not to use a forward slash. If a Target Release or Target Cycle value is unique, you do not need to include its preceding hierarchy.

- If you enter data in a Target Cycle field, and leave the Target Release field empty, the Target Release field will be automatically filled with the value corresponding to the Target Cycle field.

- If you enter data in a Detected in Cycle field, and leave the Detected in Release field empty, the Detected in Release field will be automatically filled with the value corresponding to the Detected in Cycle field.

Example: Suppose you want to upload the following defects:

After you upload the defects to ALM, the defects are displayed in the Defects module.

Note: When an ALM defect field has an input mask, the mask is not checked when you upload defects from Excel to ALM.

Back to top

See also:

- Guidelines for formatting
- Format requirements
- Format tests
- Format attachments

Next steps:

- Upload data from Google Sheets to ALM

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: