Title: Create custom layout on webpage
Last modified: August 22, 2016

---

# Create custom layout on webpage

 *  Resolved [bizwizkid](https://wordpress.org/support/users/bizwizkid/)
 * (@bizwizkid)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/create-custom-layout-on-webpage/)
 * I’m trying to create a more readable layout since I have about 1000 records and
   30 columns of data.
 * Is there a way to create a layout on my website where I call individual cells
   of my Google sheet? i.e. Put name, address and phone in one area, then email,
   website, contact person in another?
 * Thank you very much!
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/create-custom-layout-on-webpage/#post-5715669)
 * I’m not sure I understand the question.
 * If your spreadsheet contains different kinds of data that is unrelated, you should
   consider redesigning the structure of your spreadsheet. Spreadsheets are also
   not really useful for supplying layout data generally. If you’re unsure about
   how to use spreadsheets or what they are useful for, I recommend the free classes
   by [ExcelShir.com](http://excelshir.com/). (It says Excel but everything he teaches
   applies to Google Spreadsheets, too.)
 * Like he suggests in his many classes, you can also create a new sheet that references
   data in another sheet in order to use for different purposes. That might be a
   workaround useful in your case.
 *  Thread Starter [bizwizkid](https://wordpress.org/support/users/bizwizkid/)
 * (@bizwizkid)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/create-custom-layout-on-webpage/#post-5715693)
 * Hi Meitar, thanks for your response and this plugin!
 * To clarify I have a spreadsheet that has 30 cols and 1000 rows.
 * On my web page I’m using the Inline viewer to view the entire sheet. What I’m
   looking to do is actually create a single web page with only data from a single
   row. The end result would be like a yelp page listing, that would let me call
   a single cell on the sheet to place wherever I want on the final web page. So,
   rather than a row of data I’m looking to create a template where I could call
   individual cells to populate.
 * Thanks again!
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/create-custom-layout-on-webpage/#post-5715711)
 * Ah, I see. Well, you can use the `query` attribute attribute to `select` a certain
   row using a `where` clause, or define an `offset` and then a `limit` of 1 to 
   fetch only one row at a particular spot in your spreadsheet. But doing this programmatically
   in your templates is left as an exercise to the reader. 😉
 *  Thread Starter [bizwizkid](https://wordpress.org/support/users/bizwizkid/)
 * (@bizwizkid)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/create-custom-layout-on-webpage/#post-5715727)
 * Ok gotcha. Thanks again for this plugin, great work!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Create custom layout on webpage’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

## Tags

 * [layout](https://wordpress.org/support/topic-tag/layout/)
 * [sheet](https://wordpress.org/support/topic-tag/sheet/)

 * 4 replies
 * 2 participants
 * Last reply from: [bizwizkid](https://wordpress.org/support/users/bizwizkid/)
 * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/create-custom-layout-on-webpage/#post-5715727)
 * Status: resolved