By default, Sheetgo only transfers raw data from the source sheet to the destination sheet. This ensures your data is transferred as quickly as possible. However, you can turn on transfer formatting to carry over formatting from the source.
Note:
Transfer formatting doubles the processing time required to transfer your data. It's not recommended for large source or destination spreadsheets.
Transfer formatting doubles the number of transfers consumed by a normal automation.
What does it do?
When you turn on transfer formatting, Sheetgo will bring all numbers, date-related, and cell styles to your destination sheet.
This includes:
Date and time formatting.
Number formatting.
Currencies.
Percentages and decimals.
Column and row dimensions: width, height, and alignment.
Merged cells.
Frozen Rows.
Hidden Rows.
Padding.
Cell background colors.
Text color.
Font size.
Supported uses of transfer formatting
Google Sheets stored in Google Drive
Excel files stored in OneDrive or in SharePoint.
Single connections (one source file to one destination file).
Append connections.
Limitations of transfer formatting
The source and destination files must be stored in the same cloud storage. For example, formatting cannot be transferred from a Google Drive file to a OneDrive file.
Some data processors can't be combined with transfer formatting:
Filter by condition, column, or query.
Merge or left join data transformations.
You cannot combine transfer formatting and Split data to multiple destination files.
Formatting applied to part of a cell, such as "bold in the middle," cannot be transferred.
For Excel files, cell color, and text formatting cannot be transferred.
Apply transfer formatting to a new automation
Open Sheetgo.
Select New workflow, and click Create an automation.
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.
Add transfer formatting to an existing automation
Go to Sheetgo.
Open the workflow containing the automation.
Find the automation on the side panel.
Click the three dots (⋮) next to it and select Edit.
Under Source, turn on Transfer Formatting.
Click Save connection.
Tip: If your source file is an Excel file converted to Google Sheets, we recommend you reapply formatting if it's not being transferred correctly.
Troubleshooting transfer formatting
If the format doesn't transfer, try reapplying the formatting to the source sheet and run the automation.
If formatting is displayed in the wrong places, check if any filters are enabled in your spreadsheet, and remove them before updating the automation.
If the transferred formatting is wrong or only partially reproduced, try creating a new connection.
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.