Deprecated: Constant FILTER_SANITIZE_STRING is deprecated in /www/datatableplugin_774/public/wp-content/plugins/wordpress-seo/src/conditionals/third-party/elementor-edit-conditional.php on line 22

Deprecated: Constant FILTER_SANITIZE_STRING is deprecated in /www/datatableplugin_774/public/wp-content/plugins/wordpress-seo/src/conditionals/third-party/elementor-edit-conditional.php on line 28
Export Data Table in Excel - PubyDoc - Data Tables and Charts WordPress Plugin
Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /www/datatableplugin_774/public/wp-content/plugins/wordpress-seo/src/generators/schema-generator.php on line 186
Welcome to our Documentation

Export Data Table in Excel

Have you ever faced difficulties with a website or have you ever been afraid of losing your data? Thinking about it might frighten you for a second. Imagine how terrible it were if it happened for real. To sleep well, you must be sure that even if you lose your data, you have a backup to restore it.

Well, there are many plugins in WordPress proving the export option which allows saving any content of the website to your computer in different formats, and PubyDoc Data Table and Charts plugin is not an exclusion.  So, in this post, we will explain how you can export table data in Excel format. 

How to export data? 

To export data in MS Excel 2007(.xlxs) or MS Excel 2003 (.xls), you need to open the settings page of the needed table and in the newly-opened window select the data export format. It could be either MS Excel 2007(.xlxs) or MS Excel 2003 (.xls).

Export data

In the same window, there are few options to set up.

The Export only values (without styles) option means that a table will be exported without customization settings such as font style, color, etc. 

If you enable the Export raw values option values contained in the table will be also saved. 

The Export formulas option will export formulas from the table. 

The  Save header as the first line option will convert the header into the column data. 

After you select the needed settings, you need to click the Export button and that’s it. You can now go and check the downloaded file. 

Export option

How to export data from the frontend?

Besides a regular export from the settings page, the Data Table WordPress plugin has an option to enable the frontend exportation. To find out more about this feature, you can check this guide

Shopping Cart