Export/Import

With Data Tables Generator plugin you have an opportunity to export and import your tables.

Data Tables Export and Import

Export

If you want to export data from the table to the file use Export option. You can export files of four types:

  • CSV
  • PDF
  • XLS
  • XLSX

To export the table follow the next instruction:

  1. Click Export button on the top bar menu of a table you want to export.
  2. Choose a file type and click Export.
  3. Data Tables Generator Export option

  4. File with the table is downloaded to your computer.

With Data Tables by Supsystic PRO your users get an opportunity to export the table from the site:

  • in CSV file,
  • in XLS file,
  • in XLSX file,
  • in PDF file,
  • or print the table right from the site.

Enable this option just in two steps:

  1. Go to Settings tab of the table and find Features section.
  2. Select file types in Frontend Export option.

Data Tables Frontend Export Options

As a result users will be able to download or print your table by clicking on one of options:

Data Tables plugin Frontend export

Additionally you can set such options:

  • Export Page Orientation – choose the page orientation for PDF export file: portrait or landscape.
  • Use Export Font – if you use some specific characters (greek, cyrillic etc.) it is better to use DejaVu font for PDF export.
  • Export Logo – add selected logo for output PDF or printing.
  • Logo Position – select logo position – above or below the table.
  • Logo Alignment – set logo alignment to left, right or center.

Import

If you already have the table and you need to use it on your site use Import option. You can import files of such formats:

  • CSV,
  • XLS,
  • Google Spreadsheets.

To import the table from CSV or XLS files follow the next instruction:

  1. Create a new table where you will import your data.
  2. Click Import button on the top bar menu of a new table.  
    Data Tables Generator Import option
  3. Select a file extention type with your data. If it’s CSV file define a delimiter for it.
  4. Choose a file with the table from your computer and click Import.

If you need to import a Google Spreadsheets table:

  1. Create a new table where you will import your data.
  2. Click Import button on the top bar menu of a new table.
  3. Select Google Spreadsheets.
  4. Insert a link of your Google Spreadsheet table and click Import.

Data Tables Generator plugin Import Google Spreadshhets

Important! Please, check the sharing settings of your Google Spreadsheet: it must be accessed to edit for everyone who has the link. In other case the data will not be imported to the table.

Categories
Latest Articles
Get plugins bundle today and save over 80%