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.

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
New Toolbar in Zoho Sheet
We have revamped our toolbar design in this new version of Zoho Sheet. Below are some screenshots to help you get accustomed to this new interface. Click on the picture below to view the animated image in its original size. Scroll down this post to learn about the changes. Highlight of Changes: The previous format tab is now split into 2 tabs - Home and Format. The Home tab contains the commonly used functions and the Format tab holds formatting related options. Under the Home tab towards the far
Check out the new Checkbox in Zoho Sheet
Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format
Introducing 15 new Zoho Sheet functions
Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text
Introducing Forms in Zoho Sheet
We hereby bring you the power of forms in Zoho Sheet. Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
Collaborative spreadsheets on your smartphone.
Waiting till you're at your laptop to get your work done is a thing of the past. Stay on track with the mobile world with the Zoho Sheet app for iPhone, iPad, and Android devices—watch the video. Now you can: View and access all your spreadsheets—both owned and shared. Perform calculations in a snap with more than 350 functions. Visualize data with charts and conditional formats. Share and collaborate in real time with your team. Distribute files with shareable links. Insert hyperlinks, checkboxes,