How to import your media contacts from a spreadsheet

Use our import tool to add contacts in bulk.

In order to add your contacts to Prowly from a spreadsheet file, go to the Contacts tab and:

  1.  Click the New Contact button located in the top-right corner

  2. Choose Import contacts from spreadsheet in the dropdown list:

  3. Select a file from your computer and click Upload.

Please note: The file you want to import should be prepared in such a way that individual types of data are accumulated in the same columns. The order of the columns does not matter. It's more important to locate all email addresses in one column.

These types of data can be imported to Prowly:

  • email
  • outlet
  • outlet URL
  • first name
  • last name
  • timezone
  • country
  • city
  • zip
  • address
  • greeting
  • role
  • language
  • tags - multiple tags can be added
  • phone number - multiple numbers can be added
  • Twitter link - multiple links can be added
  • Vimeo link - multiple links can be added
  • Facebook link - multiple links can be added
  • Linkedin link - multiple links can be added
  • Instagram link - multiple links can be added
  • Pinterest link - multiple links can be added
  • Youtube link - multiple links can be added
  • link - multiple links can be added, for example, website address, which will be displayed in the social media section in contact details card

Some data can be duplicated by either entering it into one column (and separating with a comma or semi-colon) or adding each phone number in a separate column. If you can add more than one item of the information to the a/m data type, it is marked with 'multiple can be added'. After uploading a file, you need to mark what you have in your columns by selecting the names for the Prowly column.

You can skip matching columns by using the Skip buttonJust remember that an e-mail address is required data - without this, you will not be able to import a file to Prowly. After you match columns, you can specify contacts with tags and implement them to existing lists or create new ones.

Now you need to fix potential errors in the imported file. The Correct invalid records button will help you do it. There are different types of errors, but you can see them all highlighted in red next to the invalid cell. Error sorts are:

  • Email already exists in your database - you tried to import a contact that was already uploaded to the database
  • Invalid email format - the email format is unacceptable, e.g. namesurname@
  • File is empty - there is simply no data to analyze
  • You need to set or skip each column - some data columns during the import process weren't configured or were omitted

    You do not have to upload the file again - you can correct errors by editing the table directly in Prowly. If you have a problem with uploading the database, remember that file needs to have a .xls or .csv format. When the database is ready, click on the Continue button.

    To make the process easier, we also prepared a database template. Download it here.