google-spreadsheet Using arrays in Google Sheets

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

Syntax

  • ={item1,item2}
  • ={item2,item2;item3,item4}
  • ={{item1;item2},{item3,item4;item5,item6}}

Parameters

ParameterDetails
itemNIt could be a value, a cell reference, a range reference or a function

Remarks

Overview

An array of literals is written between curly brackets. Separators depends on the spreadsheet's regional configuration settings.

  • To separate columns, if the decimal separator is . use , but if the decimal separator is , then use \.
  • To separate rows use ;.

Official Documentation

Google Docs editors Help



Got any google-spreadsheet Question?