Skip to content
Product overview
Explore all 15 product areas1. Services and Offer2. Ideal Client Profile3. Find Prospects4. LinkedIn Network5. Relationship Management6. Relationship Intelligence7. Value Audits8. Personalised Outreach9. Authority and Content10. Meeting Intelligence11. Pipeline and Opportunities12. Proposals13. Deal Rooms14. Client Management15. Grow Existing Accounts
Today and AssistSell your business
Use cases Pricing In Person Workshop Resources Sign in Book a call
Home / Wiki / Guides
Guides

Bring your people in from a spreadsheet or old CRM

You'll learn how to: bring a spreadsheet of people into Nynch with every column mapped, duplicates handled and a way back if the file was wrong.

Time: 15 minutes.

Step 4 of 30 in Your first 30 days.

Before you start

  • Required: a CSV file with one person per row, saved from Excel or Google Sheets. It needs an Email column or a LinkedIn URL column. Nynch will not map the file without one of them. Each file can hold up to 10,000 rows.
  • Makes it better: custom fields for any column Nynch does not have. Add them first, as shown in part 1. Set up the rest in Fields, tags and Contact Status.
  • Makes it better: a team. With two or more people in your workspace, Nynch asks who should own the people you import.

1. Add the fields your file needs

  1. Click the ... button in the People toolbar, then click Settings.
  2. Open the People tab. Under Contact Custom Fields, click Add Field.
  3. In Create Custom Field, type a Field Label, such as Region. Choose a Field Type.
  4. For a Select or Multi-select field, add each choice under Options.
  5. Click Save.

2. Start the import

  1. Click the ... button in the People toolbar, then click Import CSV. The window is called Import Contacts.
  2. On Upload, read the line Maximum: 10,000 rows per file. Nynch refuses a larger file, so split it first.
  3. Optional: under Assign all directly to a rhythm (optional), pick a rhythm for every person in the file. Tick These are LinkedIn connections only if the file came from a LinkedIn export.
  4. Click Click to upload CSV and choose your file.

3. Map the columns

  1. On Map, if you have teammates, choose an owner under Who should own the people you import? New people go to that person. People already in Nynch keep their owner.
  2. Check each column under CSV Column against the field it fills under Maps to Field. Choose Skip this column for anything you do not want.
  3. Map a column to Company to link each person to their company. Map Tags (comma-separated) to bring in tags. Nynch groups rows by company name and website, so each company is written once.
  4. Your custom fields appear in the list with (Custom) after their name.
  5. Under the mapping, choose what happens to people already in Nynch. Only fill empty fields is the default. It never changes a value that is already there. Replace with the file’s values overwrites them.
  6. Click Next: Review & Filter.

4. Filter and handle duplicates

  1. On Filter, you can leave the rules empty. To drop a group, choose Remove Matching Rows or Keep Matching Rows, pick a column and a condition, then click Continue. To skip filtering, click Skip Filtering (Import All).
  2. On Dupes, choose how matches are handled. Smart Deduplication is marked Recommended. It matches on email and LinkedIn URL, merges exact matches and flags likely ones. Skip Duplicates leaves matches out. Update Existing merges every match without a review step. Import All as New creates every row, even if the person is already there.
  3. Click Continue with Import. Wait for the Done step.

5. Undo an import you did not mean to run

  1. Click the ... button in the People toolbar, then click Import History.
  2. Find the import and click Undo. The Undo Import window shows Will be removed and Edited since import (kept).
  3. Read both numbers, then click the button at the bottom that names the number of contacts it will undo.

Undo removes the people the import created, but keeps anyone you have edited since.

Check it worked

  • The Done step shows the number of rows you expected.
  • The new names appear on People, with your custom field filled in.

FAQ

Q: Can I import a file with more than 10,000 rows? No. Nynch refuses a file over 10,000 rows. Split it into parts of 10,000 or fewer, save each part as its own CSV, and import them one at a time.

Q: Will the import overwrite people I already have? Not by default. Under Map, Only fill empty fields is selected, so it only fills blanks. Choose Replace with the file’s values only when the file holds the newer information.

Q: What happens to the companies in my file? Each company is written once. If a company in your file clashes with one already in Nynch, Nynch can stop and ask you to check it.

If something goes wrong

  • Symptom: Map says an identifier is missing. → Fix: map a column to Email or LinkedIn URL.
  • Symptom: Nynch refuses the file. → Fix: check the row count. Over 10,000 rows, split the file and import each part.
  • Symptom: The import brought in the wrong people. → Fix: open Import History, click Undo on that import, and check the numbers before you confirm.
  • Symptom: A custom field is missing from the mapping. → Fix: create it under Settings, then People, and start the import again.

Next: Bring in your whole LinkedIn network

Related: Import contacts from a CSV, Add a tag to a contact