Sometimes values are text, sometimes numbers, sometimes TRUE or FALSE (which means yes or no). Values in cells correspond to appropriate field value for that item. In each sheet, the data is arranged in columns and rows. You can import multiple sheets with different entities as long as the sheet/tab names are set correctly.Īll the other sheets are ignored, so you can keep your reference data sheets also in the same file.

To import Customers the sheet name must contain the word “customers”, to import Blog Posts the sheet name must contain “blog posts”, etc.

The sheet/tab name in Excel file can contain other words, but if your file will have two sheets – “ Products” and “ Products data” then the app will only import “ Products” and ignore “ Products data“. In XLSX file you can import multiple sheets at the same time so the file name does not matter, but you will need to specify sheet/tab name in the file for each sheet. Sheet names tell the app what kind of data is inside each sheet. Inside the Excel file, there are sheets (tabs at the bottom). One Excel file can hold several kinds of Shopify data items like Products, Customers, and so on. The same file can be exported and imported. That data is organized in clear and human-readable tables, as several sheets. Using the Matrixify app you can import and export Excel XLSX file with multiple sheets in it! Other external formats that can be imported:

Matrixify: Google Sheets ( from Google Sheets shared public link).

Import google sheets to excel