My advice for keyword research is too not just factor on exact match and broad match, you need to factor in other forms of research to supplement your data.
You need to remember this data is only a guide from Google Exact match data is in no way an accurate determination of what traffic the specific keyword gets.
MY advice it the following -
Split up excel into the following:
1. line Exact 1. line Broad 1. line other research 1. line competitive analysis for the term.
You need to pull information from various sources, do not rely only on Google.
Kind Regards,
James Norquay.