CPC G06F 16/258 (2019.01) [G06F 16/2282 (2019.01); G06F 16/252 (2019.01); G06F 40/18 (2020.01)] | 20 Claims |
1. A method comprising:
receiving, by a computing device, a request to import a selection of a first data set, the first data set corresponding to a first portion of a first spreadsheet, to a destination portion of a second spreadsheet;
determining, by the computing device and based on analyzing the selection of the first data set, a first data profile corresponding to the first data set;
determining, by the computing device, a second data set corresponding to the destination portion of the second spreadsheet;
determining, by the computing device and based on analyzing the second data set, a second data profile corresponding to the second data set;
determining, by the computing device and based on comparing the first data profile with the second data profile, a confidence score;
determining, by the computing device and based on determining that the confidence score exceeds a first threshold, that the first data set and the second data set share a same data type;
determining, by the computing device and based on determining the same data type, to add the selection of the first data set to data entries of the destination portion of the second spreadsheet;
determining, by the computing device and based on determining the same data type, a first data entry format for the first data set;
determining, by the computing device and based on determining the same data type, a second data entry format for the second data set;
determining, by the computing device, a format discrepancy between the first data set and the second data set;
translating, by the computing device and based on determining the format discrepancy, the selection of the first data set to the second data entry format; and
adding, by the computing device and according to the second data entry format, the translated selection of the first data set to the destination portion of the second spreadsheet.
|