I haven't had any luck with importing products using an Excel spreadsheet.
I read this page - http://docs.abantecart.com/pages/tools/import.html and downloaded the sample "tab delimited" file for review.
When I created a simple spreadsheet in Excel and saved as tab delimited. I reopened the file, selected tax delimited and got this -
A B C A B C A B C
2 2 2 2 2 2 2 2 2
3 3 3 3 3 3 3 3 3
Very nice
Why does the sample not work the same way?
Excel imported the file, products-insert-example-tab. It looks like garbage.
"action products.model products.sku products.location products.quantity products.stock_status_id products.manufacturer_id products.shipping products.ship_individually products.free_shipping products.shipping_price products.price products.tax_class_id products.date_available products.weight products.weight_class_id products.length products.width products.height products.length_class_id products.status products.viewed products.sort_order products.subtract products.minimum products.cost product_descriptions[0].language_id product_descriptions[0].name product_descriptions[0].meta_keywords product_descriptions[0].meta_description product_descriptions[0].description product_descriptions[1].language_id product_descriptions[1].name product_descriptions[1].meta_keywords product_descriptions[1].meta_description product_descriptions[1].description products_related[0].related_id products_to_categories[0].category_id products_to_categories[1].category_id products_to_categories[2].category_id products_to_categories[3].category_id products_to_downloads[0].download_id products_to_stores[0].store_id product_options[0].product_option_id product_options[0].attribute_id product_options[0].group_id product_options[0].sort_order product_options[0].status product_options[0].element_type product_options[0].required product_option_descriptions[0][0].language_id product_option_descriptions[0][0].name product_option_descriptions[0][1].language_id product_option_descriptions[0][1].name product_option_values[0][0].product_option_value_id product_option_values[0][0].group_id product_option_values[0][0].sku product_option_values[0][0].quantity product_option_values[0][0].subtract product_option_values[0][0].price product_option_values[0][0].prefix product_option_values[0][0].weight product_option_values[0][0].weight_type product_option_values[0][0].attribute_value_id product_option_values[0][0].grouped_attribute_data product_option_values[0][0].sort_order product_option_value_descriptions[0][0][0].language_id product_option_value_descriptions[0][0][0].name product_option_value_descriptions[0][0][0].grouped_attribute_names product_option_value_descriptions[0][0][1].language_id product_option_value_descriptions[0][0][1].name product_option_value_descriptions[0][0][1].grouped_attribute_names product_option_values[0][1].product_option_value_id product_option_values[0][1].group_id product_option_values[0][1].sku product_option_values[0][1].quantity product_option_values[0][1].subtract product_option_values[0][1].price product_option_values[0][1].prefix product_option_values[0][1].weight product_option_values[0][1].weight_type product_option_values[0][1].attribute_value_id product_option_values[0][1].grouped_attribute_data product_option_values[0][1].sort_order product_option_value_descriptions[0][1][0].language_id product_option_value_descriptions[0][1][0].name product_option_value_descriptions[0][1][0].grouped_attribute_names product_option_value_descriptions[0][1][1].language_id product_option_value_descriptions[0][1][1].name product_option_value_descriptions[0][1][1].grouped_attribute_names product_specials[0].product_special_id product_specials[0].customer_group_id product_specials[0].priority product_specials[0].price product_specials[0].date_start product_specials[0].date_end product_tags[0].tag product_tags[0].language_id product_tags[1].tag product_tags[1].language_id product_tags[2].tag product_tags[2].language_id product_tags[3].tag product_tags[3].language_id resource_map[0].resource_id resource_map[0].object_name resource_map[0].object_id resource_map[0].default resource_map[0].sort_order resource_library[0][0].resource_id resource_library[0][0].type_id resource_descriptions[0][0][0].language_id resource_descriptions[0][0][0].name resource_descriptions[0][0][0].title resource_descriptions[0][0][0].description resource_descriptions[0][0][0].resource_path resource_descriptions[0][0][0].resource_code resource_descriptions[0][0][1].language_id resource_descriptions[0][0][1].name resource_descriptions[0][0][1].title resource_descriptions[0][0][1].description resource_descriptions[0][0][1].resource_path resource_descriptions[0][0][1].resource_code resource_map[1].resource_id resource_map[1].object_name resource_map[1].object_id resource_map[1].default resource_map[1].sort_order resource_library[1][0].resource_id resource_library[1][0].type_id resource_descriptions[1][0][0].language_id resource_descriptions[1][0][0].name resource_descriptions[1][0][0].title resource_descriptions[1][0][0].description resource_descriptions[1][0][0].resource_path resource_descriptions[1][0][0].resource_code resource_descriptions[1][0][1].language_id resource_descriptions[1][0][1].name resource_descriptions[1][0][1].title resource_descriptions[1][0][1].description resource_descriptions[1][0][1].resource_path resource_descriptions[1][0][1].resource_code resource_map[2].resource_id resource_map[2].object_name resource_map[2].object_id resource_map[2].default resource_map[2].sort_order resource_library[2][0].resource_id resource_library[2][0].type_id resource_descriptions[2][0][0].language_id resource_descriptions[2][0][0].name resource_descriptions[2][0][0].title resource_descriptions[2][0][0].description resource_descriptions[2][0][0].resource_path resource_descriptions[2][0][0].resource_code resource_descriptions[2][0][1].language_id resource_descriptions[2][0][1].name resource_descriptions[2][0][1].title resource_descriptions[2][0][1].description resource_descriptions[2][0][1].resource_path resource_descriptions[2][0][1].resource_code"
"insert 558003 testsku 99 1 0 0 0 0.0000 29.5000 1 2011-08-29 75.00 2 40.00 25.00 15.00 0 1 8 1 0 1 0.0000 1 Skinsheen Bronzer Stick ""<p>"
" Bronzes"
Hi. Excel sometimes donot open CSV correctly.
Try free Open Office software
Thank you. Will do.
Actually you can use Excell but it not show delimeter wizard when open so you need to do this in another way
In my excell version I need to open Excell then choose Import select my file and wizard ask about CSV parameters. If just double click and open CSV excell do this wrong way. ::)
http://superuser.com/questions/407082/easiest-way-to-open-csv-with-commas-in-excel