xl2wp

This is a wordpress plug-in and requries a functional WordPress instalation of version 2.9.1 or higher (Tested upto version 3.2.1).
Use this plug-in to import your excel sheet data into wordPress as post or page.

Unzip and upload the xl2wp folder to your WordPress plug-in folder. Activate the plug-in through the WordPress admin panel.

Prepare your excel file.
A sample file can be found under the sample directory. You may also download the sample file and the template file from this website for FREE.
Mandatory fields: wp_title, wp_post_date, wp_post_type, wp_content, wp_excerpt, wp_tags, aioseo_title, aioseo_description, aioseo_keyword (All in one SEO plug-in title, description and keyword. You may fill the wp_content, wp_excerpt, wp_tags fields, aioseo_title, aioseo_description and aioseo_keyword with zero if you don't want any data in there! But those columns should be present in the excel file.)
Optional fields: cat_1, cat_2, cat_3, cat_4, cat_5 (Categories -> Prefix with "cat_". Theoritically, can have any amount of categories. cf_key-1, cf_key-2, cf_key-3, cf_key-4, cf_key-5 (Custom fields -> prefix with "cf_", Again you can have any amount of custom fields. Within custom fields use "_" only after prefix. Use "-" within key value if nessesary.)
Fill the empty fields with "0" (ZERO - Mandatory)
Save the file as yourfile.xml - use "SAVE AS" command from file menu and select *.xml for file type within excel dialog
Locate the file within the xl2wp plug-in and process . . .

xl2wp - Excel to WordPress