Ignore Types

A CSV file often has additional rows that you don't want to import and upload to Xero. When setting up an import that uses types, use the Ignore Types field to exclude those rows.

By entering values in Ignore Types, those rows will not be imported or validated in UpSheets and will not be uploaded to Xero.

• The list can have multiple values separated by a comma.
• A wildcard (*) can be used to match other patterns.

All values are case sensitive.

Example

With the following entered in teh Ignre Types field:

Break, Public Holiday, Week*

Excluded (matched by the Ignore Types list):

• Break
• Public Holiday
• Week
• Week 1
• Weekly

Included (no match, so these are imported):

• Ordinary Hours
• Breaks
• Annual Holiday
• WEEK 1

For this to work, a Type column must be selected when importing the file.