Import formatting with IMPORTRANGE in Google Sheets

The importance of preserving formatting Preserving the formatting upon an import of data is important: It helps other users contextualise the data; It helps emphasise and differentiate data (e.g. with the use of font weights and colours); It helps understand … Read More

Import Range vs Import Sheet: Which is better?

Import Range vs Import Sheet: What is the best way to connect spreadsheets? In the table below we’ve created a comparison of the of the functionality of Import Range vs Import Sheet to to help you discover which is a better … Read More

Import Range: how do I use it? Instructions and tips

Google Sheets’ Import Range function is the only way, using Sheets’ built in functionality to integrate data between spreadsheets. It’s an easy formula to use for a person that experienced with spreadsheets, but it can cause confusion for those without. … Read More