<p>I know that this should be easy but how do I export/save a DataGridView to excel?</p>

Does it need to be a native XLS file? Your best bet is probably just to export the data to a CSV file, which is plain text and reasonably easy to generate. CSVs open in Excel by default for most users so they won't know the difference.