# Display Google Sheets data in a WordPress site If you have data from a Google Spreadsheet that you want to show to your users, SheetDB have great Library for that. To install it go to your WordPress Dashboard. Then go to Plugins > Add New and search for: SheetDB You can also download and install it manually, the plugin page is here: [https://wordpress.org/plugins/sheetdb/](https://wordpress.org/plugins/sheetdb/) From now on, you can use it like our [handlebars library](https://sheetdb.io/use-cases/handlebars-library). You can also use the Square Brackets syntax to feel more WordPress like. Let's make a simple table using this spreadsheet: [https://docs.google.com/spreadsheets/d/1YiMOrIFnMaksK032-zv6Sch2tTVTRhEpsFom_5qSLXM/edit](https://docs.google.com/spreadsheets/d/1YiMOrIFnMaksK032-zv6Sch2tTVTRhEpsFom_5qSLXM/edit) To display the content, add the shortcode like this: ```html [sheetdb url="https://sheetdb.io/api/v1/YOUR_API_ID"][/sheetdb] ``` Content from within will be rendered as many times as there are rows in the spreadsheet (excluding the first row, which are column names). Each time a new row is rendered, you can refer to any value using the braces notation: `{{column_name}}`. Of course you can use html to style the result. Using `{{name}}` renders plain text only (HTML is escaped). To render safe HTML, use `{{html:name}}` — unsupported or unsafe tags/attributes are sanitized. ```html [sheetdb url="https://sheetdb.io/api/v1/58f61be4dda40"] {{id}} – {{name}}
[/sheetdb] ``` The result of this code is here: 1 – Tom 2 – Alex 3 – John 4 – Steve 5 – James ## Additional attributes You can use following optional attributes: - limit – The number of rows that should be returned - offset – Row from which it should start (how many rows to skip) - search – You can search for specific data in your sheet. If you want to use more than one condition join them using `&` symbol. Example: `search="name=Tom&age=15"` - sheet - Specify the sheet (tab) you want to work with - sort-by – The column you want to sort by - sort-order – sort in `asc` or `desc` order - element - the element that will contain all content, defaults to `div` ## HTML rendering and safety - Using `{{name}}` renders plain text. Any HTML is escaped and will not be executed or rendered. - Using `{{html:name}}` allows most safe HTML tags to render (e.g. `a`, `p`, `ul`, `li`, `strong`, `em`, `img` etc. with safe attributes). Potentially dangerous tags and attributes (e.g. `