> For the complete documentation index, see [llms.txt](https://help.conviu.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.conviu.com/data-editing-xml-and-csv/bulk-editing-of-data.md).

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