Import of multiple posts to WordPress with the use of Excel, Word and Ultimate CSV Importer Free

Steps to import multiple posts to WordPress with the use of Excel, Word and Ultimate CSV Importer Free

Step 1

Find the content you would like to upload from your social media profile or anywhere else.

Step 2

Use Microsoft Word, open existing word file : ‘word_to_html_source.docx’, delete previous content (if any), copy and edit your new content (paragraphs, spaces, bold or italic words) and save the file.

Step 3

Open excel file ‘wordpress_database_schema.xlsm’ and press the button ‘Add <div> to word file’. This will create a new file : ‘word_to_html_target.docx’. Open it and copy the content of the file into the ‘post_content’ column. Step 3 is important if you want to keep the styling of the content.

Step 4

Go to sheet ‘field_values’, find table with column names ‘post_title’ and ‘post_name’ and type your content accordingly.

Return to sheet ‘wp_posts’ and complete the necessary columns. Begin with selecting from drop down lists, the ‘post_title’ and ‘post_name’.

Step 5

When you finish with completing the columns, press the button ‘Export to New Excel file – Selected Posts’ and only selected posts (‘post_selected_to_export’ = yes) will be saved to excel file : ‘NewExcelWorkbook_with_Wordpress_posts.xlsx’

Step 6

Open the excel file : ‘NewExcelWorkbook_with_Wordpress_posts.xlsx’ with LIBRE OFFICE and save it as csv file : ‘NewExcelWorkbook_with_Wordpress_posts.csv’

Step 7

Use the WordPress plugin : ‘Ultimate CSV Importer Free’ to import the csv file : ‘NewExcelWorkbook_with_Wordpress_posts.csv’. Go to Import and follow the steps to import the posts. When you finish, all imported posts will be available to all visitors of your website or blog.