Spreadsheet Formula Converter

Reference for converting formulas between Excel and Google Sheets. Find equivalent functions across platforms.

VLOOKUPlookup

Vertical lookup

Excel:=VLOOKUP(A1,B:C,2,FALSE)

Sheets:=VLOOKUP(A1,B:C,2,FALSE)

HLOOKUPlookup

Horizontal lookup

Excel:=HLOOKUP(A1,1:2,2,FALSE)

Sheets:=HLOOKUP(A1,1:2,2,FALSE)

XLOOKUPlookup

Modern lookup (2D)

Excel:=XLOOKUP(A1,B:B,C:C)

Sheets:=XLOOKUP(A1,B:B,C:C)

INDEX/MATCHlookup

Flexible lookup combo

Excel:=INDEX(C:C,MATCH(A1,B:B,0))

Sheets:=INDEX(C:C,MATCH(A1,B:B,0))

OFFSETlookup

Dynamic range reference

Excel:=OFFSET(A1,1,1,3,3)

Sheets:=OFFSET(A1,1,1,3,3)

CONCATCONCAT/CONCATENATEtext

Join text strings

Excel:=CONCAT(A1," ",B1)

Sheets:=CONCATENATE(A1," ",B1)

TEXTJOINTEXTJOIN/JOINtext

Join with delimiter

Excel:=TEXTJOIN(",",TRUE,A1:A5)

Sheets:=TEXTJOIN(",",TRUE,A1:A5)

LEFTtext

Extract left characters

Excel:=LEFT(A1,5)

Sheets:=LEFT(A1,5)

RIGHTtext

Extract right characters

Excel:=RIGHT(A1,3)

Sheets:=RIGHT(A1,3)

MIDtext

Extract middle characters

Excel:=MID(A1,2,4)

Sheets:=MID(A1,2,4)

TRIMtext

Remove extra spaces

Excel:=TRIM(A1)

Sheets:=TRIM(A1)

SUBSTITUTEtext

Replace text

Excel:=SUBSTITUTE(A1,"old","new")

Sheets:=SUBSTITUTE(A1,"old","new")

TODAYdate

Current date

Excel:=TODAY()

Sheets:=TODAY()

NOWdate

Current date & time

Excel:=NOW()

Sheets:=NOW()

EDATEdate

Add months to date

Excel:=EDATE(A1,3)

Sheets:=EDATE(A1,3)

NETWORKDAYSdate

Working days between dates

Excel:=NETWORKDAYS(A1,B1)

Sheets:=NETWORKDAYS(A1,B1)

WEEKDAYdate

Day of week number

Excel:=WEEKDAY(A1,2)

Sheets:=WEEKDAY(A1,2)

SUMIFmath

Conditional sum

Excel:=SUMIF(A:A,">100",B:B)

Sheets:=SUMIF(A:A,">100",B:B)

SUMIFSmath

Multiple criteria sum

Excel:=SUMIFS(C:C,A:A,">100",B:B,"Yes")

Sheets:=SUMIFS(C:C,A:A,">100",B:B,"Yes")

COUNTIFmath

Conditional count

Excel:=COUNTIF(A:A,">100")

Sheets:=COUNTIF(A:A,">100")

AVERAGEIFmath

Conditional average

Excel:=AVERAGEIF(A:A,">0",B:B)

Sheets:=AVERAGEIF(A:A,">0",B:B)

ROUNDmath

Round to decimals

Excel:=ROUND(A1,2)

Sheets:=ROUND(A1,2)

CEILINGmath

Round up to multiple

Excel:=CEILING(A1,5)

Sheets:=CEILING(A1,5)

IFlogic

Conditional logic

Excel:=IF(A1>100,"High","Low")

Sheets:=IF(A1>100,"High","Low")

IFSlogic

Multiple conditions

Excel:=IFS(A1>90,"A",A1>80,"B")

Sheets:=IFS(A1>90,"A",A1>80,"B")

SWITCHlogic

Value matching

Excel:=SWITCH(A1,1,"One",2,"Two")

Sheets:=SWITCH(A1,1,"One",2,"Two")

IFERRORlogic

Error handling

Excel:=IFERROR(A1/B1,0)

Sheets:=IFERROR(A1/B1,0)

ANDlogic

All conditions true

Excel:=AND(A1>0,B1<100)

Sheets:=AND(A1>0,B1<100)

ORlogic

Any condition true

Excel:=OR(A1>100,B1>100)

Sheets:=OR(A1>100,B1>100)

FILTERarray

Filter array by criteria

Excel:=FILTER(A:B,A:A>100)

Sheets:=FILTER(A:B,A:A>100)

SORTarray

Sort array

Excel:=SORT(A1:B10,1,TRUE)

Sheets:=SORT(A1:B10,1,TRUE)

UNIQUEarray

Unique values

Excel:=UNIQUE(A:A)

Sheets:=UNIQUE(A:A)

TRANSPOSEarray

Flip rows/columns

Excel:=TRANSPOSE(A1:D1)

Sheets:=TRANSPOSE(A1:D1)

SEQUENCEarray

Generate number sequence

Excel:=SEQUENCE(5,3,1,1)

Sheets:=SEQUENCE(5,3,1,1)

N/AIMPORTRANGEsheets-only

Import from other sheet

Excel:Not available

Sheets:=IMPORTRANGE("url","Sheet1!A:B")

N/AQUERYsheets-only

SQL-like data query

Excel:Not available

Sheets:=QUERY(A:C,"SELECT A,B WHERE C>100")

N/AGOOGLEFINANCEsheets-only

Stock data

Excel:Not available

Sheets:=GOOGLEFINANCE("GOOG","price")

N/AIMAGEsheets-only

Insert image from URL

Excel:Not available

Sheets:=IMAGE("https://...")

N/AARRAYFORMULAsheets-only

Apply formula to range

Excel:Use Ctrl+Shift+Enter

Sheets:=ARRAYFORMULA(A:A*B:B)

GETPIVOTDATALimited supportexcel-only

Extract pivot table data

Excel:=GETPIVOTDATA("Sales",A3)

Sheets:Limited in Sheets

LETexcel-only

Define variables

Excel:=LET(x,A1*2,x+x)

Sheets:=LET(x,A1*2,x+x)

LAMBDAexcel-only

Custom functions

Excel:=LAMBDA(x,x*2)(5)

Sheets:=LAMBDA(x,x*2)(5)

Tips:

• Most formulas work identically in Excel and Google Sheets
• Google Sheets has unique functions like QUERY, IMPORTRANGE, GOOGLEFINANCE
• Excel uses Ctrl+Shift+Enter for array formulas; Sheets uses ARRAYFORMULA

Excel vs Google Sheets - Technische Details

While most formulas work identically in Excel and Google Sheets, some features are platform-specific. Google Sheets has unique functions like QUERY, IMPORTRANGE, and GOOGLEFINANCE, while Excel has features like Power Query and XLOOKUP.

Kommandozeilen-Alternative

// Google Sheets-only
=QUERY(A:C, "SELECT A, B WHERE C > 100")

// Works in both
=VLOOKUP(A1, B:C, 2, FALSE)

Referenz

Offizielle Spezifikation ansehen