Click on LAYOUT/FILTER symbol and select Select/Move/Filter

In the example below, all records for suppliers with Supplier Category / WOVEN will have the category updated.

Click Select/Move/Filter button

Tick the CATEGORY

Now filter by CATEGORY. Start typing and the options will appear. Select categories (the 'No Filter' field will change to 'Is Filter').

When finished click OK.

Now your filtered records are selected and you can export them.

You can change data in any column EXCEPT SUPPLIER.

Do not use these symbols: £, €, ¥, § (Excel replaces them with other characters when saving as CSV).

In the example below, I want to add WOVEN to all blank CATEGORY fields and Change the Currency of Batrado from GBP to EUR.

You can use Filters to isolate records you want to change - new entries are CASE SENsITIvE.

Remove all filters and save your file ready for import

Remove if you've chosen the incorrect file.

1. If you untick any columns they won't be imported
2. INVALID columns won't be imported (the column header is not recognised)
3. Only VALID columns will be imported including those you have ADDED/AMENDED

Your import has been validated - click OK

1. Action - tells you if this record is UPDATE or NO CHANGE
2. Fields in GREEN are about to be UPDATED. You can click on these and see what the field was BEFORE import and what it will be AFTER import

Confirm action [OK].