Please note: formatting transfer is still experimental and may lead to unintended results.

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
  • Notes
  • Comments
  • Alignment
  • Padding
  • Borders
  • Background color 
  • Date format 
  • Number Currency

Did this answer your question?