Import Media Lists
You can now bulk upload contacts into new or existing Media Lists directly via CSV or XLSX. Once uploaded, you’ll see a summary screen with import results (database matches, custom contacts created, duplicates, errors) and receive an email confirmation.
Download Our Media List Template
Use our template to quickly and accurately upload your contacts to a media list.
Formatting Tips to ensure success:
Include 1 email address per row.
Column names must be titled "email", "first_name", "last_name"
"Country" columns must include a 2- or 3-letter ISO country code.
Upload up to 500 contacts.
Guide to Import Columns
This table provides guidance for each of the available headers that can be included in a Media List Import file.
Header for Importing | Additional Instructions |
Remove all erroneous symbols or words from email addresses so that only the email exists.
Ex: jane@nytimes.com/ or <jane@nytimes.com> would not import.
If a person does not have an email address, delete any text (e.g. “No email listed” or “N/A”) so the row is left blank.
Replace any curly apostrophes with straight apostrophes.
If a person has more than one email listed, split it into a new row with all the other information being the same. This is typically used for personal emails. | |
email_type | This should include a number value (1 or 2) based on the following types:
1 - Work 2 - Personal
|
first_name | If journalists have middle names, they should be moved to the first name column. |
last_name | If not a human (outlet contact or general news contact etc), leave the first_name field blank and add the media outlet name under this column. |
relationship_owner | This header allows you to import relationship owners from your organization to matching journalists. It should include the email of an active user who is under the same organization.
Note that multiple relationship owners can exist on single journalist profiles. |
media_list_note | This header allows you to import media list notes that will be unique to the specific list. |
address | The first line of the mailing address
NOTE: If the |
address2 | The second line of the mailing address |
city | The city from the mailing address |
state | The state/province from the mailing address. The field is free text so it can be abbreviated (two letters) or spelled out.
Ex: NY or New York |
zip_code | The zip/postal code from the mailing address |
country | the 2- or 3-letter ISO value belonging to the country from the mailing address.
For Example, 'USA' for United States of America. |
address_type | This should include a number value (1 or 2) based on the following types:
1 - Work 2 - Personal |
Import a Media List
Import a Media List via the Media List table view or from within an existing Media List.
Select Create New > Media List from Import in the Media list table view.
Select Add Contact > Contacts from Import within an existing Media List.
The import dialog should appear. Input your Media List name and choose your preferred method for uploading your Media List: either drag and drop your CSV or XLS file, or select via the File Uploader.
NOTE: If uploading directly from within an existing Media List, the name of that list will auto-populate in this field.
Once the import is completed, you’ll see a summary screen with your import results. This information will also be emailed to you.
NOTE: You may need to refresh your list if you do not immediately see any entries.
NOTE: If there are any errors in your Media List (eg: wrong file format, incorrect # of columns, etc), you will see an error message in your results summary.
Any contacts without a match in the Muck Rack database will be added as a Custom Contact.
Frequently Asked Questions (FAQs)
Question | Answer |
Can I import Newsdesk emails? | Newsdesk emails can only be imported as custom contacts using the Media List Importer. |
What if my contacts are not found in the Muck Rack database? | If any of your contacts don't match existing profiles or don't meet our criteria to be added to the main database, they will be added as Custom Contacts for your team.
Custom contacts are owned solely by your organization and will not be maintained by Muck Rack's Editors. |
Are there any limits to the number of uploads I can perform? | No. You can import as many media lists as needed. |
Are there any limits to the number of rows that each upload can contain? | There are no limits; however, we recommend staying between 300 to 500 rows for best performance. |
What if our team only has the first and last names of journalists included in an import, but no email addresses? | Any contacts without emails will trigger an error code in your import results. Those contacts will not be added to your Media List. |
Can I assign or create folders during the import process? | Not at this time. |
Related Articles
Get Help
For additional help, contact support by choosing the chat icon in the bottom right-hand corner of the screen and selecting Messages > Send us a message.
💬 Was this article helpful?
Share your feedback and let us know how to improve our Help Center content.