Exporting Tables

Export

Exporting a table allows you to use it in other programs, such as spreadsheet applications, and serves as a data backup. To export, select the tables and desired format. Multiple tables will be stored in a ZIP file.

Here are the steps to Export the table:
Go the Shopify Admin > Open Tablepress App > You can see Tablepress manu > Click Export.

Export your tables

Export your created table for migration or editing purposes in the selected format for either specific or all tables.

Select tables to export

Select all: If you want to export all the tables, simply check the “Select All” option.

Select specific tables: If you want to export specific tables, click the “Select Export” button and choose the tables you want to export. You can select multiple tables by holding down the “Ctrl” key (Windows) or the “Command” key (Mac).

Export format: You can export the table in CSV, JSON, or HTML formats, so choose one option from the list.

CSV Delimiter: A CSV delimiter is the character used to separate values (or fields) in a CSV (Comma-Separated Values) file. The delimiter defines how the data is divided into individual fields.

The CSV delimiter typically used is a comma (,), as CSV stands for “Comma-Separated Values”. However, TablePress allows you to import tables using different delimiters if needed, such as semicolons ( tabs (\t), or other characters, depending on the format of the file you are importing.

When importing a CSV file, you can often specify the delimiter during the import process to ensure that the data is parsed correctly into the table.

When you choose the CSV format, it is necessary to select a “CSV delimiter.” You can choose from:
Semicolon (;)
Comma (,)
Tab (\t for tabular)

ZIP File: This option is enabled by default if you export all tables. If you are exporting selected tables, you need to check this option to create a ZIP archive as per your choice.

After completing the above process, click the “Export File” button located at the top right corner.

When you press the “Export File” button, the table will be exported, and the exported file will be downloaded to your system. You can then open that file to check the table data.

If you select only two tables for export, you will see a folder containing two different table data files. If you select all tables, all table files will be displayed in one folder.