---
title: "Mass Editing Defects by Exporting and Importing"
slug: "mass-editing-defects-by-exporting-and-importing"
updated: 2022-04-03T10:57:49Z
published: 2022-04-03T10:57:48Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://success.panaya.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Mass Editing Defects by Exporting and Importing

You can **export**all Defects in your project to an **Excel**spreadsheet and make any required changes in the Excel file. Then, **import**the updated Excel file back to Panaya to perform the updates in bulk.

1. Hover over the **Defects tab**and select **Defects**
2. Click on **All Defects**to open up the **Views**list. Select the desired view to **filter** down the list of Defects.  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1648037159642.png)
3. Use the **Select****Columns**button to add any relevant **fields**you wish to change.  
Only fields you select here will appear in the exported Excel spreadsheet.  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1648037190371.png)
4. Click on the **Export**button to export the list to an Excel spreadsheet.  
![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1648037232704.png)
5. Open the downloaded file and make the necessary changes to the Defect.  
Upon completion,**save the file locally**.
6. Go back to the Defect list in Panaya and select **Import**> **Import to update existing Defects**  
**![](https://cdn.document360.io/f404076c-de23-4609-848e-2dfd4ef701b0/Images/Documentation/image-1648037286167.png)**
7. Follow the instructions in the **Update Defects Wizard** to upload the Excel file with the changes back to Panaya.  
The**User Mapping**section in the Wizard allows to auto-assign Defects to the relevant users in Panaya. Click here to learn more about [User Mapping](/v1/docs/how-to-use-user-mapping-when-importing-tests).

## Related

- [File User Mapping](/how-to-use-user-mapping-when-importing-tests.md)