Automatic insights for spreadsheets

Automatically identifying insights from a dataset and presenting the insights graphically and in natural language text ranked by importance is provided. Different data types and structures in the dataset are automatic recognized and matched with a corresponding specific analysis type. The data is analyzed according to the determined corresponding analysis types, and insights from the analysis are automatically identified. The insights within a given insight type and between insight types are ranked and presented in order of importance in automatically generate charts that visually describe each insight and in natural language text that describes each insight in such a way that it may be understandable to a general audience who may not have a familiarity with statistics.