Go Back

Import/Export CSV
Custom Tables

To import CSV file to any table add "{add:,importcsv}" tag to Catalog Layout. It will render an Upload button to import CSV files.

CSV File header will be compared to table field names to import the data to correct fields.

If no match found or the first line of the CSV file is not a header with field names then the field order will be used.

After the data import complete the web page will be reload automatically.

 

To export table to CSV add "{format:csv}" tag. It will render a CSV icon with the link to download CSV file that contains same tables and same fields as the page you have CSV icon on.

Another option is to create a separate layout to import the data as CSV, to render the page content as CSV. The Page content can be rendered as CSV, JSON or XML for export purposes, or to behave as an API server.

JoomlaBoat.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters
the trademark holder in the United States and other countries.