1. In sheet 2, "Dataset 1," take a few minutes to organize your spreadsheet for the analysis;
2. Add Filters to Row 1 using Data > Filter
3. Select the dropdown in Column A (Keyword), click 'Select All' to deselect all, and then click the checkbox for (not provided)
4. Delete all of these rows (not provided) OR take some time to deal with them.
5. Click the dropdown in column A once more and select "Clear filter from "Keyword"
6. Delete columns E (Avg. Visit Duration) and F (% New Visits).
7. Create a new column C (to the left of the existing column C) titled Potential Visits.
8. Create a new column E (to the left of the existing column E) titled Performance.

At this point it should look like this:

If it does you're on the right track - save yourself some potential frustration and click save.

Now we need to go out and get all of the search volume data for your keywords, so fire up the Google Keyword Planner and copy and paste your list in the same order into the tool, be selecting all of the cells in Column A, take note of the count of keyword you are bringing into the keyword tool - since you removed your (not provided) data the count will no longer be 500.

Note: Make sure you change the match type from the default broad match to [exact] match to give you a better handle on the search potential within your geographic area.

Now export using the 'download' button at Download > All Search Results > CSV for Excel.