WP Excel CMS

Description

Simple plugin to import excel files (.xlsx only) to WordPress and use the data in your theme. No database entries are created. All file & json based. You can use as many excel files on one page as you want.

For example, if you have a guestlist in excel and you want to show it in a special style on your website, you can easily upload the excel file in your admin interface an then use wp_excel_cms_get("guestlist"); to get the structured data in your template.

If you want to use the Table in your post or page, you can use the Shortcode [wp_excel_cms name=”guestlist” sheet=”1″] .

The string “guestlist” have to be replaced by your given excel file name.

Short Code

[wp_excel_cms name="guestlist"]

Example Usage in Theme:

<?php $data = wp_excel_cms_get("guestlist"); ?>

<?php foreach($data as $entry): ?>
column 1: <?php echo $entry[0]; ?><br />
column 2: <?php echo $entry[1]; ?><br />
column 3: <?php echo $entry[2]; ?><br />
<hr />
<?php endforeach; ?>

I hope you enjoy this plugin. Give me feedback to improve it.

Donations

Screenshots

  • Admin Panel screenshot-1.(png)

Installation

Using The WordPress Dashboard

  1. Navigate to the ‘Add New’ in the plugins dashboard
  2. Search for ‘wp-excel-import’
  3. Click ‘Install Now’
  4. Activate the plugin on the Plugin dashboard

Uploading in WordPress Dashboard

  1. Navigate to the ‘Add New’ in the plugins dashboard
  2. Navigate to the ‘Upload’ area
  3. Select wp-excel-cms.zip from your computer
  4. Click ‘Install Now’
  5. Activate the plugin in the Plugin dashboard

Using FTP

  1. Download wp-excel-import.zip
  2. Extract the wp-excel-import directory to your computer
  3. Upload the wp-excel-import directory to the /wp-content/plugins/ directory
  4. Activate the plugin in the Plugin dashboard

Reviews

Plugin is Dead

Like so many WordPress plugins, it looks as though the author had abandoned this one. No responses for support in over a year and no longer works in current wordpress version. Don’t waste your time – look for another solution.

cut symbols

Hello!I encountered such a problem: symbols such as comma, slash are cut out table on site. Please, help me to understand this!

Failed to save data

I have a .xlsx file with 45 thousand row data, it is not showing any output after uploading. Nothing… It is not even able to upload a file of 4 MB data.
Sorry but, totally failed on my system…

Read all 14 reviews

Contributors & Developers

“WP Excel CMS” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

1.0

  • Inital Version

1.0.1

  • Fix: Upload Folder will be created automatically

1.0.2

  • New Feature: Shortcodes: [wp_excel_cms name=”guestlist”]

1.0.3

  • New Feature: You can now access sheets from your excel file: [wp_excel_cms name=”guestlist” sheet=”2″]

1.0.4

  • Added support for multi word slugs

1.0.5

  • Removed support for multi word slugs