Everything you need to know about the Matrixify (Excelify) format template. The template works in Excel, CSV and Google Sheets to manage your Shopify data in bulk.
Matrixify (Excelify) template Demo file
With the sheet name, you can tell Matrixify (Excelify) what you are importing.
If using XLSX file
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.
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“.
To import Customers the sheet name must contain the word “customers”, to import Blog Posts the sheet name must contain “blog posts”, etc.
If using CSV file
Since the CSV file can only contain one sheet, then the app will read the filename to understand what you are importing.
The file name should contain the entity that you wish to import, but you can also have other words in the file name.
Here are some examples:
- “my-shopify-products.csv” – the app will see word “products” and assume that you are importing “Products“.
- “these-are-discounts_2019-12.csv” – here the app will understand to import “Discounts“.
- “my-july-smart-collections.csv” – The app will read and understand that you are importing “Smart Collections“.
You can also upload multiple sheets the CSV file by compressing all the CSV sheets into the ZIP file.
The app would still look into each CSV files name.
The app will auto-detect CSV file encoding, like UTF-8, ISO-8859-1 (Latin 1), ISO-2022-JP, etc., and automatically convert to UTF-8 as needed for Shopify.
The formats that can be imported:
- Matrixify (Excelify) : Excel
- Matrixify (Excelify) : CSV (zipped or not zipped)
- Shopify: CSV (zipped or not zipped)
- Matrixify (Excelify) : Google Sheets (from Google Sheets shared public link)
Other external 3rd party formats that can be imported:
- Shopify Products CSV
- The Art Of Books
- Brandsdistribution (ask Support)
- Turn14 API
“Matrixify (Excelify) : Excel” Format
Matrixify (Excelify) Template is a single Excel file that can hold all your whole store data.
That data is organized in clear and human-readable tables, as several sheets.
The same file can be exported and imported.
One Excel file can hold several kinds of Shopify data items like Products, Customers, and so on.
Inside the Excel file, there are sheets (tabs at the bottom). Sheet names tell the app what kind of data is inside each sheet.
Recognized sheet names
- Smart Collections
- Custom Collections
- Draft Orders
- Blog Posts
Sheets must be named precisely as that – also big/small letters matter, so be sharp when giving those names, or better just use the exported file, or the template.
All the other sheets are ignored, so you can keep your reference data sheets also in the same file.
Columns and rows
In each sheet, the data is arranged in columns and rows.
Values in cells correspond to appropriate field value for that item. Sometimes values are text, sometimes numbers, sometimes TRUE or FALSE (which means yes or no).
Usually, when you enter that data into Excel, it will automatically understand, what is a text, what is a number, and what is TRUE or FALSE.
Those columns are basically the same data fields as you fill through Shopify Admin. For example, Product columns would be Handle, Title, Vendor, and so on.
Imports don’t need to have all columns – the app will update only those fields, which columns you are importing. If you have the column with an empty value, the app will set that field value to empty. So if you don’t want to change a field value, then remove the column from the import.
When you are updating data, sometimes you want to update just one field, like for example, product price. In that case, you can remove all the other columns, and the app will update only this one field, and leave other fields unchanged.
Column order doesn’t matter.
You can have your own additional columns – the app will just ignore the columns it doesn’t know.
Columns have colors, and those are visual indicators for you how those columns group logically together. When importing, the column colors are ignored.
When viewing import results, it will also color those columns. The columns that have white color means that those were ignored, the app didn’t know what that is.
Rows correspond to items in Shopify. Basically, one row is one item in Shopify (except, when you need more rows for one item).
Items that need several rows
For example, for Products, you might need several rows per product, if the product has several images or several variants. For Customers, you can have several rows, because one Customer can have several addresses. Smart Collections can have several Rules. And so on.
In case of Products, each new variant and each exported image will go in its own row. However, you can import several images by splitting them with the semicolon (;).
For the app to know that the row belongs to the same item, it needs to have either the same ID value, or the same Handle value (if ID is empty), or the same Title (if Handle is empty).
The ID is the unique number that Shopify generates for each item. When you create new items, leave it empty – Shopify will generate them for you. The ID is used when you need to update existing items – this ID will allow the app to identify which item you need to update.
When you repeat rows, you can just copy them down with all the values also for those columns, where only one value per item is needed. For example, if you will copy the same Title value for all the Variants rows, the app will use the only value from the first row and will ignore the rest.
You can tell by the column color and by its starting name that it belongs to repeated row. For example, all variant columns start with “Variant …” and are the same color.
When importing, the file must be sorted so that repeated rows for the same item are together (sorted by ID, Handle, or Title). Because, as soon as ID or Handle, or Title will change, it will be treated as next item.
Don’t have Excel?
If you don’t have Excel, you can use Google Sheets, and then go to File -> Download as -> Microsoft Excel (.xlsx).
Or you can just import directly from the Google Sheets URL – like in this tutorial: Schedule import to Shopify from Google Sheets.
Or you can edit the Excel file in other apps, like, Numbers (for MacOS), OpenOffice, LibreOffice, etc.
“Matrixify (Excelify): CSV” Format
If your store is so large that Excel file doesn’t fit all the data and might exceed Excel limitations, you can use the “Matrixify (Excelify): CSV” format, which has no size limitation at all – it can hold data well exceeding several millions of rows.
The most notable Excel limitations that exported data can break are:
- Total number of rows: 1 048 576 rows – can be exceeded if exporting really large sets of data, for example, above 800 000 Products.
- Total number of columns: 16 384 columns – usually broken only if you have an exceptionally large amount of Metafields.
- Total number of characters that a cell can contain: 32 767 characters – this can be broken by exporting long Metafields or Body HTML (descriptions)
Here you can find an official list of all Excel limitations.
This format is organized the same way as Excelfy Excel file, with the following differences:
- It is a zip file that contains CSV files.
- Each sheet inside the zip file is a separate CSV file. For example “Products.csv”, “Smart Collections.csv”, and so on. In this case, the CSV file name inside the zip file matters – the same as the Sheet names in the Excel file. It’s the way how you tell the app, what data in which file.
- CSV file column delimiter is the comma (,), and all text values are in double-quotes (“). Files are UTF-8 encoded. That ensures that Excel will always open them correctly without any special conversion.
- When importing, it is best that you zip the CSV file(s). That way they become more than 10x smaller and as a result – your upload is 10x faster. But you can import also plain CSV files – just they should be named according to Matrixify (Excelify) sheet naming rules.
“Shopify: CSV” Format
The app can import the Shopify CSV file of Products which you can export from the Admin.
To make it smaller, you can zip it and upload the zipped file.
CSV file and zip file can have any file name, just the file extension of the CSV file needs to be .csv.
CSV file column delimiter is the comma (,), and all text values are in double-quotes (“).
“Matrixify (Excelify): Google Sheets” Format
You can prepare your Google Sheets file in the exact way as you prepare the “Matrixify (Excelify): Excel” file.
Then share this sheet to be accessible as view only by the public. And paste that URL in the app.
Read more in this tutorial: Schedule import to Shopify from Google Sheets.