{"id":11610,"date":"2022-10-24T14:55:19","date_gmt":"2022-10-24T14:55:19","guid":{"rendered":"https:\/\/www.stoneshot.com\/learn\/?p=11610"},"modified":"2024-10-15T16:13:07","modified_gmt":"2024-10-15T16:13:07","slug":"importing","status":"publish","type":"post","link":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/","title":{"rendered":"Importing"},"content":{"rendered":"<h2>Importing using a CSV<\/h2>\n<p><script src=https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c.jsonp async><\/script><script src=https:\/\/fast.wistia.com\/assets\/external\/E-v1.js async><\/script><\/p>\n<div class=\"wistia_responsive_padding\" style=\"padding: 56.25% 0 0 0; position: relative;\">\n<div class=\"wistia_responsive_wrapper\" style=\"height: 100%; left: 0; position: absolute; top: 0; width: 100%;\">\n<div class=\"wistia_embed wistia_async_ujkyhf370c seo=true videoFoam=true\" style=\"height: 100%; position: relative; width: 100%;\">\n<div class=\"wistia_swatch\" style=\"height: 100%; left: 0; opacity: 0; overflow: hidden; position: absolute; top: 0; transition: opacity 200ms; width: 100%;\"><img decoding=\"async\" style=\"filter: blur(5px); height: 100%; object-fit: contain; width: 100%;\" src=\"https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c\/swatch\" alt=\"\" aria-hidden=\"true\" \/><\/div>\n<\/div>\n<\/div>\n<\/div>\n<h2>Importing from Salesforce<\/h2>\n<p><script src=https:\/\/fast.wistia.com\/embed\/medias\/atcmep7q3z.jsonp async><\/script><script src=https:\/\/fast.wistia.com\/assets\/external\/E-v1.js async><\/script><\/p>\n<div class=\"wistia_responsive_padding\" style=\"padding: 56.25% 0 0 0; position: relative;\">\n<div class=\"wistia_responsive_wrapper\" style=\"height: 100%; left: 0; position: absolute; top: 0; width: 100%;\">\n<div class=\"wistia_embed wistia_async_atcmep7q3z seo=true videoFoam=true\" style=\"height: 100%; position: relative; width: 100%;\">\n<div class=\"wistia_swatch\" style=\"height: 100%; left: 0; opacity: 0; overflow: hidden; position: absolute; top: 0; transition: opacity 200ms; width: 100%;\"><img decoding=\"async\" style=\"filter: blur(5px); height: 100%; object-fit: contain; width: 100%;\" src=\"https:\/\/fast.wistia.com\/embed\/medias\/atcmep7q3z\/swatch\" alt=\"\" aria-hidden=\"true\" \/><\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Our Importer is a simple tool enabling you to push contact data into StoneShot.<\/p>\n<p>Importing is a two-stage process. After selecting your contact list, the importer verifies the integrity of your data then offers a set of import options, and works work with the Comma Separated Value (CSV) format of data.<\/p>\n<h2>Preparing your list for Import<\/h2>\n<p>Before you import your contact list to StoneShot, we recommend following the below steps to avoid any complications going forward.<\/p>\n<ol>\n<li>Open your list in Excel and through filters:\n<ul>\n<li>Make sure you don\u2019t have duplicate contacts<\/li>\n<li>All contacts have a valid email address<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<ul>\n<li>Email address must always contain an \u201c<strong>@<\/strong>\u201d and a \u201c<strong>.<\/strong>\u201d<\/li>\n<li>Must not begin or end with an \u201c<strong>@<\/strong>\u201d or a \u201c<strong>.<\/strong>\u201d<\/li>\n<li>Must not contain any special characters like: <strong>( ) , : ; &lt; &gt; [ \\ ]<\/strong><\/li>\n<li>Make sure that each column has the right header\/title that matches the field name on the system. Eg. \u201cEmail\u201d not \u201cE-mail\u201d or \u201cEmail Address\u201d<em>* You can find out the right column headers by getting an export with all contact details as shown further down in this article.<\/em><\/li>\n<li>The last column needs to be full, with no empty cells. Since there always needs to be an email (Unless you are importing by CRM ID), we suggest keeping the email column or CRM ID as the last column.<\/li>\n<\/ul>\n<p>Once you are ready with the preparation, you can save the file to <strong>*.csv<\/strong> and import it in StoneShot.<\/p>\n<h2>How to import a list<\/h2>\n<p>Once you have your CSV file prepared, login to the StoneShot app and under <strong>Contacts <\/strong>select <strong>Import Manager<\/strong> &gt; <strong>Import contacts<\/strong> as shown below.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3859\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/12\/109.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p>Once you have clicked the Import Contacts button you will be able to see the Import wizard as shown below. Simply go through the steps to get your list importer.<\/p>\n<p>First, you\u2019ll be asked to choose either your csv file by using the Browse function or, if you have CRM integration such as Salesforce, the Salesforce report you wish to import from.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter1.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p>Select your file and click next once it has been successfully uploaded.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter2.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p>Now you\u2019ll be able to choose which columns from your Excel file to include in the upload. \u2018Columns\u2019 is the name in your file, \u2018Fields\u2019 is the options you can choose to import your column into, \u2018First Row\u2019 gives you an example of the data from your file, and \u2018Unique Identifier\u2019 is telling you how the importer will distinguish between contacts. This will always be Email unless you have a CRM ID in which case that will be chosen.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter3.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p>Once you\u2019ve mapped your fields, you\u2019re then going to decide what to do with your data.<\/p>\n<p>First you can decide whether to add your data to an existing list, create a new list from your data, or not create a list simply updating the contact information from your file into your account.<\/p>\n<p>Here you\u2019ll also choose what happens to new and existing contacts on your list be picking one of the below options:<\/p>\n<ul>\n<li>Add &amp; Update: adds new contacts and updates existing matching contacts<\/li>\n<li>Add Only: adds new contacts and skips those that already exist<\/li>\n<li>Update Only: skips any new contacts and updates matching ones<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter4.png\" alt=\"\" width=\"100%\" height=\"auto\" \/> \u2013 add to existing list<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter9.png\" alt=\"\" width=\"100%\" height=\"auto\" \/> \u2013 new list<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter10.png\" alt=\"\" width=\"100%\" height=\"auto\" \/> \u2013 no list<\/p>\n<p>You can import your list now if you wish by clicking \u2018Next\u2019. However, you may wish to use the Advanced Options section on the right-hand side of the screen. This gives you four different options on how to manage your list:<\/p>\n<ul>\n<li>Add Contacts into Segmentation \u2013 Get the importer to set all of the contacts in your list to a certain StoneShot segment. (e.g. Set all contacts to \u2018Region = UK\u2019, or \u2018Sales Manager = Mr Jones\u2019). All contacts in the list will be set to the segment you select.<\/li>\n<li>Change Email Preference &#8211; Get the importer to set all of the contacts in your list to a certain StoneShot Email Preference. (e.g. Set all contacts to \u2018Newsletter = Subscribe\u2019, or \u2018Webinars = Unsubscribe\u2019). All contacts in the list will be set to the email preference you select.<\/li>\n<li>Change Event Status &#8211; Get the importer to set all of the contacts in your list to a certain StoneShot Event status. (e.g. Set all contacts to \u2018Christmas Party = Invited\u2019, or \u2018Financial Seminar = Registered\u2019). All contacts in the list will be set to the event status you select.<\/li>\n<li>Manage Unsubscribes &amp; Bounces \u2013 If you wish to keep your list clean, you can choose to not import anyone set to Unsubscribed or Bounced. They will still exist in your account of course, just not in your mailing list.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter7.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter5.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/Newimporter6.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p>When you have selected all of your options, click on \u2018Next\u2019 and you\u2019ll be taken to a final summary screen. This will give you the details of what is about to happen to your import, what additional options you\u2019ve selected, if it\u2019s a new list etc.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter8.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p>One final thing to decide is whether to receive an email notification when your import has completed. This is set to on by default, and we\u2019d recommend keeping it on so you are aware when your import has completed. If you don\u2019t want to receive an email, simply turn the toggle off.<\/p>\n<p>When you are ready click on Import. This will take a few minutes, depending on how long the list is.<\/p>\n<h2>Import Report \u2013 if selected<\/h2>\n<p>Once your list is imported you will be emailed an automatic Import Report detailing all the information for your import. If there were any errors or contacts dropped from the import you will be able to see them on this import \u2013 this could be for reasons such an email missing or an invalid email address. \u2018Records Skipped\u2019 simply means that the contact record in your account was an exact match for the record in the import. It has still been included in the import list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter13.png\" alt=\"\" width=\"579\" height=\"446\" \/><\/p>\n<h2>Where can I see my import?<\/h2>\n<p>If you selected Create List, you can view your import by going to Contacts &gt; Lists<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-3865\" style=\"border: solid 1px #e2e5ea; padding: 10px;\" src=\"\/learn\/wp-content\/uploads\/2022\/10\/NewImporter11.png\" alt=\"\" width=\"100%\" height=\"auto\" \/><\/p>\n<p>The first list will be the latest import and it will be named with the name of your new list and a timestamp of the import. You can edit the name of the list by going into the list and clicking on the edit pencil.<\/p>\n<h2>Why is my list import erroring?<\/h2>\n<p data-type=\"unstyled\" data-id=\"f6863f46-98d3-4d97-bcaa-181b391345f0\">If you\u2019re trying to load in some data through the Import Manager tool and find yourselves getting errors messages, such as the one below, most times it can be fixed with a few simple steps:<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror1.png\" alt=\"image\" width=\"540\" height=\"292\" data-type=\"image\" data-meta=\"{&quot;size&quot;:21801,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;96fb75a0-1e2c-4157-97d9-11e2564011c8&quot;,&quot;dimensions&quot;:[603,326]}\" data-width=\"600px\" data-height=\"325px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/f8ce7e69-1a73-450c-a0db-d040d5b47b4a\/image\" data-id=\"96fb75a0-1e2c-4157-97d9-11e2564011c8\" data-created-at=\"2024-03-28T16:11:11.585Z\" data-loading=\"true\" data-media-id=\"7t0FYFlmsko0p4\" data-created-by=\"GKiNm8uBxv5OHV\" \/><\/figure>\n<ol data-id=\"cf141f20-e9f8-4b24-ada6-38b0012c4a74\">\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">Check to see whether your last column has a value for every row \u2013 a quick fix would be to move email address to the end so that this is the final column of your data set<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror2.png\" alt=\"image\" width=\"466\" height=\"128\" data-type=\"image\" data-meta=\"{&quot;size&quot;:23292,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;732b1d8e-d424-4887-9d29-dec452578760&quot;,&quot;dimensions&quot;:[748,205]}\" data-width=\"498px\" data-height=\"135px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/7e5afd6a-10fe-4d26-bdf3-6132eb66e474\/image\" data-id=\"732b1d8e-d424-4887-9d29-dec452578760\" data-created-at=\"2024-03-28T16:11:14.157Z\" data-loading=\"true\" data-media-id=\"lOOnv8HuAJMIX_\" data-created-by=\"GKiNm8uBxv5OHV\" \/><\/li>\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">The importer is picking up some hidden values in the columns to the right and underneath your data set<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror3.png\" alt=\"image\" width=\"583\" height=\"181\" data-type=\"image\" data-meta=\"{&quot;size&quot;:27235,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;025256ae-be08-4035-b570-8f5015870252&quot;,&quot;dimensions&quot;:[958,297]}\" data-width=\"576px\" data-height=\"179px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/2c7b9211-0e52-46e9-a6e5-9b5959c05b15\/image\" data-id=\"025256ae-be08-4035-b570-8f5015870252\" data-created-at=\"2024-03-28T16:11:12.038Z\" data-loading=\"true\" data-media-id=\"3zxFy6Zi3qpanI\" data-created-by=\"GKiNm8uBxv5OHV\" \/><br \/>\nThere are two ways to fix this:<\/p>\n<ol style=\"list-style-type: lower-alpha;\" data-id=\"cf141f20-e9f8-4b24-ada6-38b0012c4a74\">\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">Select all the empty columns to the right of your data set (either by clicking the column header and dragging until all the columns have been highlighted or clicking CTRL + Shift + Right Arrow Key)<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror4.png\" alt=\"image\" width=\"1322\" height=\"231\" data-type=\"image\" data-alignment=\"center\" data-meta=\"{&quot;size&quot;:39957,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;01096977-4ef8-44ee-8f60-3052704bccb1&quot;,&quot;dimensions&quot;:[1322,231]}\" data-width=\"576px\" data-height=\"101px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/509d8428-8bf6-455f-bfea-afefc0435aba\/image\" data-id=\"01096977-4ef8-44ee-8f60-3052704bccb1\" data-created-at=\"2024-03-28T16:11:13.898Z\" data-loading=\"true\" data-media-id=\"XizUqpnckZT96C\" data-created-by=\"GKiNm8uBxv5OHV\" \/>Then right click on the highlighted cells and either select Delete or Clear Contents<br \/>\n<img decoding=\"async\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror5.png\" alt=\"image\" data-type=\"image\" data-alignment=\"center\" data-meta=\"{&quot;size&quot;:45178,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;6f5d7680-1a11-4796-9cbd-ef0266c335e9&quot;,&quot;dimensions&quot;:[1211,364]}\" data-width=\"528px\" data-height=\"159px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/999dc6b8-7bc0-42b2-bd54-9e73af71daf2\/image\" data-id=\"6f5d7680-1a11-4796-9cbd-ef0266c335e9\" data-created-at=\"2024-03-28T16:11:13.670Z\" data-loading=\"true\" data-media-id=\"N3MQZi8UtCmhWL\" data-created-by=\"GKiNm8uBxv5OHV\" \/><br \/>\nRepeat this steps for the rows (need to click CTRL + Shift + down Arrow key instead)<br \/>\n<img decoding=\"async\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror6.png\" alt=\"image\" data-type=\"image\" data-alignment=\"center\" data-meta=\"{&quot;size&quot;:167937,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;0caa059b-4be2-4523-9aa0-439affeee0b9&quot;,&quot;dimensions&quot;:[1600,921]}\" data-width=\"528px\" data-height=\"303px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/5d4e201d-934f-4712-9bab-9310765e97e2\/image\" data-id=\"0caa059b-4be2-4523-9aa0-439affeee0b9\" data-created-at=\"2024-03-28T16:11:21.530Z\" data-loading=\"true\" data-media-id=\"qth4xD-jgRJlG8\" data-created-by=\"GKiNm8uBxv5OHV\" \/><\/li>\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">Copy just the cells that contain your data set into a new file<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror7.png\" alt=\"image\" width=\"540\" height=\"157\" data-type=\"image\" data-alignment=\"center\" data-meta=\"{&quot;size&quot;:25309,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;60714afe-1612-4dc0-a9b8-98844725f9b1&quot;,&quot;dimensions&quot;:[778,226]}\" data-width=\"518px\" data-height=\"150px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/cba01590-71d6-4af4-98b7-3212dd7c9d65\/image\" data-id=\"60714afe-1612-4dc0-a9b8-98844725f9b1\" data-created-at=\"2024-03-28T16:11:08.921Z\" data-loading=\"true\" data-media-id=\"FGATgMl3uMDRHz\" data-created-by=\"GKiNm8uBxv5OHV\" \/><\/li>\n<\/ol>\n<\/li>\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">Remove any column\/s that are duplicated or rename the column to a unique name<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror8.png\" alt=\"image\" width=\"582\" height=\"150\" data-type=\"image\" data-alignment=\"center\" data-meta=\"{&quot;size&quot;:25861,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;cbf32828-ca7d-454d-9fef-b07d5381a84b&quot;,&quot;dimensions&quot;:[862,222]}\" data-width=\"574px\" data-height=\"148px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/00a9d5fa-bcfe-46e5-9926-c560013afe0d\/image\" data-id=\"cbf32828-ca7d-454d-9fef-b07d5381a84b\" data-created-at=\"2024-03-28T16:11:10.496Z\" data-loading=\"true\" data-media-id=\"D7RJZbujjkxHT7\" data-created-by=\"GKiNm8uBxv5OHV\" \/><\/li>\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">If you have CRM integration make sure there are no duplicates CRM IDs in your data set<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror9.png\" alt=\"image\" width=\"585\" height=\"139\" data-type=\"image\" data-alignment=\"center\" data-meta=\"{&quot;size&quot;:29331,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;ca9369ab-cb86-4515-8d37-9004f4601c84&quot;,&quot;dimensions&quot;:[901,214]}\" data-width=\"576px\" data-height=\"137px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/d09660d0-55d5-43b5-971d-93fdff1676e7\/image\" data-id=\"ca9369ab-cb86-4515-8d37-9004f4601c84\" data-created-at=\"2024-03-28T16:11:14.961Z\" data-loading=\"true\" data-media-id=\"Qlu6kG1aNK6QUG\" data-created-by=\"GKiNm8uBxv5OHV\" \/><\/li>\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">You can easily identify the duplicates by using Conditional Formatting, Highlight Cell Rules and select Duplicate Values function<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/cdn.stoneshot.com\/e\/stoneshot\/images\/learningsite\/importerror10.png\" alt=\"image\" width=\"1339\" height=\"456\" data-type=\"image\" data-alignment=\"center\" data-meta=\"{&quot;size&quot;:220591,&quot;type&quot;:&quot;image\/png&quot;,&quot;blockKey&quot;:&quot;72716872-2f75-472f-b384-0bd7d6408cbc&quot;,&quot;dimensions&quot;:[1600,545]}\" data-width=\"576px\" data-height=\"197px\" data-name=\"image\" data-note-id=\"8SfdEJrjq596JP\" data-url=\"https:\/\/storage.googleapis.com\/slite-api-private-files-production\/files\/H0tQZosVZ33aUK\/a5d91928-be56-48ba-9bbe-09662d020273\/image\" data-id=\"72716872-2f75-472f-b384-0bd7d6408cbc\" data-created-at=\"2024-03-28T16:11:21.950Z\" data-loading=\"true\" data-media-id=\"s8N74A7o4f3awK\" data-created-by=\"GKiNm8uBxv5OHV\" \/><\/li>\n<li data-id=\"bd5fd755-2e1c-44c4-8438-ea9faebfa0bf\">Make sure the file is saved as a .csv file.<\/li>\n<\/ol>\n<p data-type=\"unstyled\" data-id=\"29800372-2892-4cee-82c2-ccb7222e6e8b\">If this does not work, please get in touch with the <a href=\"mailto:support@stoneshot.com\" data-type=\"LINK\" data-entity-id=\"62f1e5c7-4cfd-4c14-94ce-333b4772464e\" data-url=\"mailto:support@stoneshot.com\" data-id=\"d44e9889-042c-4ba7-9a0c-675bf27209d1\">support team<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Importing using a CSV Importing from Salesforce Our Importer is a simple tool enabling you to push contact data into StoneShot. Importing is a two-stage process. After selecting your contact list, the importer verifies the integrity of your data then offers a set of import options, and works work with the Comma Separated Value (CSV) [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[60],"tags":[],"class_list":["post-11610","post","type-post","status-publish","format-standard","hentry","category-contacts-lists"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.2 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Importing - The Learning Site<\/title>\n<meta name=\"description\" content=\"Our Importer is a simple tool enabling you to import contacts to the StoneShot Platform by either using a CSV or directly from Salesforce.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing\" \/>\n<meta property=\"og:description\" content=\"Our Importer is a simple tool enabling you to import contacts to the StoneShot Platform by either using a CSV or directly from Salesforce.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/\" \/>\n<meta property=\"og:site_name\" content=\"The Learning Site\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-24T14:55:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-15T16:13:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c\/swatch\" \/>\n<meta name=\"author\" content=\"Michael Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@StoneShot\" \/>\n<meta name=\"twitter:site\" content=\"@StoneShot\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/\"},\"author\":{\"name\":\"Michael Wilson\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#\\\/schema\\\/person\\\/e6f45a9f88188f23f8585e9f047b4487\"},\"headline\":\"Importing\",\"datePublished\":\"2022-10-24T14:55:19+00:00\",\"dateModified\":\"2024-10-15T16:13:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/\"},\"wordCount\":1294,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/fast.wistia.com\\\/embed\\\/medias\\\/ujkyhf370c\\\/swatch\",\"articleSection\":[\"Contacts Lists\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/\",\"url\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/\",\"name\":\"Importing - The Learning Site\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/fast.wistia.com\\\/embed\\\/medias\\\/ujkyhf370c\\\/swatch\",\"datePublished\":\"2022-10-24T14:55:19+00:00\",\"dateModified\":\"2024-10-15T16:13:07+00:00\",\"description\":\"Our Importer is a simple tool enabling you to import contacts to the StoneShot Platform by either using a CSV or directly from Salesforce.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#primaryimage\",\"url\":\"https:\\\/\\\/fast.wistia.com\\\/embed\\\/medias\\\/ujkyhf370c\\\/swatch\",\"contentUrl\":\"https:\\\/\\\/fast.wistia.com\\\/embed\\\/medias\\\/ujkyhf370c\\\/swatch\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/contacts-lists\\\/importing\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Contacts Lists\",\"item\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/category\\\/contacts-lists\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Importing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#website\",\"url\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/\",\"name\":\"StoneShot Learning\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#organization\",\"name\":\"The Learning Site\",\"url\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/mob-logo.svg\",\"contentUrl\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/mob-logo.svg\",\"width\":32,\"height\":32,\"caption\":\"The Learning Site\"},\"image\":{\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/StoneShot\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/#\\\/schema\\\/person\\\/e6f45a9f88188f23f8585e9f047b4487\",\"name\":\"Michael Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a0a1a681ba80509dbef7bd0b3ae5afa4b5f3e4b5966fea0d045f58fc3791bea?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a0a1a681ba80509dbef7bd0b3ae5afa4b5f3e4b5966fea0d045f58fc3791bea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a0a1a681ba80509dbef7bd0b3ae5afa4b5f3e4b5966fea0d045f58fc3791bea?s=96&d=mm&r=g\",\"caption\":\"Michael Wilson\"},\"url\":\"https:\\\/\\\/www.stoneshot.com\\\/learn\\\/author\\\/michael-wilsonstoneshot-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Importing - The Learning Site","description":"Our Importer is a simple tool enabling you to import contacts to the StoneShot Platform by either using a CSV or directly from Salesforce.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/","og_locale":"en_GB","og_type":"article","og_title":"Importing","og_description":"Our Importer is a simple tool enabling you to import contacts to the StoneShot Platform by either using a CSV or directly from Salesforce.","og_url":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/","og_site_name":"The Learning Site","article_published_time":"2022-10-24T14:55:19+00:00","article_modified_time":"2024-10-15T16:13:07+00:00","og_image":[{"url":"https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c\/swatch","type":"","width":"","height":""}],"author":"Michael Wilson","twitter_card":"summary_large_image","twitter_creator":"@StoneShot","twitter_site":"@StoneShot","twitter_misc":{"Written by":"Michael Wilson","Estimated reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#article","isPartOf":{"@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/"},"author":{"name":"Michael Wilson","@id":"https:\/\/www.stoneshot.com\/learn\/#\/schema\/person\/e6f45a9f88188f23f8585e9f047b4487"},"headline":"Importing","datePublished":"2022-10-24T14:55:19+00:00","dateModified":"2024-10-15T16:13:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/"},"wordCount":1294,"commentCount":0,"publisher":{"@id":"https:\/\/www.stoneshot.com\/learn\/#organization"},"image":{"@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#primaryimage"},"thumbnailUrl":"https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c\/swatch","articleSection":["Contacts Lists"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/","url":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/","name":"Importing - The Learning Site","isPartOf":{"@id":"https:\/\/www.stoneshot.com\/learn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#primaryimage"},"image":{"@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#primaryimage"},"thumbnailUrl":"https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c\/swatch","datePublished":"2022-10-24T14:55:19+00:00","dateModified":"2024-10-15T16:13:07+00:00","description":"Our Importer is a simple tool enabling you to import contacts to the StoneShot Platform by either using a CSV or directly from Salesforce.","breadcrumb":{"@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#primaryimage","url":"https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c\/swatch","contentUrl":"https:\/\/fast.wistia.com\/embed\/medias\/ujkyhf370c\/swatch"},{"@type":"BreadcrumbList","@id":"https:\/\/www.stoneshot.com\/learn\/contacts-lists\/importing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stoneshot.com\/learn\/"},{"@type":"ListItem","position":2,"name":"Contacts Lists","item":"https:\/\/www.stoneshot.com\/learn\/category\/contacts-lists\/"},{"@type":"ListItem","position":3,"name":"Importing"}]},{"@type":"WebSite","@id":"https:\/\/www.stoneshot.com\/learn\/#website","url":"https:\/\/www.stoneshot.com\/learn\/","name":"StoneShot Learning","description":"","publisher":{"@id":"https:\/\/www.stoneshot.com\/learn\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stoneshot.com\/learn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.stoneshot.com\/learn\/#organization","name":"The Learning Site","url":"https:\/\/www.stoneshot.com\/learn\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.stoneshot.com\/learn\/#\/schema\/logo\/image\/","url":"https:\/\/www.stoneshot.com\/learn\/wp-content\/uploads\/2022\/10\/mob-logo.svg","contentUrl":"https:\/\/www.stoneshot.com\/learn\/wp-content\/uploads\/2022\/10\/mob-logo.svg","width":32,"height":32,"caption":"The Learning Site"},"image":{"@id":"https:\/\/www.stoneshot.com\/learn\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/StoneShot"]},{"@type":"Person","@id":"https:\/\/www.stoneshot.com\/learn\/#\/schema\/person\/e6f45a9f88188f23f8585e9f047b4487","name":"Michael Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/0a0a1a681ba80509dbef7bd0b3ae5afa4b5f3e4b5966fea0d045f58fc3791bea?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a0a1a681ba80509dbef7bd0b3ae5afa4b5f3e4b5966fea0d045f58fc3791bea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a0a1a681ba80509dbef7bd0b3ae5afa4b5f3e4b5966fea0d045f58fc3791bea?s=96&d=mm&r=g","caption":"Michael Wilson"},"url":"https:\/\/www.stoneshot.com\/learn\/author\/michael-wilsonstoneshot-com\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/posts\/11610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/comments?post=11610"}],"version-history":[{"count":26,"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/posts\/11610\/revisions"}],"predecessor-version":[{"id":14523,"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/posts\/11610\/revisions\/14523"}],"wp:attachment":[{"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/media?parent=11610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/categories?post=11610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stoneshot.com\/learn\/wp-json\/wp\/v2\/tags?post=11610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}