CRM & PEOPLE
Import people and organizations
Bring contacts and companies from a spreadsheet into People so surveys, groups and analysis start from one list.
Importing your contact list means UpSight knows who people are before they open a survey, so branching, groups and analysis are more relevant. The importer reads your column headers and proposes what each column is. You review it before anything is added.
What to put in the spreadsheet
Clear headers help. UpSight recognizes columns such as full name, first and last name, email, job title, company, phone, LinkedIn profile URL, website, location and industry. Any other column can come in as a Custom attribute, which you can then filter and group on (membership status, segment, plan, and so on).
How duplicates are handled
People are matched by email first, then by name and company. A match is updated rather than duplicated. Only cells with a value overwrite existing data; blank cells are ignored. You can upload an updated sheet as often as you like.
Linking contacts to an opportunity
Add a Deal / Opportunity column with the title of an opportunity that already exists, and a Role on the deal column. Those contacts are attached to that opportunity as stakeholders.
How tags work
A tag is a label on a person, such as an event, industry or segment. Tags come from imports, survey answers and conversations, and Groups and survey rules read them.
- Matching ignores capitals, spacing and punctuation, so "Summit 2026 – Day 1" and "summit 2026 day 1" are one tag. Different wording is a different tag.
- There is no "false" tag. Someone who did not attend simply does not have it.
- Imported tags are kept exactly as named, so "Day 1" and "Day 2" never merge.
Exporting from another tool
Anything that exports to CSV can be imported. Look for an Export action on the contacts list in your CRM, spreadsheet, email or donor-management tool, then save the result as CSV. For an Excel workbook with several tabs, save each tab as its own CSV.
Next
After import, people appear in People, linked to their organizations. To use them in surveys, see Survey distribution.
Import people from a CSV
Use this when your contacts live in a spreadsheet or another tool and you want them in UpSight in one go.
- Open People and click Actions, then Import CSV.
- Drop your spreadsheet on the page, or click to browse. CSV and TSV files work.
- Click Analyze file. UpSight tells you what it thinks the file is under We think this file is.
- If it guessed wrong, change it under Import it as. Choose People for a contact list.
- Under How each column imports, check every column. Each one can be a person field (such as Email or Job title), a Custom attribute, or Skip (ignore).
- Click Import people.
- Read the result screen. It shows how many people were added, updated or skipped.
Tips
- Matching is by email first, then by name and company. A person already in UpSight is updated, not duplicated.
- Blank cells never erase existing data, so you can re-import a corrected sheet safely.
- A Company column links each person to an organization.
- Made a mistake? See Undo a CSV import.
Tag people by event or day when you import them
Use this when you want to group people, or change a survey, by the event or day they attended.
Option A: one sheet, one column per day
- Give each person a row with their email.
- Add one column per day. Name it the way you want the tag to read, for example "Summit 2026 – Day 1".
- Put yes, true, x or a check mark for people who attended. Leave it blank for people who did not.
- Import the file as in Import people from a CSV.
- In How each column imports, the day columns show as Tag when checked. Edit the tag name if needed.
Option B: one sheet per day
- Make one file per day, listing only the people who attended. Include email in every file.
- Import the first file. In Tag everyone in this file, type that day's name.
- Repeat for each file. Someone in both files ends up as one person with both tags.
Tips
- Put the event name in the tag. Tags are shared across your account, so a bare "Day 1" would be reused next year.
- Re-importing never removes a tag. Clearing a cell does not clear a tag already imported.
- Pick tags from the list when you build a group, so the spelling always matches.
Undo a CSV import
Use this when you imported the wrong file or mapped columns incorrectly.
Right after importing
- On the result screen, click the Undo button. It says how many new people it will remove.
- Confirm that the people are gone from People.
Later, from the history
- Open People and click Actions, then Import History.
- Under Recent imports, find the import by file name.
- Click Undo on that row. It shows Rolled back afterward.
Good to know
- Undo removes the people that import created. It does not put back values the import changed on people who already existed.
- After undoing, fix your file and import it again. See Import people from a CSV.