I used the export all products dataflow as a template then started modifying it from there. Put configurable product at the end.
Added + in front of image url so that it will not add as exclude image http://magento.stackexchange.com/questions/29891/magmi-images-excluded
added 3 columns: media_gallery,super_products_sku,configurable_attributes http://stackoverflow.com/questions/16166425/magmi-importing-configurable-product
Used magmi to import the csv http://sourceforge.net/projects/magmi/
in magmi enabled itemprocessors, “Magmi Optimizer, Magmi Magento Reindexer, Image attriutes processor, On the fly indexer, Configurable Item Processor”
BTW this was done on Magento 1.9.x
copy and paste as csv file and open in csv viewer like openoffice or excel
store,websites,attribute_set,type,category_ids,sku,has_options,name,meta_title,meta_description,image,small_image,thumbnail,gallery,url_key,url_path,custom_design,page_layout,options_container,image_label,small_image_label,thumbnail_label,country_of_manufacture,msrp_enabled,msrp_display_actual_price_type,gift_message_available,gift_wrapping_available,color,status,is_recurring,visibility,tax_class_id,occasion,apparel_type,sleeve_length,fit,size,length,gender,description,short_description,meta_keyword,custom_layout_update,special_from_date,special_to_date,news_from_date,news_to_date,custom_design_from,custom_design_to,price,special_price,weight,msrp,gift_wrapping_price,qty,min_qty,use_config_min_qty,is_qty_decimal,backorders,use_config_backorders,min_sale_qty,use_config_min_sale_qty,max_sale_qty,use_config_max_sale_qty,is_in_stock,low_stock_date,notify_stock_qty,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,stock_status_changed_auto,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,stock_status_changed_automatically,use_config_enable_qty_increments,product_name,store_id,product_type_id,product_status_changed,product_changed_websites,website,_media_image,_media_lable,_media_position,_media_is_disabled,media_gallery,super_products_sku,configurable_attributes
admin,base,Clothing,simple,,taka012c-Royal Blue-L,0,taka Knit Top-Royal Blue-L,,,+http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,,taka-knit-top-royal-blue-l,taka-knit-top-royal-blue-l.html,,1 column,Product Info Column,,,, ,Use config,Use config,No,No,Royal Blue,Enabled,No,Not Visible Individually,Taxable Goods,Casual,Knits,Short Sleeve,,L,,Female,”Loose fitting from the shoulders, open weave knit top. Semi sheer. Slips on. Faux button closure detail on the back. Linen/Cotton. Machine wash.”,The demure taka Knit features a semi sheer open weave and a forgiving silhouette. A nude camisole underneath keeps a stylish but conservative look.,,,3/1/13 0:00,,3/1/13 0:00,,,,210,,1,,,100,0,1,0,0,1,1,1,0,1,1,,,1,0,1,0,1,0,1,0,0,0,1,taka Knit Top-Royal Blue-L,0,simple,,,,,,,,/1/_/1_3.jpg;/2/_/2_2.jpg;/3/_/3_2.jpg;/4/_/4_2.jpg;/5/_/5_2.jpg,,
admin,base,Clothing,simple,,taka012c-Royal Blue-M,0,taka Knit Top-Royal Blue-M,,,+http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,http://dreamatico.com/data_images/girl/girl-8.jpg,,Taka-knit-top-royal-blue-m,Taka-knit-top-royal-blue-m.html,,1 column,Product Info Column,,,, ,Use config,Use config,No,No,Mint,Enabled,No,Not Visible Individually,Taxable Goods,Casual,Knits,Short Sleeve,,M,,Female,”Loose fitting from the shoulders, open weave knit top. Semi sheer. Slips on. Faux button closure detail on the back. Linen/Cotton. Machine wash.”,The demure taka Knit features a semi sheer open weave and a forgiving silhouette. A nude camisole underneath keeps a stylish but conservative look.,,,3/1/13 0:00,,3/1/13 0:00,,,,210,,1,,,100,0,1,0,0,1,1,1,0,1,1,,,1,0,1,0,1,0,1,0,0,0,1,taka Knit Top-Royal Blue-M,0,simple,,,,,,,,/1/_/1_3.jpg;/2/_/2_2.jpg;/3/_/3_2.jpg;/4/_/4_2.jpg;/5/_/5_2.jpg,,
admin,base,Clothing,configurable,”10,11″,taka012c,1,taka Knit Top,,,+http://7-themes.com/data_images/out/75/7030450-miranda-kerr-smile-girl.jpg,http://7-themes.com/data_images/out/75/7030450-miranda-kerr-smile-girl.jpg,http://7-themes.com/data_images/out/75/7030450-miranda-kerr-smile-girl.jpg,,taka-knit-top,taka-knit-top-1046.html,,1 column,Product Info Column,,,, ,Use config,Use config,No,No,,Enabled,,”Catalog, Search”,Taxable Goods,Casual,Knits,Short Sleeve,,,,Female,”Loose fitting from the shoulders, open weave knit top. Semi sheer. Slips on. Faux button closure detail on the back. Linen/Cotton. Machine wash.”,The demure taka Knit features a semi sheer open weave and a forgiving silhouette. A nude camisole underneath keeps a stylish but conservative look.,,,3/1/13 0:00,,3/1/13 0:00,,,,210,,,,,0,0,1,0,0,1,1,1,0,1,1,,,1,0,1,0,1,0,1,0,0,0,1,taka Knit Top,0,configurable,,,,,,,,https://pbs.twimg.com/profile_images/378800000767456340/d2013134969a6586afd0e9eab6b0449b.jpeg::taka012c;http://f9view.com/wp-content/uploads/2014/05/Cute-Australian-Girl-Mobile-HD-Wallpapers.jpg::taka012c;,”taka012c-Royal Blue-L,taka012c-Royal Blue-M”,”size,color”
