Import contacts, companies or canned replies from a CSV

Upload a CSV spreadsheet to add people, companies or canned replies to Opskeet. Map each column and nothing is sent to anyone.

Updated
On this page

A CSV is the quickest way to bring in a list from anywhere. Nothing is sent to anyone.

Owners and admins can import.

Steps

  1. Go to Settings → Import & export and click Spreadsheet (CSV).
  2. Choose a .csv file. A dialog opens: "Choose what each column is."
  3. Pick a tab: People, Companies or Canned replies.
  4. For each column, pick what it is from the dropdown. Opskeet guesses from the header.
  5. Click Import N people (or companies, or canned replies).

A result shows what was imported, how many were already here and how many were skipped.

Column choices

TabColumns you can map
PeopleName, First name, Last name, Email, Phone, User ID, Company, Tags, Country, City, Time zone, Signed up, Unsubscribed, Custom field, or Skip
CompaniesName, Website, Company ID, Created, Custom field, or Skip
Canned repliesTitle, Reply, or Skip

Several tags in one cell can be separated by commas, semicolons or |.

Run it again safely

A row's identity is its email or user ID, so importing the same sheet again matches existing people instead of adding twice.

Undo

Spreadsheet imports show in the Imports list and can be undone.

Big sheets

A bar shows progress. Keep the dialog open until it says Imported.

Did this help?

Related articles