Data from web documents in a spreadsheet

• US 8,239,751 B1
• Filed: 05/16/2007
• Issued: 08/07/2012
• Est. Priority Date: 05/16/2007
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Rochelle, Jonathan, Lemonik, Micah G., Vespe, David J.
• Primary Examiner(s): Hong, Stephen
• Assistant Examiner(s): Hasty, Nicholas
• Application Number:
  US11/749,679
• Time in Patent Office: 1,910 Days
• Field of Search: 715/220, 715/212, 715/219, 709/203, 709/219, 707/10, 707/1, 707/100, 707/E17.032, 707/E11.204
• US Class Current: 715/220
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 40/247 Thesauruses; Synonyms

Abstract

A spreadsheet user interface accepts a request for at least one fact, the request comprising a user-selected identifier for the desired fact. Responsive to the entry of the request, a fact repository containing information derived from unstructured documents is accessed. The fact or facts corresponding to the request, if any, are retrieved from the repository, and the results are displayed at the location of the spreadsheet that is associated with the request.

Claims

1. A computer-implemented method for adding information to a spreadsheet, comprising:

on a client system having one or more processors and memory storing one or more programs to be executed by the one or more processors;

displaying a spreadsheet;

receiving a request to add a cell value to the spreadsheet, the request containing a reference to an object and an attribute;

generating a query corresponding to the request;

sending the query to a fact repository;

receiving the requested cell value from the fact repository, wherein the cell value correspond to a value of a fact, the fact being associated with an object in the fact repository, wherein a respective fact includes an attribute field indicating an attribute and a value field describing the indicated attributes, wherein objects in the fact repository are created by;

extracting facts from web documents;

determining entities with which the extracted facts are associated;

storing the extracted facts in the fact repository; and

associating the stored extracted facts with objects corresponding to the determined entities;

inserting the received cell value into the spreadsheet.

2. The method of claim 1, wherein the spreadsheet is a web spreadsheet page.

3. The method of claim 1, wherein the reference to the object and the attribute are each specified using one of a literal value and a spreadsheet cell reference.

4. The method of claim 1, wherein receiving the request to add the cell value comprises entering the request into a spreadsheet cell.

5. The method of claim 1, wherein receiving the request to add the cell value comprises applying a request corresponding to an existing spreadsheet cell to at least one other spreadsheet cell.

6. The method of claim 5, wherein applying the request to at least one other spreadsheet cell includes automatically adjusting cell references to correspond to the at least one other spreadsheet cell.

7. The method of claim 1, wherein receiving the request to add the cell value comprises specifying at least one of a data type and a data format for the received cell value, and wherein inserting the received cell value comprises displaying the received cell value according to the specified at least one of a data type and a data format.

8. The method of claim 1, wherein receiving the requested cell value further comprises receiving at least one of attribution data and confidence data associated with the requested cell value.

9. The method of claim 1, wherein inserting the received cell value comprises presenting a disambiguation interface to enable selection of a correct cell value from among a plurality of cell values.

10. A non-transitory computer readable storage medium storing one or more programs, the one or more programs comprising instructions, which when executed by a client system, cause the client system to perform a method comprising:

displaying a spreadsheet;

receiving a request to add a cell value to the spreadsheet, the request containing a reference to an object and an attribute;

generating a query corresponding to the request;

sending the query to a fact repository;

receiving the requested cell value from the fact repository, wherein the cell value correspond to a value of a fact, the fact being associated with an object in the fact repository, wherein a respective fact includes an attribute field indicating an attribute and a value field describing the indicated attributes, wherein objects in the fact repository are created by;

extracting facts from web documents;

determining entities with which the extracted facts are associated;

storing the extracted facts in the fact repository; and

associating the stored extracted facts with objects corresponding to the determined entities;

inserting the received cell value into the spreadsheet.

11. The non-transitory computer readable storage medium of claim 10, wherein the spreadsheet is a web spreadsheet page.

12. The non-transitory computer readable storage medium of claim 10, wherein the reference to the object and the attribute are each specified using one of a literal value and a spreadsheet cell reference.

13. The non-transitory computer readable storage medium of claim 10, wherein receiving the request to add the cell value comprises entering the request into a spreadsheet cell.

14. The non-transitory computer readable storage medium of claim 10, wherein receiving the request to add the cell value comprises applying a request corresponding to an existing spreadsheet cell to at least one other spreadsheet cell.

15. The non-transitory computer readable storage medium of claim 14, wherein applying the request to at least one other spreadsheet cell includes automatically adjusting cell references to correspond to the at least one other spreadsheet cell.

16. The non-transitory computer readable storage medium of claim 10, wherein receiving the request to add the cell value comprises specifying at least one of a data type and a data format for the received cell value, and wherein inserting the received cell value comprises displaying the received cell value according to the specified at least one of a data type and a data format.

17. The non-transitory computer readable storage medium of claim 10, wherein receiving the requested cell value further comprises receiving at least one of attribution data and confidence data associated with the requested cell value.

18. The non-transitory computer readable storage medium of claim 10, wherein inserting the received cell value comprises presenting a disambiguation interface to enable selection of a correct cell value from among a plurality of cell values.

19. A system for adding information to a spreadsheet, the system comprising:

one or more processors and memory storing one or more programs, the one or more programs comprising instructions for;

displaying a spreadsheet;

receiving a request to add a cell value to the spreadsheet, wherein the cell value corresponds to a value of a fact with an associated attribute, the fact being associated with an object in a fact repository that includes a plurality of facts extracted from web documents, the request containing a reference to the object and the associated an attribute;

generating a query corresponding to the request;

sending the query to a fact repository;

receiving the requested cell value from the fact repository, wherein the cell value corresponds to a value of a fact, the fact being associated with an object in the fact repository, wherein a respective fact includes an attribute field indicating an attribute and a value field describing the indicated attributes, wherein objects in the fact repository are created by;

extracting facts from web documents;

determining entities with which the extracted facts are associated;

storing the extracted facts in the fact repository; and

associating the stored extracted facts with objects corresponding to the determined entities;

inserting the received cell value into the spreadsheet.

20. The system of claim 19, wherein the spreadsheet is a web spreadsheet page.

21. The system of claim 19, wherein the reference to the object and the attribute are each specified using one of a literal value and a spreadsheet cell reference.

22. The system of claim 19, wherein receiving the request to add the cell value comprises entering the request into a spreadsheet cell.

23. The system of claim 19, wherein receiving the request to add the cell value comprises applying a request corresponding to an existing spreadsheet cell to at least one other spreadsheet cell.

24. The system of claim 23, wherein applying the request to at least one other spreadsheet cell includes automatically adjusting cell references to correspond to the at least one other spreadsheet cell.

25. The system of claim 19, wherein receiving the request to add the cell value comprises specifying at least one of a data type and a data format for the received cell value, and wherein inserting the received fact comprises displaying the received cell value according to the specified at least one of a data type and a data format.

26. The system of claim 19, wherein receiving the requested cell value further comprises receiving at least one of attribution data and confidence data associated with the requested cell value.

27. The system of claim 19, wherein inserting the received cell value comprises presenting a disambiguation interface to enable selection of a correct cell value from among a plurality of cell values.