add_action( 'admin_notices', function() {
$path = wp_upload_dir( '2022/12' );
$file_handle = fopen( $path['path'] . '/myfilename.csv', 'r' );
if( ! $file_handle ) {
return;
}
// Get Header
$header = fgetcsv( $file_handle );
// Loop Rows
while( $row = fgetcsv( $file_handle ) ) {
// Diagnostics - Comment Out After Testing
echo $row[0] . ' '; continue;
// Insert WordPress Post
wp_insert_post(
[
'post_title' => $row[0],
'post_content' => $row[1],
'post_type' => 'post',
'post_status' => 'publish',
]
);
}
fclose( $file_handle );
} );
Import CSV to blog posts
Loads a CSV file from the Media Library and imports rows into WordPress Posts.
How to use
- Log into a staging, development, or locally hosted clone of your site
- Install and activate Code Snippets
- WP Admin > Snippets > Add New
- Copy and paste the code from the Description tab above
- Check to ensure formatting came over properly and no syntax errors show up in the editor
- Customize the code as desired
- Add a meaningful title
- Select whether to run on front-end or back-end (or both)
- Click “Save and Activate”
- Test your site to ensure it works
- Disable if any problems, or recover
- Repeat for live environment
License
All code snippets are licensed GPLv2 (or later) matching WordPress licensing.
Disclaimer of warranty:
Except when otherwise stated in writing the copyright holders and/or other parties provide the program as-is without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose.
Support
- Describe the issue and what you’ve observed.
- Describe your expected outcome(s).
- List steps to reproduce the issue.
- Optionally provide screen-shot or video URLs.
- Email to [email protected]
Partners
