The bulk upload links are found under the (+) button, found on the top right of most pages. Each data type has it's own template and field documentation available within the app.
Fields that support multiple values
tags, email, telephone, connections and other fields all support multiple values. When uploading a bulk file you need to think carefully about the behaviour you want.
The default behaviour is to over-write or replace the existing fields. Uploading a column 'tags' with a value 'my-new-tag' will remove all existing tags and replace with a single tag.
For multiple values use multiple columns with a numeric postfix e.g. emails.1, emails.2, emails.3 as three separate columns.
The number after the field name is an index (a counter) into the list of values. If you want to replace values then start counting at '1'. If you want to add values to the list then start with a number that you are confident is above the likely number of values (e.g. 100)
If the data for tags is
apple, banana, pear
orange, kiwiin column “tags” result. tags =
orangein column “tags.1",
kiwiin column “tags.2” result: tags =
orange, kiwi, pear
orangein column “tags.101"
kiwiin column “tags.102” result tags =
apple, banana, pear, orange, kiwi
(Sheep will try to add those values as positions 101 and 102, they are beyond the end of the list so they just go on the end)
To delete records in bulk use a column named
delete and fill the cells with
Y . Be careful, Sheep doesn't offer a bulk undelete.