Rating 0 stars - 0 votes

How to Perform Magento 2 Excel Import

The availability to perform Magento 2 import of excel files into a web store seems a big advantage for those who own a large stock of products and need to process them massively. Unfortunately, Magento 2 backend does not support file upload in any other format, than .csv. So if you want to make a Magento 2 import of an excel file manually, you must use some tools to change the format into .csv or try to convert it by yourself. Though you should keep in mind, that online converting tools may break the file structure, so you would better to avoid applying them. You can also perform converting through the excel option letting you save the file in another format according to you computer system settings.

Magento Store Manager offers an opportunity to import excel files into the backend part of store easily and quickly, automatically converting them into .csv. Besides, it supports other file formats import, like csv, xlsx, xml, ods and txt. In this article we will find out how to perform Magento 2 products import in excel format. You should note, that Magento 2 excel import using Store Manager refers exclusively to products import.

How to Import an Excel File via Magento Store Manager

In order to upload excel file into Magento store using Store Manager application, follow these steps:

  1. Find Import/Export section on the toolbar and select 'Products' from the list.
  2. This will transfer you to Import/ Export Wizard.

    Find Import Export section on the toolbar and select 'Products' from the list
    Find Import Export section on the toolbar and select 'Products' from the list

  3. Before the import, it is recommended to backup store database to make the process secure. Press 'Import' to start the upload.
  4. Select source to upload the file from and specify the file charset. Make sure that the file is not open in Excel application, so it is not locked for the import. In case you have a saved configuration, you can use it.

  5. Select the file for import
    Select the file for import

  6. Next select the sheet to be imported.

  7. Select Sheet for Import
    Select Sheet for Import

    Remember, that Store Manager for Magento allows to upload one sheet at a time.

  8. Preview the .csv file and if it is ok, click Next.

  9. Preview .csv File and Set Delimiters for .csv File
    Preview .csv File and Set Delimiters for .csv File

  10. Specify the fields delimiters and check out some additional settings. If your file contains images, do not forget to tick the option normalizing an image name, in case there are used such symbols like space, #, @ or %.

  11. Fields Delimiters and Additional Settings
    Fields Delimiters and Additional Settings

  12. Select the store view to upload the file to.

  13. Select Store View to Import Products to
    Select Store View to Import Products to

  14. Specify base formats and separators. In most cases you can just leave the default settings. If something goes wrong on the Import Preview step, return here and change the settings.

  15. Base Formats
    Base Formats

  16. During the import Store Manager determines if the file being loaded is already contained in the database and must be modified or it is new, so the program will create a new record to store it’s data. That’s why on this step you have to assign .csv columns to database fields.

  17. Assign .csv Columns to Database Fields
    Assign .csv Columns to Database Fields

  18. Preview the import file and check that no errors occurred during the process by pressing 'Show Errors' button.

  19. Preview Import
    Preview Import

  20. Select the import method to be used for your excel file upload. In addition, you are able to perform some actions over the products out of the file (delete/set as 'Out of Stock', set as 'Disabled') and clear the relations between the existing files, ticking a box with the corresponding relation.

  21. Import Options
    Import Options

    Be sure to check all options on this stage and press 'Import' to have the excel file uploaded to your store backend.

    Please note, in case the imported excel file contains categories not existing at you store, they will be created by Store Manager automatically.

    Forget Magento 2 excel import inconveniences and perform the upload via Store Manager for Magento.

    Import Excel Files to Magento 2 Backend Now Free

    Import Now

Related Articles:

Card image

How to Import Products in Magento 2

A very detailed guide on importing products to Magento 2: step-by-setp tutorial, CSV sample, useful tips. Read More...

Card image

Required Magento 2 Import Values

Get deep guide to prepare an accurate CSV for Magento 2 import. Read More...

Card image

How to Import Magento 2 Customers

Learn how to upload Magento 2 customers from different file formats (.csv, .xls/.xslx, .ods, .xml and .txt). Read More...

Card image

Export All Categories From Magento 2

Check how you can export all Magento 2 categories with products via export assistant. Read More...

Be the first to comment.