Tag: Excel to wordpress

Demo CSV to Webpage

Live Demo

This plugin display data from the CSV as Responsive table.Upload your CSV file using the upload button in the settings page.Please click here to find out how to install the plugin.

Using this wordpress plugin you also sort the table values.It also adds pagination as shown.It is also possible to display multiple tables in one page as shown below.

Demo 1

The demo display CSV data from the score.csv file.The shortcode for displaying the following table.

csv-to-webpage-demo

DateHome TeamAway TeamScore
20-09-2014Group AGroup J 2 - 4
20-09-2014Group DGroup I 3 - 3
04-10-2014Group CGroup A 6 - 0
11-11-2014Group EGroup F 2 - 4
12-12-2016Group JGroup K 3 - 3
04-08-2016Group LGroup M 6 - 0
11-04-2015Group IGroup O 2 - 4
12-09-2015Group PGroup U 3 - 3

Demo 2 (Pagination and Sort functionality)

Please use the following shortcode for enabling the pagination and table sort functionality.

csv-to-webpage-live-demo

First Prev Next Last
NoNameM1M2M3
1Andy8734121
2Joe104454
4Alison309484
5Ryan6044104
43Kevin6021819
55Tom642134
63Ben6721811
75Smith214114
83Max701181
35Tom642134
13Ben6721811
25Smith214114
49Max701181

Demo 3 (Table sorting functionality)

The following demo display the data from the same file without pagination.The following shortcode read the data from 59.csv and display the data without pagination.

demo-csv-to-webpage

NoNameM1M2M3
1Andy8734121
2Joe104454
4Alison309484
5Ryan6044104
43Kevin6021819
55Tom642134
63Ben6721811
75Smith214114
83Max701181
35Tom642134
13Ben6721811
25Smith214114
49Max701181

Demo 4 (Special characters)

DateHome TeamAway TeamScorePrice
20/09/2014Group AGroup J 2 - 4 £30
20/09/2014Group DGroup I 3 - 3£340
04/10/2014Group CGroup A 6 - 0 £40
11/11/2014Group EGroup F 2 - 4 £50
12/12/2016Group JGroup K 3 - 3£60
04/08/2016Group LGroup M 6 - 0 £70
11/04/2015Group IGroup O 2 - 4 £80
12/09/2015Group PGroup U 3 - 3£90

 

If you have any further queries please leave a reply.

Thanks

CSV to Responsive Tables

CSV to Webpage plugin help to upload content from the CSV (Excel File) file to the pages/post or in widgets (sidebar or footer) in few steps. It is easy to use and simple to implement.

It is possible to upload CSV content to webpage in responsive table format. Data from multiple excel files can be loaded to the webpage using the plugin.

Install CSV to Webpage

Steps to install plugin :

  1. Download the plugin [ plugin url : https://wordpress.org/plugins/csv-to-webpage-plugin/ ]
  2. Login into to the WordPress admin area
  3. From the Dashboard please select Plugins->Add New as shown in the figure.1
  4. Select ‘upload plugin’ button as show below.6
  5. Select the plugin (downloaded zip file from system) using the ‘choose File’ and click ‘Install Now6
  6. Then click ‘Activate Plugin’ link as shown below.3
  7. After successfully installing the plugin. Select Settings->CSV to Webpage
    4
  8. From the Setting page choose the .csv file from the system using the ‘Choose File’ button and click ‘upload’ button for upload the files to the server.7
  9. Select the page / post where you want to display the responsive table and enter
    {pearl_csv_to_webpage_display filename = filename1.csv} as shown below. (Replace ‘filename1’ with the name of your file).8
  10. For displaying multiple CSV in the page please enter
    {[}pearl_csv_to_webpage_display filename = filename1.csv{]}
    {[}pearl_csv_to_webpage_display filename = filename2.csv{]}
  11. If you want to enable column sorting, enter the column number that need to be sorted in the shortcode as shown below.
    Sort Excel Tables
  12. Hope you find this tutorial helpful. Please leave a reply if you have any queries or suggestions. Please click here if you would like to make a donation.

Create CSV Widget

How to add CSV files content to the sidebar/ footer as the widget

  1. Please check the link below to find how to install the plugin. [ Url : http://www.pearlbells.co.uk/install-csv-to-webpage/ ] and follow the steps 1 – 8.
  2. After successfully installing the plugin. Select Appearance->Widgets as show below.
    CSV Widget WordPress
  3. Please drag and drop the ‘CSV to Responsive tables’ widget to the available sidebar or footer location as show below.
    drag and drop CSV plugin
    Sort Excel Tables
  4. Please enter the ‘Title’ and the ‘filename
  5. Enter the column numbers that need to sort as shown above. (Above example will sort the second and third columns). Leave the sort text field blank if you do not want to sort any columns.
  6. Click ‘save’ button.
  7. Hope you find this tutorial helpful. Please leave a reply if you have any queries or suggestions. Please click here if you would like to make a donation.