By default, Sheetgo only transfers the raw data from the source spreadsheet into the destination spreadsheet. This behavior is done to keep data transfer as fast as possible.

Steps to enable Transfer of Format

  1. Click on create connection
  2. Select your data source
  3. Select your data destination
  4. On settings select the check box Enable transfer formatting
  5. Save your connection

Please note: Formatting transfer will double the time required to transfer data and it's not advisable if the source or destination spreadsheet is heavy.

The following attributes can be transferred from a Google Sheet to another Google Sheet (not Excel, not CSV!) using Connect and Append (not Consolidate, not Filter/Query!).

  • Font Color 
  • Font Size
  • Merged Cells
  • Frozen Rows
  • Hidden Rows
  • Alignment
  • Padding
  • Borders
  • Background color 
  • Date format 
  • Number Currency
Did this answer your question?