What is the difference between Shopify CSV and Excelify.io Products import and export?

Difference between Shopify CSV and Excelify

Differences between using Shopify CSV for Products export and import, or Excelify.io:

  1. With Shopify you work with CSV files, whereas with Excelify.io you work with pure Excel files.
  2. With Shopify you upload the CSV file and wait for e-mail – you don’t see what’s happening, and you don’t control anything; whereas with Excelify.io you see the progress of your imports/exports, estimated time to complete, and can cancel them any time.
  3. With Shopify CSV export you always get the full store with all products and all fields, whereas with Excelify.io you can choose in more grained details, what details to export, and filter which Products you need to export. That is convenient, because it not only saves the time and file size, but also because it allows you to export data so that you don’t have those duplicate rows. For example, if you want to just update Tags, then you don’t need Images or Variants, because those create additional rows for each product in the table, but you need just one row per product, just with base columns where the Tag column is.
  4. With Shopify CSV – to import several images per product, you need to copy rows and put image in each row, whereas with Excelify.io you can put all images in one row in “Image Src” column, split images by semicolon ;. See: How to import several product images from one row?
  5. With Shopify CSV you cannot export or import Metafields, whereas with Excelify.io you can export Metafields as columns in the same table of Products, edit them, and import them back as updates. See Metafields documentation.
  6. With Shopify CSV, when you import, you either create new, or replace existing Products (you cannot update, only replace); whereas with Excelify.io you can update products as well. You can update even individual fields by importing just those fields (together with ID). See for example the tutorial how to update just the Product Price.
  7. With Shopify CSV – to update Image Alt Text field, you need to import whole Product with all its variants again, and replace it; whereas with Excelify.io you export existing Products with just Images and Image Alt Text as additional data, update that column in the Excel file and import it back as an update.
  8. With Shopify CSV you cannot export or import Template Suffix field of your products, and you cannot update it in bulk, where as with Excelify.io the Template Suffix is just one column in the file, which you export or import.
  9. With Shopify CSV you have the file size limit of 15 MB, which is roughly not more than 10’000 Products (depending on your images/variants rows); whereas with Excelify.io there is 100 MB Excel file size limit you can upload, which for the Excel file is a lot more than you can ever need, because Excel file is compressed. For example, 300’000+ Products in one import is ok.
  10. Descriptions that contain escaped HTML code, with symbols like < > are being fixed to normal HTML code.