1-800-224-1462
Cart2Cart  Seriously, this service saved me 100s of hours of work. I had over 1200 skus and they moved it over in a day. All the images, all the descriptions, categories... everything in tact. If you are on the fence about their ...  Cart2Cart
David Sammons

Excel Import to Your Magento Store Is Not a Problem

Every time Magento users want to import Excel file with products and other entities to their store database, they face one big problem. XLS (or XLSX) is not supported by the built-in Magento import tool.

Usually you convert xls to csv and import a converted file to your store database or you can add all products manually. Or are there some other ways to import Excel to Magento? Let’s see.

CSV and XLS Formatting

As Magento users know, the most commonly used import file format is csv. It can be done from Magento back-office and with great number of different add-ons. But every moon has a dark side. The most important thing while working with csv is to keep it properly formatted. The majority of problems with import are caused by a wrong file structure.

The csv requirements are to be strictly complied to. You should ensure that every row ends in \r and \n, so that the products were properly separated. Moreover, to identify what is product name and what its products description the field delimiter is needed. It is also a very important aspect of csv formatting and there are a lot of other requirements for csv.

Despite the fact that CSV is a very widespread filetype, XLS (or XLSX) file also has a number of advantages. You can simply add all needed data to the table and you will never be confused. You don’t need to add different symbols such as \r or \n and no field delimiters.

Let’s consider possible ways of import excel to Magento.

Excel Import

Magento Excel import is a pretty difficult procedure. Experienced Magento store owners don’t convert their xls files to a csv as the difference in formatting can cause import problems.

In turn, File2Cart recently has announced about a possibility to import Excel files to your Magento store. If you want to import your xls file you need to check the formatting. Your file should have one product in one row, four necessary fields: Product Name, Product ID, Products Description and Price. Also make sure that the number of fields in the first row is equal to the number of fields in other rows. It’s not difficult, as requirements for xls (xlsx) are less demanding.

If you decided to perform import of your Excel file to Magento right now, just pass the fast registration and try FREE Demo import. Be sure you will forget about errors and problems while Magento Excel import.

Related Post

Import products to your store right away!

Customer Testimonials

Performed on Amazon Elastic Cloud
Cart2Cart
Secured by Globe SSL
Cart2Cart
Cart2Cart  I don’t usually use any third party services, but when I was looking for a quick import solution I decided to try File2Cart. The service didn’t let me down. Thanks for the high professionalism and quick performance. ...  Cart2Cart
Date Written: 20 August 2012
Mark Shelley
Cart2Cart  I imported products with your one-time import plan. It was quite alright, for now the store functions fluently and all products are imported correctly. I consider using your scheduled import option, hope it works well ...  Cart2Cart
Date Written: 01 June 2012
Silvia Fox
http://tasteofcrete.com

Read more...