For awhile I’ve been looking for the best way to import CSV data into WordPress. So far, CSV Importer does pretty much everything I need.
After installing CSV Importer, you simply take your CSV file and add column titles such as,
csv_post_title - title of the post
csv_post_post - body of the post
csv_post_type - post, page or a custom post type.
csv_post_excerpt - post excerpt
It doesn’t matter what order you have the columns in as long as the column titles are correct. Moreover, CSV Importer assumes any column title that doesn’t begin with csv_ is a custom field, so you can import custom field data, and there’s a setting to import custom post data as well. Most fields are optional as well, so you could just import a single column of data just using the csv_post_title if you wanted to.
CSV Importer will let you mark the posts created as a result of the import as Drafts, so I took a Google Spreadsheet that I’ve wanted to import into my lifestream, added the column titles and massaged the data a bit, then hit import. It worked like a charm.
The only downside is CSV Importer requires PHP 5 and some folks might still be stuck on virtual servers still using PHP 4. Other than that, this is an awesome plugin that again reflects the strengths of WordPress and its developer community.