Import

30 May 14, 2025

The Import Table option is used when users have already created or collected data in external formats (such as CSV, Excel) and need to upload that data into the current application or system. You can choose to import it as a new table, replace an existing table, or append rows to an existing table.

There are two ways to import the table data.

You can use the Import feature from the left-hand menu below the app name.

Steps: Go to the Shopify admin > Open the app > you can see Import feature below app name in left side.

Or you can import data directly from the table manipulation page for that specific table.

Here are the steps to import the table:
Step 1: Go to your Shopify Admin.
Step 2: Open the app in your store and Navigate to the Dashboard page.
Step 3: Click the Edit button under the Actions column next to the table you want to import the data.
Step 4: The Table Manipulation page will open.
Step 5: Click on the tab labeled “Import”.
Step 6: You will see all the available features for import, and you can import it.

Note: There is a limit of 2,000 records for importing and saving data.

Import your tables

Let’s understand how to Import the table.

  • Select File: Click the Add File button and select the file from which the data needs to be imported.
  • Import Format: Choose the format of the file you are uploading: CSV, JSON, or XLSX.
  • How to Import a File into a Table:
    • Add New Table: When this option is selected, a new table will be created using the data from the imported file.
    • Replace Existing Table: When this option is selected, an additional dropdown will appear to select a table from the existing list. The data in the selected table will be replaced with the imported data.
    • Append Rows Above Existing Table: When this option is selected, a dropdown will appear to select a table from the existing list. The imported data will be added above the existing data in the selected table.
    • Append Rows Below Existing Table: When this option is selected, a dropdown will appear to select a table from the existing list. The imported data will be added below the existing data in the selected table.
Note: Only CSV, JSON, XLSX files are allowed.

After completing these steps, click on the “Import Table” option at the top right.

Once the table is imported, you will be redirected to the “Table Data” page, where you can edit the table if needed. Otherwise, go to the Dashboard to see the table, copy its shortcode, and paste it wherever you want to add the table.