# Bulk editing of data

With this rule, you can bulk edit hundreds of products in minutes. It is possible to generate a csv file for editing. You can edit the file in Excel according to your requirements and then upload it back. To reload, it is necessary to leave the first column ITEM\_ID, according to which the data is paired and modified (overwritten). For example, if you are editing names, use csv in the ITEM\_ID format to reload; PRODUCTNAME; PRODUCT. I.e. do not upload elements (columns) that you do not edit. Use only the modified data file for uploading. 

First choose Export -> Edit 

![](/files/iIu1w57qDfNHw3GExhVQ)

Then go to Rules -> New rule 

![](/files/5cCvtBehVRuSQxgp7iLt)

![](/files/LpvBHU4DptSI4v79WQ0I)

For bulk editing, you need to download csv and save.

![](/files/qt1Cg7NXJWJT44SB6EL4)

Then edit the file as needed. E.g. The following is an example of modified 6 products for which the name has been modified, ie PRODUCT and PRODUCTNAME.

You can then upload the file and create a bulk transcript rule. 

![](/files/gRUpAylYmFX4PrdwqirI)

Leave only these columns in the file - it is always necessary to keep the product ID (according to the comparator, eg ITEM\_ID, g: id,…) and also the columns with modified data. In our case, the file contains 3 columns and 7 rows. 

This file must be saved in csv UTF-8 format. 

You can then upload the file and create a bulk transcript rule.

![](/files/qt1Cg7NXJWJT44SB6EL4)

The rule must be saved by clicking on Create rule. 

Another option is to edit the data using Google Sheets. See the Bulk Data Editing - Google Sheets procedure. 

If you use the csv file to edit hundreds of products, we recommend that you let Regenerate Export be followed

![](/files/cRg3F7OdA3RXDEaqXmU0)

To check, you can download data from the entire export to csv and check the data.

![](/files/VWUeTAFQMQN9ZT2iApEf)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.conviu.com/data-editing-xml-and-csv/bulk-editing-of-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.