Announcing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet

Announcing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet


We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant.

 

Refer across spreadsheets

You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input.

 

 

Once you allow access to the source spreadsheet, the data will get filled in the formula cell and spill into the adjacent cells based on the cell range imported. The data gets updated automatically whenever there's a change in the source sheet—no need for manual refreshing or recalculation!

 

Manage linked spreadsheets

You can also track and manage all the spreadsheets linked to the current spreadsheet file. If you delete a linked spreadsheet, the related formulas will return an error.

  

Who can access

Everyone with access to the spreadsheet containing the formula in question can view the populated data. Those with edit permission can also use the formula to bring in data from the linked spreadsheet. This is permitted as long as the spreadsheet remains linked or the person who created the link has access to the source spreadsheet. Additionally, people with edit access can also link spreadsheets they have access to. 


To learn more about IMPORTRANGE and cross-spreadsheet linking, click here.

 

We hope you enjoy these new features! Try them out and give us your feedback in the comments below. 

 

Join the  Zoho Sheet community and stay updated on the latest features, interact with fellow users, and the team behind Zoho Sheet. 




    • Sticky Posts

    • Publish spreadsheets, sheets, or ranges with specific customizations

      Publishing a spreadsheet allows you to share your reports or data with a wider audience. To expand the publishing capabilities for your spreadsheet, we've revamped the publish controls in Zoho Sheet.   New look, extensive options With the new publish
    • Conditional Formatting Enhancements

      We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns falls
    • One cell, multiple formats, unlimited possibilities.

      Spreadsheet formats are more than an aesthetic choice. Proper formatting helps audiences understand your spreadsheet better. Zoho Sheet now allows you to format different parts of your content in cells however you want. What can you do with the new formatting
    • Refine by Zia: a smart way to improve data quality

      Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,
    • Webinar: Learn how to instantly clean your spreadsheet data

      Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration.  ​ In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid of