diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


Import/Export and Paste Special Features Added to Google Spreadsheets

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.

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...