This is a beginner’s tutorial designed to help new users quickly get started with WP Bulker. After completing the tutorial, you will be able to connect sites, prepare spreadsheets, create import or export tasks, and review task results independently.
Before starting this tutorial, please register and sign in to your WP Bulker account, then open the Dashboard.
1. Overview
Overview is the home page of the workspace. It summarizes connected resources, recent task activity, and basic account information.
Overview metrics:
WordPress sites: The number of WordPress sites currently connected.
Google connections: The number of Google accounts currently connected.
Active jobs: The number of bulk Post import or export tasks currently in progress.
Runs this month: The number of task runs recorded this month.
Quick start section: Guides you through the recommended sequence for quickly running a bulk Post import or export task.
Screenshot placeholder — Overview page screenshot
2. WordPress Sites
This feature is used to connect and manage the WordPress sites involved in bulk Post import and export tasks.
How to connect a WordPress site
Click WordPress Sites > Add site.
Enter the WordPress Admin URL, WordPress username, and Application Password.
WordPress Admin URL:
The WordPress Admin URL is the address you use to sign in to the WordPress admin area. You do not need to include
/wp-admin/.For example, if your WordPress admin URL is:
https://seo-wp.example.com/wp-admin/You should enter:
https://seo-wp.example.comIf your WordPress admin URL is:
https://seo-wp.example.com/fr/wp-admin/You should enter:
https://seo-wp.example.com/frThese are treated as two different URLs. We use the WordPress Admin URL to determine the number of websites. For example, if three multilingual websites use the same WordPress Admin URL, they are counted as one website. If the three multilingual websites use three different WordPress Admin URLs, they are counted as three websites.
WordPress username:
The WordPress username is the username you use to sign in to the WordPress admin area. The user must have the Administrator, Editor, or Author role.
Application Password:
A WordPress Application Password is a dedicated password provided by WordPress. It allows third-party applications or software to securely access your website. It is different from the password you use to sign in to the WordPress admin area.
How to obtain an Application Password
Sign in to the WordPress admin area.
Click Users > select the username > open the Profile page.
Scroll to the bottom of the page and find Application Passwords.
Enter a name that identifies the purpose, date, or other details of the password.
Click Add Application Password.
WordPress will generate a dedicated password. Copy and save it immediately because you will not be able to view it again after leaving the page.
Click Connect site.
WP Bulker verifies the connection before saving the site. After the site is connected, users, categories, and other supported resources are loaded in the background.
Screenshot placeholder — Connecting a WordPress site
Managing connected sites
After a site is successfully connected, click the Manage site button on its card to open the site management page.
The following actions are available:
Refresh resources: Reload users, categories, and related resource data.
Users: View all currently cached usernames and their IDs.
Categories: View all currently cached category names and their IDs.
Export Users / Export Categories: Export all currently cached usernames or category names and their IDs. We recommend selecting Refresh resources before exporting to ensure that the user or category data is up to date.
Test connection: Check whether the currently saved credentials are still valid.
Update credentials: Update the WordPress username or Application Password if either one changes.
Disable site: Temporarily disable the site. After the site is disabled, the button changes to Restore site. Click Restore site to enable the site again.
Remove site: Delete the saved credentials and resource cache. Previous task records will still be retained.
Screenshot placeholder — WordPress site management
3. Google Sheets
This feature is used to connect and manage the Google Sheets spreadsheets used in bulk import and export tasks.
If you use Google Sheets to bulk import or export Posts, you must authorize Google Sheets here. If you use a local spreadsheet to bulk import or export Posts, authorization is not required. You can drag the file directly into the designated upload area.
How to connect Google Sheets
Click Google Sheets > Connect Google account, then complete the Google authorization process.
Return to WP Bulker and confirm that the account status is Connected.
Click Add spreadsheet to open the selection window. Select the spreadsheet you want to use, then click Select.
After it is successfully added, the spreadsheet will appear in the Selected spreadsheets section.
Managing Google Sheets
Refresh spreadsheet information:
A refresh button appears to the right of Selected spreadsheets.
Each spreadsheet displays its spreadsheet name and the names of all Sheets inside it. If you rename the spreadsheet or any Sheet in Google Sheets, click this button to synchronize the latest names.
Remove a spreadsheet:
To remove a spreadsheet, click “···” > Remove.
Disconnect authorization:
Clicking Disconnect deletes the locally saved Google credentials and stops related unfinished operations. Historical records will still be retained.
Screenshot placeholder — Google Sheets authorization
4. Bulk Post import
This feature is used to bulk import WordPress Posts. Import records are displayed below this page. You can review and filter the import records, and you can open the details of each import record.
How to bulk import WordPress Posts
Click Bulk Post import > New import to open the configuration window.
You can upload a local XLSX, XLS, or CSV file, or select a Google Sheets spreadsheet to bulk upload WordPress content from the spreadsheet to WordPress. In the task window, click template.xlsx to download the import spreadsheet template.
The template uses the following format:
Columns A–D use the following fixed English headers:
slug,title,content,excerptDo not change the names or order of columns A–D.
The slug and title fields are required.
You can add your own notes in column E and any following columns. These columns will not be imported.
XLSX, XLS, CSV, and Google Sheets use the same column structure.
Configure the import
After selecting a spreadsheet, configure the import details in the card below Import configuration.
(You can click Add site to add another configuration. A task supports up to 10 configurations, so you can import Posts to up to 10 websites at the same time. All configurations combined can import up to 5,000 WordPress Posts in a single task. An import creates new WordPress Posts and does not overwrite existing content with the same slug.)
Configure the following import information:
WordPress site: Select the website to which the Posts will be imported.
Default author: Select the author of the Posts.
Default categories: Select the categories for the Posts.
Sheet: Select the Sheet containing the Posts.
Row range: Select the row range containing the Posts. Row 1 is always used as the header, so the data must start from row 2 or later. It is not recommended to leave the end row empty.
Status: Select the status the Posts will have after they are uploaded, such as Draft, Pending review, or Publish.
Click Start import.
After the task is created, WP Bulker redirects you to the task details page and automatically performs validation and execution in the background.
Therefore, the bulk Post import feature allows you to import one or more batches of Post data—including slug, title, content, excerpt, author, categories, and status—to one or more selected websites.
5. Bulk Post export
This feature is used to bulk export WordPress Posts. Import records are displayed below this page. You can review and filter the import records, and you can open the details of each import record.
How to bulk import WordPress Posts
Click Bulk Post export > New export to open the configuration window.
You can export to a local XLSX, XLS, or CSV file, or to a Google Sheets spreadsheet. All formats use the same column structure.
Exporting to a local file creates a new file. In the task window, click template.xlsx to download the export spreadsheet template.
The exported data includes:
slug title content excerpt author categories tags source_site post_type status permalinkConfigure the export
After selecting a spreadsheet, configure the export details in the card below Export configuration.
(You can click Add site to add another configuration. A task supports up to 10 configurations, so you can bulk export Posts from up to 10 websites at the same time. All configurations combined can export up to 5,000 WordPress Posts in a single task.)
Configure the following export information:
WordPress site: Select the website from which Posts will be exported.
Sheet: Enter the name of the Sheet where the exported Posts will be saved.
Slug: Enter or select the slugs of the Posts to export. Three configuration methods are available:
Enter slugs: Manually enter slugs, separated by line breaks or commas.
Selected Posts: Displays all Posts on the website. You can filter the list and select the Posts you want to export.
All Posts: Export all Posts at once, or export all Posts with a specific status.
Click Start import.
After the task is created, WP Bulker redirects you to the task details page and automatically performs validation and execution in the background.
Therefore, the bulk Post export feature allows you to export Post information from one or more websites to one or more spreadsheets.
6. Usage & Plan
This section allows you to view your account details and paid invoices, and submit a refund request within 7 days.
7. Account settings
This section allows you to view your personal information, including your username, registered email address, registration date, and sign-up method.