Google Spreadsheets improved the feature that lets you import files. After uploading a file, you can preview it, select a separator character and choose where to put the data. You can create a new spreadsheet, insert a new sheet, replace the spreadsheet or only the current sheet, append the data to the current sheet or replace the data starting from the selected cell.
You can't select multiple delimiters, exclude certain columns or pick the data format before importing the file. These features are available in Microsoft Excel and, even though some them aren't necessary, they make it easier to properly import the data you need.
No comments:
Post a Comment