Copiar formatação no Planilhas Google com a fórmula IMPORTRANGE

A well-formatted spreadsheet isn’t just about looks—it’s about clarity, efficiency, and better decision-making. Whether you’re tracking budgets, inventory, or customer data, the right formatting ensures key insights don’t get lost in a sea of numbers.

Use different fonts or cell colors to separate data sets, highlight data with tables and borders, or optimize it with number formatting like percentages or currency.  Proper formatting is key to craft sheets that are easy to navigate.

What happens when we manually transfer this data to another file? We lose this beautifully organized formatting. Furthermore, manually transferring this data wastes precious time, and can also increase human errors.

So how can we automatically transfer data along with formatting in Google Sheets? Both IMPORTRANGE and the workspace automation tool Sheetgo provide an answer – let’s compare both options.

What is the IMPORTRANGE function?

IMPORTRANGE is a widely used function that can import data from one Google Sheet file to another. Formulas in spreadsheets can be a little intimidating at first, but they are well worth the time. Learn how to use IMPORTRANGE with instructions and tips to use this tool effectively.

Despite its power, IMPORTRANGE is limited when it comes to maintaining formatting. It transfers raw data but not format options like weight, size, color, or background.

Let’s take a look at IMPORTRANGE’s copy formatting on actual imported data.

Figure 1: Example data – source sheet

Figure 2: Imported data using IMPORTRANGE

As you can see, IMPORTRANGE has successfully transferred all of the data formatting (such as currency and percentages number formatting), but has failed to maintain all of its visual formatting. Font weight, font size and cell color have been lost.

Overall, this function is a great option if you are confident with formulas and only need to transfer raw data. However, there is no way to IMPORTRANGE Google Sheets with formatting. If you are creating data sets that require a lot of visual formatting, then you need Sheetgo.

Copy Google Sheets specific ranges with format using Sheetgo

Sheetgo automatically transfers data between files using connections, you can choose specific ranges or you can even choose to carry over formatting. 

Unlike IMPORTRANGE, Sheetgo requires no technical expertise, allowing for quick and convenient data transfer. Additionally, Sheetgo can transfer font weight, size, color, and background with its copy formatting feature.

First, add the Sheetgo add-on to Google Sheets

Follow these instructions to use Sheetgo as Google Sheets add-on.

1. 1. In your Google Sheets, click Extensões
   2. Selecione Complementos
   3. Search for Sheetgo in the pop up
   4. Select the Sheetgo add on and click Instalar.

Or install the Sheetgo add-on directly from the Google Workspace Marketplace.

Once you have successfully installed the Sheetgo add-on in Google Sheets, you can use it anytime you need to transfer data.

How to use Sheetgo to transfer data with copy formatting

Let’s go through a step-by-step of how to use Sheetgo to transfer data with copy formatting:

1️⃣ Start on the spreadsheet with the data you would like to transfer. Make sure you name this file clearly to avoid confusion.

2️⃣ In the navigation menu, click Extensions and select the Sheetgo add-on. Press Start.

3️⃣ The Sheetgo add-on will appear as a sidebar on the right-hand side of your Google Sheets. To send this data to another spreadsheet click Selecionar dados under Export data.

4️⃣ Information on this file will come up. Under the File tab section, make sure you select the correct tab that has your data.

Optional: choose a specific range instead of the entire tab

Then press on Copy cell styles and values format

5️⃣ Now choose where to send your data. Because we want to send our data to another Google Sheet, click Planilhas Google.

Choose whether you want to export your data to a new or existing file. Make sure you provide a clear File name and choose your Destination folder. Once you are happy with the destination, press Concluir e salvar.

6️⃣ Your data is now connected. You should now have a new file with your exported data and copy formatting.

Unlike IMPORTRANGE, Sheetgo doesn’t just move raw data—it gives you full control over what and how you import. With IMPORTRANGE 2.0, you can now:
✅ Import specific data ranges instead of full sheets
✅ Transfer font weight, size, color, and background
✅ Automate updates without breaking formulas
✅ Maintain formatting for cleaner, professional-looking reports

▶️ Watch the video below and learn how to copy formatting in Google Sheets with the IMPORTRANGE formula.

Copy formatting with IMPORTRANGE

And there you have it! With Sheetgo, you can import any formatted data automatically between Google Sheets quickly and effectively, maintaining the original formatting.

Take a look at the following blog post for an in-depth comparison between the functionalities of Sheetgo and IMPORTRANGE