Export Button

The features that DataTables provides can be greatly enhanced by the use of the plug-ins available on this page, which give many new user interaction and configuration options.

Reference
HTML5 Export Buttons
This example demonstrates these four button types with their default options. The other examples in this section demonstrate some of the options available.
NamePositionOfficeAgeStart dateSalary
Airi SatouAccountantTokyo332008/11/28$162,700
Ashton CoxJunior Technical AuthorSan Francisco662009/01/12$86,000
Bradley GreerSoftware EngineerLondon412012/10/13$132,000
Brielle WilliamsonIntegration SpecialistNew York612012/12/02$372,000
Cedric KellySenior Javascript DeveloperEdinburgh222012/03/29$433,060
Charde MarshallRegional DirectorSan Francisco362008/10/16$470,600
Colleen HurstJavascript DeveloperSan Francisco392009/09/15$205,500
Dai RiosPersonnel LeadEdinburgh352012/09/26$217,500
Garrett WintersAccountantTokyo632011/07/25$170,750
Gloria LittleSystems AdministratorNew York592009/04/10$237,500
NamePositionOfficeAgeStart dateSalary
Showing 1 to 10 of 20 entries
Column Selectors
All of the data export buttons have an exportOptions option which can be used to specify information about what data should be exported and how.
NamePositionOfficeAgeStart dateSalary
Airi SatouAccountantTokyo332008/11/28$162,700
Ashton CoxJunior Technical AuthorSan Francisco662009/01/12$86,000
Bradley GreerSoftware EngineerLondon412012/10/13$132,000
Brielle WilliamsonIntegration SpecialistNew York612012/12/02$372,000
Cedric KellySenior Javascript DeveloperEdinburgh222012/03/29$433,060
Charde MarshallRegional DirectorSan Francisco362008/10/16$470,600
Colleen HurstJavascript DeveloperSan Francisco392009/09/15$205,500
Dai RiosPersonnel LeadEdinburgh352012/09/26$217,500
Garrett WintersAccountantTokyo632011/07/25$170,750
Gloria LittleSystems AdministratorNew York592009/04/10$237,500
NamePositionOfficeAgeStart dateSalary
Showing 1 to 10 of 20 entries
Excel - Cell Background
The Excel export button saves to an XLSX file and the data can be customised before exporting the file using the customize method
NamePositionOfficeAgeStart dateSalary
Airi SatouAccountantTokyo332008/11/28$162,700
Ashton CoxJunior Technical AuthorSan Francisco662009/01/12$86,000
Bradley GreerSoftware EngineerLondon412012/10/13$132,000
Brielle WilliamsonIntegration SpecialistNew York612012/12/02$372,000
Cedric KellySenior Javascript DeveloperEdinburgh222012/03/29$433,060
Charde MarshallRegional DirectorSan Francisco362008/10/16$470,600
Colleen HurstJavascript DeveloperSan Francisco392009/09/15$205,500
Dai RiosPersonnel LeadEdinburgh352012/09/26$217,500
Garrett WintersAccountantTokyo632011/07/25$170,750
Gloria LittleSystems AdministratorNew York592009/04/10$237,500
NamePositionOfficeAgeStart dateSalary
Showing 1 to 10 of 20 entries
Custom File (JSON)
This example makes use of buttons.exportData() to get data from the host DataTable and then create a file with JSON data
NamePositionOfficeAgeStart dateSalary
Airi SatouAccountantTokyo332008/11/28$162,700
Ashton CoxJunior Technical AuthorSan Francisco662009/01/12$86,000
Bradley GreerSoftware EngineerLondon412012/10/13$132,000
Brielle WilliamsonIntegration SpecialistNew York612012/12/02$372,000
Cedric KellySenior Javascript DeveloperEdinburgh222012/03/29$433,060
Charde MarshallRegional DirectorSan Francisco362008/10/16$470,600
Colleen HurstJavascript DeveloperSan Francisco392009/09/15$205,500
Dai RiosPersonnel LeadEdinburgh352012/09/26$217,500
Garrett WintersAccountantTokyo632011/07/25$170,750
Gloria LittleSystems AdministratorNew York592009/04/10$237,500
NamePositionOfficeAgeStart dateSalary
Showing 1 to 10 of 20 entries
Settings
Theme Mode

Light / Dark / System

  • Sidebar theme

    Dark / Light

  • Sidebar Caption

    Show / Hide

  • Theme Layout

    LTR/RTL

  • Layout Width

    Full / Fixed

  • Custom Theme

    Choose your primary theme color

  • Header Theme

    Choose your Header theme color

  • Navbar Theme

    Choose your Navbar theme color

  • Logo Theme

    Choose your Logo theme color

  • Navbar Caption Color

    Choose your Navbar Caption Color

  • Navbar Image

    Choose your Navbar Background Image

  • Dropdown Menu Icon

    Choose your Dropdown Menu Icon

  • Dropdown Menu Link Icon

    Choose your Dropdown Menu Link Icon