Skip to main content
Version: Streamsheets 3.0

GOOGLE.SHEETS.COLUMN.INSERT

Premium
Experimental

Insert or append columns to a sheet.

Syntax

=GOOGLE.SHEETS.COLUMN.INSERT(Spreadsheet-Id, Sheet-Id or Sheet-Name, Cell Range, [Column])

Arguments

NameTypeDescription
Spreadsheet-IdTextThe id of the spreadsheet to add columns to.
Sheet-Id or Sheet-NameNumber,TextID or name of the sheet to add columns to.
Cell RangeRangeA cell range which contains the values of the columns to insert.
Column (optional)TextColumn to insert at. If not specified new columns will be appended.

Return

TypeDescription
BooleanTRUE if insert was successful.

Examples

FormulaResultComment
=GOOGLE.SHEETS.COLUMN.INSERT2(B2, "S2", "G", D2:F5)
TRUEInserts values from range D2:F5 to columns starting at G in sheet S2 of spreadsheet with ID given in B2.