How to add Cambridge Dictionary in google sheets

Опубликовано: 18 Май 2026
на канале: Fujin Chan

3,144

204

Help you import Cambridge Dictionary into google sheets
#googlesheets #shorts #dictionary

Cell Formula

C2 =IFERROR(JOIN(" ",INDEX(IMPORTXML("http://dictionary.cambridge.org/dicti..."&B2,"//div[contains(@class,'ddef_d')]"),1)))
C3 =IFERROR(JOIN(" ",INDEX(IMPORTXML("http://dictionary.cambridge.org/dicti..."&B2,"//div[contains(@class,'ddef_d')]"),2)))
C4 =IFERROR(JOIN(" ",INDEX(IMPORTXML("http://dictionary.cambridge.org/dicti..."&B2,"//div[contains(@class,'ddef_d')]"),3)))
C5 =IFERROR(JOIN(" ",INDEX(IMPORTXML("http://dictionary.cambridge.org/dicti..."&B2,"//div[contains(@class,'ddef_d')]"),4)))
C6 =IFERROR(JOIN(" ",INDEX(IMPORTXML("http://dictionary.cambridge.org/dicti..."&B2,"//div[contains(@class,'ddef_d')]"),5)))
C7 =IFERROR(JOIN(" ",INDEX(IMPORTXML("http://dictionary.cambridge.org/dicti..."&B2,"//div[contains(@class,'ddef_d')]"),6)))