Google added two more new features to Spreadsheets, to help make analyzing data a little more efficient.
More import and export support in Google spreadsheets
“Now you can convert most pivot tables between Microsoft Excel files and Google spreadsheets for powerful data analysis in whatever file format you prefer. Additionally, filters that help you better visualize and organize your data are now supported in our import and export conversion tools,” informed Google.
“To import a pivot table you created in Microsoft Excel, click the File menu in Excel, and select import, then select the file from the import options, and click the import button. If you’ve created a pivot table in Google spreadsheets, go to File in the spreadsheet, then click Download As, and choose Excel,” explains Dan Gundrum, Product Manager.
More paste special options in Google spreadsheets
Google also added four new paste special options including: paste all cell contents except borders, formulas only, data validation only, or conditional formatting only.
You can find these new options in a list under “Paste Special” in the Edit menu of Google spreadsheets.