Post Importer for Excel

外掛說明

Post Importer for Excel streamlines your content creation workflow by allowing you to bulk-create posts from a spreadsheet. Simply prepare your data in a CSV or Excel file, map your columns to WordPress post fields like title, content, featured image, categories, and tags, then preview and publish.

The plugin intelligently attempts to map your columns automatically and provides a user-friendly interface to review and edit posts before they go live. You can publish posts individually or all at once with the batch creation tool.

Key Features:
* Upload data from Excel (.xlsx) or CSV (.csv) files.
* Automatic column mapping for common fields (title, content, image, categories, etc.).
* Manual column mapping for full control.
* Preview and edit posts before creation.
* Set featured images from URLs in your file.
* Assign categories and tags.
* Publish posts one-by-one or in a batch.

安裝方式

  1. Upload the post-importer-for-excel folder to the /wp-content/plugins/ directory.
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.
  3. Navigate to ‘Import to Post’ in the WordPress admin menu to start using the plugin.

常見問題集

What’s the required format for the Excel/CSV file?

Your file must have a header row (the first row) with names for each column.

What columns can I include in my file?

The plugin can automatically detect and map the following columns (case-insensitive):
* title: The post title.
* content: The post content.
* image_url, image, or featured image: The full URL to the featured image.
* alt: Alt text for the featured image.
* caption: Caption for the featured image.
* description: Description for the featured image.
* categories: A comma-separated list of category names (e.g., “News, Tech”).
* tags: A comma-separated list of tag names (e.g., “import, wordpress”).

If your columns have different names, you can map them manually after uploading.

What happens if a category or tag doesn’t exist?

The plugin will automatically create any categories that do not already exist. Tags are also added automatically.

Can I edit the posts before they are created?

Yes! After you map the columns, the plugin will show you a preview of all the posts. You can review and edit the title, content, and other fields for each post on this screen before publishing.

How does the batch creation work?

On the preview screen, you can select which posts you want to create using the checkboxes. Then, click the “Create Selected Posts” button. The plugin will process them in the background and show you the progress.

Where are the log files stored?

If WP_DEBUG is enabled, the plugin creates daily log files in a dedicated folder within your WordPress uploads directory (/wp-content/uploads/pife-logs/).

使用者評論

這個外掛目前沒有任何使用者評論。

參與者及開發者

以下人員參與了開源軟體〈Post Importer for Excel〉的開發相關工作。

參與者

將〈Post Importer for Excel〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

1.0

  • Initial release.