Title: Simple CSV Importer
Author: Apsara Aruna
Published: <strong>2021 年 11 月 27 日</strong>
Last modified: 2025 年 2 月 8 日

---

搜尋外掛

這個外掛**並未在最新的 3 個 WordPress 主要版本上進行測試**。開發者可能不再對這個
外掛進行維護或提供技術支援，並可能會與更新版本的 WordPress 產生使用上的相容性問題。

![](https://s.w.org/plugins/geopattern-icon/simple-csv-importer.svg)

# Simple CSV Importer

 由 [Apsara Aruna](https://profiles.wordpress.org/apsaraaruna/) 開發

[下載](https://downloads.wordpress.org/plugin/simple-csv-importer.1.0.1.zip)

 * [詳細資料](https://tw.wordpress.org/plugins/simple-csv-importer/#description)
 * [使用者評論](https://tw.wordpress.org/plugins/simple-csv-importer/#reviews)
 *  [安裝方式](https://tw.wordpress.org/plugins/simple-csv-importer/#installation)
 * [開發資訊](https://tw.wordpress.org/plugins/simple-csv-importer/#developers)

 [技術支援](https://wordpress.org/support/plugin/simple-csv-importer/)

## 外掛說明

Alternative CSV Importer plugin. Simple and powerful, best for geeks.

 * Category support
 * Tag support
 * Custom field support
 * [Smart Custom Fields](https://wordpress.org/plugins/smart-custom-fields/) support
 * [Custom Field Suite](http://customfieldsuite.com/) support
 * [Advanced Custom Fields](http://www.advancedcustomfields.com/) support
 * Custom Taxonomy support
 * Custom Post Type support
 * Filter hook for dry-run-testing
 * Filter hooks for customize csv data before importing to database
 * Action hook for update post data after importing to database

You can get example CSV files in `/wp-content/plugins/simple-csv-importer/sample`
directory.

#### Available column names and values:

 * `ID` or `post_id`: (int) post id.
    This value is not required. The post ID is
   already exists in your blog, importer will update that post data. If the ID is
   not exists, importer will trying to create a new post with suggested ID.
 * `post_author`: (login or ID) The user name or user ID number of the author.
 * `post_date`: (string) The time of publish date.
 * `post_content`: (string) The full text of the post.
 * `post_title`: (string) The title of the post.
 * `post_excerpt`: (string) For all your post excerpt needs.
 * `post_status`: (‘draft’ or ‘publish’ or ‘pending’ or ‘future’ or ‘private’ or
   custom registered status) The status of the post. ‘draft’ is default.
 * `post_password`: (string) The password to protect the post. The password is limited
   to 20 characters.
 * `post_name`: (string) The slug of the post.
 * `post_parent`: (int) The post parent id. Used for page or hierarchical post type.
 * `menu_order`: (int)
 * `post_type`: (‘post’ or ‘page’ or any other post type name) _(required)_ The 
   post type slug, not labels.
 * `post_thumbnail`: (string) The uri or path of the post thumbnail.
    E.g. http://
   example.com/example.jpg or /path/to/example.jpg
 * `post_category`: (string, comma separated) slug of post categories
 * `post_tags`: (string, comma separated) name of post tags
 * `tax_{taxonomy}`: (string, comma separated) Any field prefixed with `tax_` will
   be used as a custom taxonomy. Taxonomy must already exist. Entries are names 
   or slugs of terms.
 * `{custom_field_key}`: (string) Any other column labels used as custom field
 * `cfs_{field_name}`: (string) If you would like to import data to custom fields
   set by Custom Field Suite, please add prefix `cfs_` to column header name.
 * `scf_{field_name}`: (string) If you would like to import data to custom fields
   set by Smart Custom Fields, please add prefix `scf_` to column header name.
 * `comment_status`: (‘closed’ or ‘open’) Default is the option ‘default_comment_status’,
   or ‘closed’.

Note: Empty cells in the csv file means “keep it”, not “delete it”.
 Note: To set
the page template of a page, use custom field key of `_wp_page_template`. Note: 
If providing a post_status of ‘future’ you must specify the post_date in order for
WordPress to know when to publish your post. Note: If the post_type value is `attachment`,
you can use `post_thumbnail` field to define media URL or path.

#### Advanced Custom Fields plugin integrate

If advanced custom field key is exists, importer will trying to use [update_field](http://www.advancedcustomfields.com/resources/functions/update_field/)
function instead of built-in add_post_meta function.
 How to find advanced custom
field key: [Finding the field key](http://www.advancedcustomfields.com/resources/functions/update_field/#finding-the%20field%20key)

## 安裝方式

 1. Upload All files to the `/wp-content/plugins/` directory.
 2. Activate the plugin through the ‘Plugins’ menu in WordPress.
 3. Go to the Import page under Tools menu.
 4. Click CSV link, read the notification, then just upload and import.

## 常見問題集

### Should I fill all columns of post data?

No. Only columns which you want to update.

### Can I update existing post data?

Yes. Please use ID field to specify the existing post.

### Can I insert post with specific post id?

Yes. Please use ID field to specify the new post ID.

### Can I import custom field/custom taxonomy of the post?

Yes. You can use column names same as wp_post table, but if the column name does
not match, it creates a custom field (post meta) data. Importing custom taxonomy
is a bit more complicated, “tax_{taxonomy}” means, “tax_” is prefix, and {taxonomy}
is name of custom taxonomy (not labels).

Here is an example.

**csv file**
 “post_title”,”singer”,”genre”,”released_date” “Shape of You”,”Ed Sheeran”,”
Pop”, “06-01-2017”

**imported post data**
 Post Title: Shape of You Custom field “singer”: Ed Sheeran
Custom field “genre”: Pop Custom taxonomy “released_date”: 06-01-2017

### Why should I quote text cells when I save csv file?

Because PHP cannot read multibyte text cells in some cases.

> Locale setting is taken into account by this function. If LANG is e.g. en_US.UTF-
> 8, files in one-byte encoding are read wrong by this function.

### Can I insert multiple values to CFS or ACF fields like Select or Checkbox?

Yes. Please create additional plugin and use `simple_csv_importer_save_meta` filter
to make array data.

## 使用者評論

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

## 參與者及開發者

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

參與者

 *   [ Apsara Aruna ](https://profiles.wordpress.org/apsaraaruna/)

[將〈Simple CSV Importer〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/simple-csv-importer)

### 對開發相關資訊感興趣？

任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/simple-csv-importer/)、
查看 [SVN 存放庫](https://plugins.svn.wordpress.org/simple-csv-importer/)，或透過
[RSS](https://plugins.trac.wordpress.org/log/simple-csv-importer/?limit=100&mode=stop_on_copy&format=rss)
訂閱[開發記錄](https://plugins.trac.wordpress.org/log/simple-csv-importer/)。

## 變更記錄

#### 1.0.0

 * Fresh copy

## 中繼資料

 *  版本 **1.0.1**
 *  最後更新 **1 年前**
 *  啟用安裝數 **60+**
 *  WordPress 版本需求 ** 5.4 或更新版本 **
 *  已測試相容的 WordPress 版本 **6.7.5**
 *  語言
 * [English (US)](https://wordpress.org/plugins/simple-csv-importer/)
 * 標籤:
 * [acf](https://tw.wordpress.org/plugins/tags/acf/)[cfs](https://tw.wordpress.org/plugins/tags/cfs/)
   [csv](https://tw.wordpress.org/plugins/tags/csv/)[custom posts](https://tw.wordpress.org/plugins/tags/custom-posts/)
   [importer](https://tw.wordpress.org/plugins/tags/importer/)
 *  [進階檢視](https://tw.wordpress.org/plugins/simple-csv-importer/advanced/)

## 評分

這個項目尚無任何評論記錄。

[Your review](https://wordpress.org/support/plugin/simple-csv-importer/reviews/#new-post)

[查看全部使用者評論](https://wordpress.org/support/plugin/simple-csv-importer/reviews/)

## 參與者

 *   [ Apsara Aruna ](https://profiles.wordpress.org/apsaraaruna/)

## 技術支援

使用者可在技術支援論壇提出意見反應或使用問題。

 [檢視技術支援論壇](https://wordpress.org/support/plugin/simple-csv-importer/)

## 贊助

想要支援這個外掛的發展嗎？

 [ 贊助這個外掛 ](https://profiles.wordpress.org/apsaraaruna/)