Thursday, September 23, 2010

More Options for Importing Files into Google Spreadsheets

Google Spreadsheets improved the feature that lets you to import the 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 the multiple delimiters, exclude certain columns or pick the data format before importing the file. These features are available in the 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