Ignore Types
Your data source may have 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 automatically when importing.
By entering values in Ignore Types, those rows will not be imported or validated in UpSheets and will not be uploaded to Xero. This will speed up your process and make it easier to view the data you want to upload.
- 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 the Ignore 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.
