By default, Sheetgo only transfers raw data from the source sheet to the destination sheet. This ensures that your data is transferred as quickly as possible. There is a setting that enables you to transfer different formatting elements: number formatting, cell style, and text formatting.
What does this feature do?
When you enable this setting, Sheetgo will transfer all numbers, date-related, and cell styles formatting from your source sheet to your destination sheet. This includes
Date and time formatting.
Number formatting.
Currencies.
Percentages and decimals.
The dimensions of the columns and rows, including width, height, and alignment.
Merged cells.
Frozen Rows.
Hidden Rows.
Padding.
Cell background colors.
Text color.
Font size.
Transfer formatting is available for:
Google Sheets
Single connections (one source file to one destination file)
Append connections
Please note that:
Your source and destination files must be stored on the same cloud storage platform. Currently, formatting cannot be transferred from a file in Google Drive to a file in OneDrive/SharePoint or vice versa.
If you are using a Filter on the connection, it is not possible to transfer number formatting.
To import date formatting from Excel and CSV files, use the Date Format setting when you select your source data.
If the formatting is only applied to part of the cell, such as "bold in the middle", it will not be transferred.
Cell color and text formatting transfer are not available for Excel files.
How to do transfer formatting when creating a new connection?
Open Sheetgo. Select New workflow, and click start connecting.
Under Select source, choose the correct file and file tab.
Enable the Transfer Formatting option.
Click Continue to save the settings before selecting a destination file.
Click Finish and save to create the connection.
How to do transfer formatting on an existing connection?
Open Sheetgo.
Click on the three dots (⋮) next to the connection and select Edit.
Under Source, enable Transfer Formatting.
Click Save connection.
Tip: If your source file is an Excel file that has been converted to Google Sheets, we recommend you reapply the formatting if it is not being transferred correctly.
Solving common issues
If your formatting is not transferred, try reapplying the formatting to the source sheet and updating the connection again.
If you are seeing formatting displayed in the wrong places, edit the connection to check if there are any filters enabled in your spreadsheet, and disable them before updating the connection again.
If the formatting is wrong or only partially transferred, try creating a new connection.
Important:
Transferring formatting will double the time required to transfer your data. It is not recommended for large source or destination spreadsheets.
Transfer formatting also consumes double the amount of transfers than a normal connection.
Transfer formatting will not work when you apply filter by condition and query filter.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.