# How to Insert Geometric Shapes into Google Sheets

Did you know that you can add geometric shapes you your Google Sheets? Shapes such as ◈, ●, or ◥ can be used to highlight important data or make your spreadsheets more visually appealing.

You can insert geometric shapes into Google Sheets using one of the three methods discussed below. Use the method that works best in your spreadsheet.

## Use the CHAR Function

You can insert shapes using a function called CHAR. To do this, first find the Unicode decimal code for the shape you want in the table at the end of this article. Then, use that code as the argument in the CHAR function. Let’s say you want to insert a square with rounded corners. Use the following code:

`=CHAR(9634)`

This formula, as seen in the image above, inserts the symbol called “WHITE SQUARE WITH ROUNDED CORNERS” into the spreadsheet cell.

## Copy and Paste

You can find the symbol you want in the table below, copy the shape, and paste it into your spreadsheet.

The Insert Special Characters add-on is the easiest way to insert special characters. Browse or search through all the shapes and choose the symbol you want. Then, insert the symbol with just one click.

## All Geometric Shapes with Unicode Decimal Codes

Decimal CodeNameAppearance
9632BLACK SQUARE
9633WHITE SQUARE
9634WHITE SQUARE WITH ROUNDED CORNERS
9635WHITE SQUARE CONTAINING BLACK SMALL SQUARE
9636SQUARE WITH HORIZONTAL FILL
9637SQUARE WITH VERTICAL FILL
9638SQUARE WITH ORTHOGONAL CROSSHATCH FILL
9639SQUARE WITH UPPER LEFT TO LOWER RIGHT FILL
9640SQUARE WITH UPPER RIGHT TO LOWER LEFT FILL
9641SQUARE WITH DIAGONAL CROSSHATCH FILL
9642BLACK SMALL SQUARE
9643WHITE SMALL SQUARE
9644BLACK RECTANGLE
9645WHITE RECTANGLE
9646BLACK VERTICAL RECTANGLE
9647WHITE VERTICAL RECTANGLE
9648BLACK PARALLELOGRAM
9649WHITE PARALLELOGRAM
9650BLACK UP-POINTING TRIANGLE
9651WHITE UP-POINTING TRIANGLE
9652BLACK UP-POINTING SMALL TRIANGLE
9653WHITE UP-POINTING SMALL TRIANGLE
9654BLACK RIGHT-POINTING TRIANGLE
9655WHITE RIGHT-POINTING TRIANGLE
9656BLACK RIGHT-POINTING SMALL TRIANGLE
9657WHITE RIGHT-POINTING SMALL TRIANGLE
9658BLACK RIGHT-POINTING POINTER
9659WHITE RIGHT-POINTING POINTER
9660BLACK DOWN-POINTING TRIANGLE
9661WHITE DOWN-POINTING TRIANGLE
9662BLACK DOWN-POINTING SMALL TRIANGLE
9663WHITE DOWN-POINTING SMALL TRIANGLE
9664BLACK LEFT-POINTING TRIANGLE
9665WHITE LEFT-POINTING TRIANGLE
9666BLACK LEFT-POINTING SMALL TRIANGLE
9667WHITE LEFT-POINTING SMALL TRIANGLE
9668BLACK LEFT-POINTING POINTER
9669WHITE LEFT-POINTING POINTER
9670BLACK DIAMOND
9671WHITE DIAMOND
9672WHITE DIAMOND CONTAINING BLACK SMALL DIAMOND
9673FISHEYE
9674LOZENGE
9675WHITE CIRCLE
9676DOTTED CIRCLE
9677CIRCLE WITH VERTICAL FILL
9678BULLSEYE
9679BLACK CIRCLE
9680CIRCLE WITH LEFT HALF BLACK
9681CIRCLE WITH RIGHT HALF BLACK
9682CIRCLE WITH LOWER HALF BLACK
9683CIRCLE WITH UPPER HALF BLACK
9684CIRCLE WITH UPPER RIGHT QUADRANT BLACK
9685CIRCLE WITH ALL BUT UPPER LEFT QUADRANT BLACK
9686LEFT HALF BLACK CIRCLE
9687RIGHT HALF BLACK CIRCLE
9688INVERSE BULLET
9689INVERSE WHITE CIRCLE
9690UPPER HALF INVERSE WHITE CIRCLE
9691LOWER HALF INVERSE WHITE CIRCLE
9696UPPER HALF CIRCLE
9697LOWER HALF CIRCLE
9698BLACK LOWER RIGHT TRIANGLE
9699BLACK LOWER LEFT TRIANGLE
9700BLACK UPPER LEFT TRIANGLE
9701BLACK UPPER RIGHT TRIANGLE
9702WHITE BULLET
9703SQUARE WITH LEFT HALF BLACK
9704SQUARE WITH RIGHT HALF BLACK
9705SQUARE WITH UPPER LEFT DIAGONAL HALF BLACK
9706SQUARE WITH LOWER RIGHT DIAGONAL HALF BLACK
9707WHITE SQUARE WITH VERTICAL BISECTING LINE
9708WHITE UP-POINTING TRIANGLE WITH DOT
9709UP-POINTING TRIANGLE WITH LEFT HALF BLACK
9710UP-POINTING TRIANGLE WITH RIGHT HALF BLACK
9711LARGE CIRCLE
9712WHITE SQUARE WITH UPPER LEFT QUADRANT
9713WHITE SQUARE WITH LOWER LEFT QUADRANT
9714WHITE SQUARE WITH LOWER RIGHT QUADRANT
9715WHITE SQUARE WITH UPPER RIGHT QUADRANT
9716WHITE CIRCLE WITH UPPER LEFT QUADRANT
9717WHITE CIRCLE WITH LOWER LEFT QUADRANT
9718WHITE CIRCLE WITH LOWER RIGHT QUADRANT
9719WHITE CIRCLE WITH UPPER RIGHT QUADRANT