All docs

Import, export and bulk actions

Bring people in from a CSV file, take your contacts out as a CSV, and tag, assign or erase many contacts in one go.

Updated . 4 min read.

Everything here works on many contacts at once, so it all runs in the background. You can leave the page and come back. Open Contacts and use Import, Export and the checkboxes at the start of each row.

Import contacts from a CSV file

  1. Choose Import, pick your file under CSV file and choose Upload and continue.
  2. Under Match the columns, say what each column holds, or choose Ignore this column.
  3. Choose what happens to people who already exist, and optionally tag everyone or add everyone to a list.
  4. Tick I am allowed to import these people.
  5. Choose Check without importing first, then Import contacts.

What the file needs

  • The first row holds the column names.
  • At least one column must be matched to an Email, a Phone or a User ID, because that is how a person is recognised.
  • You can also match Name, First name, Last name, Company, City, Marketing consent (yes or no), Tags (separated by commas) and any of your custom fields.
  • Commas, semicolons, tabs and pipes work as separators. Common column names, in English and in German, are matched for you.
  • A file can be up to 10 MB. The number of rows depends on your plan:
Plan Rows in one import
Pro 5,000
Team 25,000
Scale 50,000

Check before you import

Check without importing goes through the whole file and tells you how many people would be new, updated, skipped or failed. Nothing is saved. Fix what you find, then import.

When a person already exists

Under When a person already exists, choose Leave them as they are to skip them, or Update them with the file to fill in what the file knows. A person is recognised by email, phone number or user ID.

Consent is never assumed

The checkbox I am allowed to import these people. is required for a real import. An import never records marketing consent by itself. Consent is saved only for rows where the consent column says yes. Everyone else keeps no decision on file. See Notes and consent.

Progress and results

The import is queued and shows its progress while it runs. At the end you see New, Updated, Skipped and Failed, and they add up to the rows in your file. Rows that failed are listed with the reason, for example The email address is not valid. Choose Download all failed rows (CSV) to get every one of them, correct them and import that file again.

A few rows fail on purpose:

  • A person who was erased from the workspace is not imported again.
  • A row whose email, phone number and user ID belong to different contacts is not guessed at.
  • A new person is refused once your plan's contact limit is reached. See Data and privacy.

Your uploaded file and the error report are deleted a week after the import finishes. A file that was uploaded but never imported is deleted after 30 days.

Export contacts to a CSV file

Set the filters you want on the contacts list, then choose Export. Formspring prepares a CSV of the matching contacts in the background and shows Download CSV when it is ready.

  • The export holds only the contacts you are allowed to see, and only those that match your filters.
  • The download link expires after 24 hours. After that the file is deleted. Export again if you need it.
  • Any cell that starts with a character spreadsheets treat as a formula is made safe, so opening the file cannot run anything.

Bulk actions

Tick the checkbox at the start of a row, or Select all contacts on this page. A bar shows how many are selected. To act on everyone who matches the current filters, choose Select all contacts that match and check the count it shows.

Then pick an Action, a Target where needed, and choose Apply.

Action What it does
Add tag Puts a tag on the contacts.
Remove tag Takes a tag off.
Add to list Adds the contacts to a list.
Remove from list Takes them off a list.
Set owner Makes one team member the owner.
Erase contacts Permanently erases the people and their personal data. You confirm first.
  • Each contact is checked on its own. If you may not change one of them, that one is skipped and the rest go ahead. The result reads like Add tag finished: 48 done, 2 skipped.
  • If the number of matching contacts changes between your selection and your confirmation, Formspring asks you to review the new count before it does anything.
  • One action can reach up to 100,000 contacts.
  • Merging is never a bulk action. You always choose which contact to keep. See Duplicates and merging.