How to Import Your Media List into Microsoft Excel

So you've just purchased a media list, and now you're ready to dive into the world of media outreach! But before you start reaching out to journalists and editors, you'll need to import your new Media List Market media list into Microsoft Excel for easy organization and analysis.

For those who prefer Google Sheets or Apple Numbers, we have comprehensive tutorials on how to import your media list into these platforms. Check out our guides here: Importing to Google Sheets | Importing to Apple Numbers.

Importing Your Media List into Microsoft Excel

Once you've purchased your media list, you can download a CSV or XLS file from Media List Market. [Instructions on How to Download Your Media List]

Either file type can be downloaded into Microsoft Excel, and you can review the benefits of each file type in this blog post.

With your brand new media list, it's time to import your download into Microsoft Excel. Here's how:

1. Open Excel: First, launch Microsoft Excel on your computer. If you don't have Excel installed, you can use alternative spreadsheet software like Google Sheets or Apple Numbers.
2. Import Data: Once Excel is open, go to the "Data" tab on the top Excel ribbon. Depending on your version of Excel, you may need to select either "Get Data" or "From Text/CSV" to initiate their import process.
3. Select File: Next, choose the downloaded CSV or XLS file from Media List Market on your computer. This is the file containing your media list data. Once selected, click "Import" to proceed.
4. Set Delimiter: If prompted, specify the delimiter used in your CSV file. Our CSV files use comma as the delimiter. After setting the delimiter, click "Next" to continue.
5. Preview Data: Before finalizing the import, Excel will display a preview of your data. Take a moment to review the preview and ensure that the data is formatted correctly and all the relevant data fields are aligned properly. Once you've confirmed this, click "Load" to import the data into Excel.

Congratulations! You've successfully imported your media list into Microsoft Excel.

Now that your data is organized in a spreadsheet, you can begin exploring and analyzing it to map out your next PR campaign.

Additional Tips and Tricks

Microsoft Excel offers a robust set of tools to explore and manage your new media list. Let's dive in and explore a few ways you can optimize your Excel workflow for your media outreach.

• Formatting: Once your media list is imported into Excel, take advantage of Excel's formatting options to make the data more visually appealing and easier to work with. You can customize fonts, colors, cell styles, and more to suit your preferences.
• Data Analysis: Excel offers a range of powerful data analysis tools that you can use to gain insights from your media list. From sorting and filtering to creating pivot tables and charts, Excel allows you to analyze your data in-depth and identify trends and patterns within your media contacts.
• Integration with Other Tools: Excel seamlessly integrates with other tools and software, making it easy to incorporate your media list data into your existing workflows. Whether you're using a CRM system, email marketing platform, or project management tool, Excel provides flexibility and compatibility to bring your new media contacts into your existing processes.

Organizing Your Media List with Data Sort

With your media list imported into Excel, you can use the Data Sort feature to organize the data by various data fields such as location, domain authority (DA), or unique visitors per month (UVPM).

Sorting your media list allows you to prioritize contacts based on their relevance and influence, making it easier to target your outreach efforts and PR objectives effectively.

• Sorting by Location: Sorting your media list by location allows you to target journalists and influencers based on their geographical proximity to your target audience. This can be particularly useful for local PR campaigns or events.
• Domain Authority (DA): Domain authority is a measure of a website's credibility and influence in the online space. When conducting an SEO backlinks strategy or finding media outlets that are attainable for the current stage of your business, sorting your media list by domain authority helps you identify and prioritize the best opportunities for your brand.
• UVPM: UVPM (Unique Visitors Per Month) is a metric that indicates the popularity and reach of a website. Sorting your media list by UVPM allows you to identify contacts from websites with a larger audience, maximizing the impact of your media outreach efforts.

Here's how to organize your media list with Microsoft Excel's Data Sort tool:

1. Select Data Range: Click on the cell containing the header of the column you want to sort by. This could be the "Zip Code," "DA," or "UVPM" column, for example. Then drag your mouse to select the entire column.
2. Access Data Sort: Navigate to the "Data" tab on the Excel ribbon. Locate the "Sort & Filter" group and click on the "Sort A to Z" or Sort "Z to A" button, depending on whether you want to sort the data in ascending or descending order. Alternately, you can click on the "Sort" button and choose "Custom Sort" for more sorting options.
3. Customize Sorting Options (Optional): If you clicked on "Custom Sort," a dialog box will appear where you can customize your sorting options. Here, you can specify multiple levels of sorting, choose whether to sort by values or cell color, and more. Once you've configured your sorting options, click "OK" to proceed.
4. Confirm Sort: Excel will apply the selected sorting options to your data range. Review the sorted data to ensure it's organized according to your preferences.
5. Repeat for Additional Columns (Optional): If you want to organize your media list by multiple criteria (e.g., sorting by location first, then by domain authority), repeat steps 1 to 4 for each additional column you want to sort by. Excel will apply the sorting criteria in the order you specify.
6. Save Changes: Once you're satisfied with the organization of your media list, save your Excel spreadsheet to preserve the changes.

Explore More Technical Tutorials and PR Guides:

Ready to take your media outreach to the next level?

Check out more technical tutorials and PR guides on the Media List Market blog. From advanced data analysis techniques and AI integrations, to expert PR strategies, our blog has everything you need to succeed in your upcoming PR campaigns.

Happy exploring!

Have another technical question not covered here? Reach out to our Customer Support team for additional assistance.