Dan's Google Sheets Data Embedder was created out of a need for non-technical users to move complex calculations outside WordPress and into a more familiar spreadsheet environment, as well as the ability to share just the pieces of information needed from a spreadsheet rather than sharing the entire document.
Dan's GSheets allows you to embed the values for either an individual cell, or for ranges directly via shortcode. No need to import data or manage it directly in WordPress. All you need is a public Google Sheets Document (or multiple!) and a free, easy to get API key.
Suggested Uses
Offload all of your complex calculations to Google Sheets! Take data from Google forms, or wherever else you wish, and just display the results
Have a non-techinical client or user that needs to be able to update a specific message? Just map that spot to a Google Sheets Cell via shortcode, and share that document with them with edit abilities
Create a nice front end in WordPress, and update live scores via Google Sheets as a spreadsheet
Did you come up with something else? We'd love to hear about it! Share in your review or via a message on my site.
Features
Displays public Google Sheet Document data in an easy-to-format view
Live updates on page load. Just change your data in your sheet, and it's live on site!
Displays cells or ranges of cells from any public Google Sheet
Individual cells are displayed as spans
Spans of cells displayed as tables, with optional headers
Can target any tab within a Google Sheets document
Able to use shortcode multiple times per post / page
All options are configured via shortcode
Ability to store and use unlimited Google Sheet Documents
Shortcodes:
Basic: [dansheet] (defaults to first document, default tab name)
Single Cell: [dansheet file=1 sheetname="Sheet1" cell=A1 class="gsheets-special"]
Range of Cells: [dansheet file=1 sheetname=Sheet1 cell=A1:C2 theaders="Col 1,Col 2,Col 3" class="gsheets-special2"]
Optional Attributes
file=# (number of the Google Doc you have set in the settings page)
sheetname= name of sheet in doc
cell (mandatory)= Cell Number or range, with :
class=custom class name or names here
theaders = Comma seperated list of column headers, in order, for range view (optional)
For help creating an API key to use with this plugin, either check out the settings page in plugin, or the FAQ tab here.
To see other plugins like this, or tips on how these are built, check out WP Tech Guides.
Datapress
Show maps, timelines, and rich data visualizations in your blog!...
Dan's Embedder for Google Calendar
Dan's Embedder for Google Calendar was created out of a need to display Google calendars in both list and full view in a way that was mobile friendly, customizable via shortcode, and easy to style. No need to import events or manage them directly in WordPress. All you need is a public Google Calenda.........
Cloudstitch
Cloudstitch is a community of spreadsheet powered widgets you can add to any site -- things like product lists, data visualizations, and conference schedules.
This plugin makes every widget on Cloudstitch available in WordPress with a simple Shortcode.
Adding a shaded electoral map of the US, for .........
GData Importer
A wordpress plugin which imports Google Spreadsheet Data into the WordPress Page/Post using shortcode.
You have to provide Sheet Key, Worksheet Name, Username and Password in shortcode.
Usage:
[gdata_import key="spreadsheet_key" worksheet="worksheet_name" user="your_username" pass="your_password"]
.........
iPushPull for WordPress
The iPushPull WordPress plugin makes it easy to display live updating data from your desktop Excel spreadsheets in your WordPress pages....
Dan's Viewer for Google Drive
Dan's Viewer for Google Drive was created when I was looking for a way to share files via Google Drive on my sites, in a way that allowed downloading, viewing, exporting, and hardest to find, the ability drill down into subfolders without leaving the site. I couldn't find anything within my price r.........
CF7 Google Sheets Connector
How to Use this Plugin
Install the CF7 Google Sheet Connector plugin if you haven't already.
You will notice a new Menu under contact form which says "Google Sheets"
Now First of all log in to your Google Account and create a new Sheet and give it a simple name.
Rename Sheet 1 (tab 1 of the spre.........
Inline Google Spreadsheet Viewer
Easily turn data stored in a Google Spreadsheet, CSV file, MySQL database, or the output of a Google Apps Script into a beautiful interactive chart or graph, a sortable and searchable table, or both. Embed live previews of PDF, XLS, DOC, and other file formats supported by the Google Docs Viewer. A .........
Users Data Exporter
Robust way to export selected users data to .xlsx spreadsheet, especially when number of users of a site is very big like 100,000+.
Available Filters:
- User Roles (One or more)
- User Email
- User Login
- User ID
- User Registration Date
- Paid Membership Pro Level
- User Meta Fields (One or more).........
Import Anything
Description:
Import any XML or CSV file to your WordPress website within minutes. It's easily done with our simple user friendly interface.
READ MORE: You can read more about the plugin here
Features:
Upload file from computer ($5 version feature)
Upload file from FTP
Upload file from URL
Impor.........
