Title: Import Excel to Gravity Forms
Author: wpgear
Published: <strong>2021年7月15日</strong>
Last modified: 2024年12月23日

---

プラグインを検索

![](https://ps.w.org/gf-excel-import/assets/banner-772x250.png?rev=2565247)

このプラグインは **WordPress の最新3回のメジャーリリースに対してテストされていま
せん**。もうメンテナンスやサポートがされていないかもしれず、最新バージョンの WordPress
で使用した場合は互換性の問題が発生する可能性があります。

![](https://ps.w.org/gf-excel-import/assets/icon-256x256.png?rev=2972723)

# Import Excel to Gravity Forms

 作者: [wpgear](https://profiles.wordpress.org/wpgear/)

[ダウンロード](https://downloads.wordpress.org/plugin/gf-excel-import.zip)

 * [詳細](https://ja.wordpress.org/plugins/gf-excel-import/#description)
 * [レビュー](https://ja.wordpress.org/plugins/gf-excel-import/#reviews)
 * [開発](https://ja.wordpress.org/plugins/gf-excel-import/#developers)

 [サポート](https://wordpress.org/support/plugin/gf-excel-import/)

## 説明

An easy and convenient way to bulk load and process large numbers of records in 
GF forms.
 Each record is checked for compatibility of field formats before saving.

If you have a Form in which there are Calculated Fields based on the Values of other
Fields and the need for bulk import of source data, then this Plugin will definitely
be useful to you.

For example. Form Type Calculator:

Field id=2 “A”: Term 1.
 Field id=3 “B”: Term 2. Field id=5 “Ratio”: Coefficient.
Field “Calc”: C = (A + B) * Ratio

When Importing Records, you usually need to prepare all the Values of all Fields:

A; B; Ratio; C. So, to carry out preliminary calculations.

Difficulties begin when branched Inner Logic is used. When there are various additional
Fields for selecting conditions in the form of Lists, Options. (“Gravity Forms” 
allows you to use both built-in Internal Logic in each of the Fields, and connect
JS Scripts with Scripts.)
 Transferring JS Scripts with Scripts to an Excel-prepared
Table can be quite a difficult task. Errors are almost inevitable. Moreover, it 
is necessary to carefully maintain the correspondence of the calculated formulas
in the Table with the Form Algorithms. And if you have changed something in the 
algorithms of the Form, then you again need to change and then test the Formulas
in the Table. Even writing about it is tiresome.

Moreover, some Field Values may have both Value and Format Constraints. In normal
cases, import without checking such Restrictions may lead to an abnormal termination
of the Import process, or to incorrectly filled Fields.
 In any case, manual correction
of Records after such an Import can be costly and resource intensive.

It is for such Tasks that this Plugin is needed.

It is enough to fill in only the Initial Fields.
 In our Example – Fields: A B and
Ratio. Calculated Field “C” will be calculated in each imported Record by the internal
Form algorithms and will be saved.

If some of the Values are out of range, then such a Record will not be saved and
will require correction directly during the Import process.

You can watch and try the [ Demo ](https://wpgear.xyz/import-excel-to-gravity-forms/)
on a real Form.

#### Features

 * Works with PHP 7.4
 * Works with Gravity Forms versions 2.3.3.4 and higher. Tested up to 2.8.17
 * Import entries are lines of a text file (usually CSV) separated by commas.
 * You can choose any other separator.
 * You can navigate through the list of imported records and save only a few of 
   them.
 * Each record is checked for compatibility of field formats before saving.
 * If the Form Fields have internal logic, then each record is processed with this
   logic in mind before being saved.
 * All types of fields are imported: “Text”, “TextArea”, “Number”, “Date”, “Email”,“
   Select”, “MultiSelect”, “Radio”, “CheckBox”.
 * Each Form has its own option “Import Enable”.
 * Works correctly with Cyrillic and other National character encodings.
 * Each Form has its own “Import Enable” option.
 * Works correctly when there are several other GForms on the page.
 * Possibility to choose encoding of CSV file: ‘utf-8’ – default; ‘ISO-8859-1’; ‘
   CP1251’; etc…
 * [PRO Version](https://wpgear.xyz/import-excel-to-gravity-forms-pro/) Features:
 * Ability to select data type (Name / Value) for Fields: “Select”, “MultiSelect”,“
   Radio”, “CheckBox”.
 * Generation of a Template for easy filling of the Import Table. Template – Excel
   file in XLSX format.
 * The Template contains: Field IDs, Fields Name, Type and Prompts for input.
 * Input Prompts contain all Valid Variants for a given Field, given the selected
   data type (Name / Value).

#### Installation

 1. Upload ‘gf-excel-import’ folder to the ‘/wp-content/plugins/’ directory.
 2. Activate the plugin through the ‘Plugins’ menu in WordPress.
 3. If you have any problems – please ask for support.
 4. Sample: In the “gf-excel-import/sample” folder there is a sample CSV file (sample-
    csv-data-import.csv) and an example Form (samle-gf-form.json). The form should 
    be imported using Gravity Forms tools.

## スクリーンショット

[⌊Page with fields "Gravity Forms" and active option "Import Excel to Gravity Forms".⌉⌊
Page with fields "Gravity Forms" and active option "Import Excel to Gravity Forms"
.⌉[

Page with fields “Gravity Forms” and active option “Import Excel to Gravity Forms”.

[⌊"Import Excel to Gravity Forms" interface. Step 1. Button for download CSV file.⌉⌊"
Import Excel to Gravity Forms" interface. Step 1. Button for download CSV file.⌉[

“Import Excel to Gravity Forms” interface. Step 1. Button for download CSV file.

[⌊"Import Excel to Gravity Forms" interface. Step 2. Select CSV file.⌉⌊"Import Excel
to Gravity Forms" interface. Step 2. Select CSV file.⌉[

“Import Excel to Gravity Forms” interface. Step 2. Select CSV file.

[⌊"Import Excel to Gravity Forms" interface. Step 3. Processing records. Navigation.
Save.⌉⌊"Import Excel to Gravity Forms" interface. Step 3. Processing records. Navigation.
Save.⌉[

“Import Excel to Gravity Forms” interface. Step 3. Processing records. Navigation.
Save.

[⌊"Import Excel to Gravity Forms". Settings page.⌉⌊"Import Excel to Gravity Forms".
Settings page.⌉[

“Import Excel to Gravity Forms”. Settings page.

[⌊The "Gravity Forms" settings page with the "Import Excel to Gravity Forms" plugin
activated.⌉⌊The "Gravity Forms" settings page with the "Import Excel to Gravity 
Forms" plugin activated.⌉[

The “Gravity Forms” settings page with the “Import Excel to Gravity Forms” plugin
activated.

## 評価

このプラグインにはレビューがありません。

## 貢献者と開発者

Import Excel to Gravity Forms はオープンソースソフトウェアです。以下の人々がこの
プラグインに貢献しています。

貢献者

 *   [ wpgear ](https://profiles.wordpress.org/wpgear/)

[“Import Excel to Gravity Forms” をあなたの言語に翻訳しましょう。](https://translate.wordpress.org/projects/wp-plugins/gf-excel-import)

### 開発に興味がありますか ?

[コードを閲覧](https://plugins.trac.wordpress.org/browser/gf-excel-import/)するか、
[SVN リポジトリ](https://plugins.svn.wordpress.org/gf-excel-import/)をチェックする
か、[開発ログ](https://plugins.trac.wordpress.org/log/gf-excel-import/)を [RSS](https://plugins.trac.wordpress.org/log/gf-excel-import/?limit=100&mode=stop_on_copy&format=rss)
で購読してみてください。

## 変更履歴

#### 3.20

    ```
    2024.12.23
    * Tested to Gravity Forms 2.9.1
    * Added the possibility of internationalization.
    * Add Translate: Russian
    ```

#### 1.18.1

    ```
    2024.12.10
    * Tested to WP 6.7.1
    * Fix escaping variables
    ```

#### 1.18

    ```
    2023.09.28
    * Change Plugin Images.
    * Tested to WP 6.3.1
    * Tested to Gravity Forms 2.7.10.1
    ```

#### 1.17

    ```
    2022.11.17
    * Fix "Number" type Field processing.
    * Tested up to WP: 6.1.1
    ```

#### 1.16

    ```
    2022.02.11
    * Fix problem with any version MS Excel. Thanks goodmuyis!
    * Tested up to WP: 5.9
    ```

#### 1.15

    ```
    2022.01.13
    * Possibility to choose encoding of CSV file: 'utf-8' - default; 'ISO-8859-1'; 'CP1251'; etc...
    ```

#### 1.14

    ```
    2022.01.10
    * Fixed Conflict of connecting controls when there are several more GForms on the page.
    ```

#### 1.13

    ```
    2021.10.26
    * Fix AJAX processing for non-logged in Users.
    ```

#### 1.12

    ```
    2021.08.02
    * Fix "MultiSelect" type Field on Save.
    * Fix "Radio" type Field on Save.
    ```

#### 1.11

    ```
    2021.07.31
    * Fix AJAX processing.
    ```

#### 1.10

    ```
    2021.07.30
    * Fix "CheckBox" type Field on Save.
    ```

#### 1.9

    ```
    2021.07.30
    * Fix "CheckBox" type Field processing for multiselect choice.
    * Fix "TextArea" type Field processing for Non RTF mode.
    * Updated AJAX answers.
    * Updated Samples.
    ```

#### 1.8

    ```
    2021.07.20
    * Fix Plugin File Name.
    ```

#### 1.7

    ```
    2021.07.20
    * Added check processing Min, Max values for Fields type "Number"
    ```

#### 1.6

    ```
    2021.07.18
    * Fix "Clear_Fields()".
    * Fix "Radio" type Field processing.
    * Fix "CheckBox" type Field processing.
    * Fix "MultiSelect" type Field processing.
    ```

#### 1.5

    ```
    2021.07.16
    * Fix "Paragraph" type Field processing.
    ```

#### 1.4

    ```
    2021.07.16
    * Fix "Paragraph" type Field processing.
    ```

#### 1.3

    ```
    2021.07.15
    * Fix JS Processing.
    ```

#### 1.2

    ```
    2021.07.15
    * Remove phpExcel_7.4 Lib.
    * Fix Internal Path after rename Plugin Name.
    ```

#### 1.1

    ```
    2021.07.13
    * Published in the Repository. Go!
    * Rename from "GF Eexcel Import" to "Import Excel to Gravity Forms"
    ```

#### 1.0

    ```
    2021.07.07
    * Initial release
    ```

## メタ

 *  バージョン **3.20**
 *  最終更新日 **2年前**
 *  有効インストール数 **100+**
 *  WordPress バージョン ** 4.7またはそれ以降 **
 *  検証済み最新バージョン: **6.7.10**
 *  PHP バージョン ** 5.4またはそれ以降 **
 *  言語
 * [English (US)](https://wordpress.org/plugins/gf-excel-import/)
 * タグ
 * [csv](https://ja.wordpress.org/plugins/tags/csv/)[excel](https://ja.wordpress.org/plugins/tags/excel/)
   [forms](https://ja.wordpress.org/plugins/tags/forms/)[GravityForms](https://ja.wordpress.org/plugins/tags/gravityforms/)
   [import](https://ja.wordpress.org/plugins/tags/import/)
 *  [詳細を表示](https://ja.wordpress.org/plugins/gf-excel-import/advanced/)

## 評価

レビューはまだ送信されていません。

[Your review](https://wordpress.org/support/plugin/gf-excel-import/reviews/#new-post)

[すべてのレビューを見る](https://wordpress.org/support/plugin/gf-excel-import/reviews/)

## 貢献者

 *   [ wpgear ](https://profiles.wordpress.org/wpgear/)

## サポート

意見や質問がありますか ?

 [サポートフォーラムを表示](https://wordpress.org/support/plugin/gf-excel-import/)

## 寄付

このプラグインが今後も改善できるよう応援しませんか ?

 [ このプラグインに寄付 ](https://wpgear.xyz/import-excel-to-gravity-forms/)