Datagrabber is an Excel based tool which uses APIs to communicate with SEMRUSH (keyword and ranking data) and Majestic (link data from sites). It pulls the data directly into Excel and generates a spreadsheet where you can manipulate the data. You can query, slice, dice and export data in unique ways and easily aggregate large numbers of sites or pages. Datagrabber also scrapes Google and has a feature called Share of Search that gives you a very concise overview on who is ranking for what keyword amongst a particular keyword group.
Microsoft Office Excel