---
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
canonical: "success.panaya.com/mass-editing-defects-by-exporting-and-importing"
---

> ## 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)