Nabel, what data do you have (products, categories, orders, customers, etc)? If you know .NET you could create a script that inserts these items into the db using these calls. You could also theoretically create SQL queries in the spreadsheet itself as an insert statement for each line, but with certain things when they're created they're actually inserted in more than one table, so it's just something to watch out for. If they're products you're trying to import, you'll need to be concerned about inventory, images, and categorization. We're actually working on a customization for a client right now that takes a spreadsheet and allows them to import products....

Actually we have to insert product data in tables, now i don't know whether system automatically generate primary keys where needed. or i have to insert these manually. and also these unique keys are like "GJ23HF4U5543H65GTI" mean to say looking no format.

thanks for any help.