Automatic semantic data enrichment in a spreadsheet

A computer-readable medium storing computer-executable instructions for automatically populating a spreadsheet, comprising:

• detecting existing data items entered by a user into a base column and a target column of the spreadsheet;
• determining a semantic relationship between at least one existing data item of the base column and at least one existing data item of the target column of the spreadsheet;
• determining at least one new data item to add to the target column of the spreadsheet based on the determined semantic relationship, wherein the determined at least one new data item has semantic relationship with another existing data item of the base column that is the same as the semantic relationship between the at least one existing data item of the base column and the at least one existing data item of the target column;
• and
• populating the target column with the at least one new data item.

A system for improving efficiency in populating a spreadsheet with data, comprising:

• a processor and memory;
• an operating environment executing using the processor;
• and
• a change manager that is configured to perform actions comprising:
• displaying a spreadsheet having a grid of rows and columns;
• detecting existing data items entered by the user into one or more base columns and one or more target columns of the spreadsheet;
• determining at least one semantic relationship between at least one existing data item of the base column and at least one existing data item of the target column of the spreadsheet, wherein the at least one existing data item of the target column is either a column header or an existing data item of at least one cell of the target column;
• determining at least one new data item to add to the target column of the spreadsheet based on the determined semantic relationship, wherein the determined at least one new data item has a semantic relationship with another existing data item of the base column that is the same as the semantic relationship between the at least one existing data item of the base column and the at least one existing data item of the target column;
• suggesting the at least one new data item to the user;
• and
• receiving an indication from the user to enter the at least one new data item into the target column of the spreadsheet.

A method for improving efficiency in populating a spreadsheet with data, comprising:

• detecting existing data items having been entered by one or more users into a base column and having been entered into at least one cell of a target column and a column header of the target column;
• determining a semantic relationship between at least one existing data item of the base column and the existing data item of the at least one cell of the target column and another semantic relationship between the at least one existing data item of the base column and the column header;
• determining at least one new data item to add to the target area of the spreadsheet based on the determined semantic relationships, wherein the determined at least one new data item has a semantic relationship with another existing data item of the base column that is the same as:
• the semantic relationship between the at least one existing data item of the base column and the at least one existing data item of the at least one cell of the target column;
• or
• the semantic relationship between the at least one existing data item of the base column and the column header of the target column;
• and
• populating the target area with the at least one new data item.

A method for improving efficiency in populating a spreadsheet with data, comprising:

• detecting existing data items having been entered by a user into a base column and a target column of the spreadsheet;
• suggesting at least one semantic relationship that exists between the base column and the target column, the at least one semantic relationship based on at least one existing data item of the base column and at least one existing data item of the target column;
• and
• receiving a selection of at least one suggested semantic relationship;
• and
• populating a target column with at least one new data item based on the selected at least one semantic relationship, wherein the at least one new data item has a semantic relationship with another existing data item of the base column that is the same as the selected semantic relationship.