wpgear

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 <a href="https://wpgear.xyz/import-excel-to-gravity-forms/" rel="nofollow ugc"> Demo </a> on a real Form.
<h4>Features</h4>
<ul>
<li>Works with PHP 7.4</li>
<li>Works with Gravity Forms versions 2.3.3.4 and higher. Tested up to 2.8.17</li>
<li>Import entries are lines of a text file (usually CSV) separated by commas.</li>
<li>You can choose any other separator.</li>
<li>You can navigate through the list of imported records and save only a few of them.</li>
<li>Each record is checked for compatibility of field formats before saving.</li>
<li>If the Form Fields have internal logic, then each record is processed with this logic in mind before being saved.</li>
<li>All types of fields are imported: “Text”, “TextArea”, “Number”, “Date”, “Email”, “Select”, “MultiSelect”, “Radio”, “CheckBox”.</li>
<li>Each Form has its own option “Import Enable”.</li>
<li>Works correctly with Cyrillic and other National character encodings.</li>
<li>Each Form has its own “Import Enable” option.</li>
<li>Works correctly when there are several other GForms on the page.</li>
<li>
Possibility to choose encoding of CSV file: ‘utf-8’ – default; ‘ISO-8859-1’; ‘CP1251’; etc…
<a href="https://wpgear.xyz/import-excel-to-gravity-forms-pro/" rel="nofollow ugc">PRO Version</a> Features:
</li>
<li>Ability to select data type (Name / Value) for Fields: “Select”, “MultiSelect”, “Radio”, “CheckBox”.</li>
<li>Generation of a Template for easy filling of the Import Table. Template – Excel file in XLSX format.</li>
<li>The Template contains: Field IDs, Fields Name, Type and Prompts for input.</li>
<li>Input Prompts contain all Valid Variants for a given Field, given the selected data type (Name / Value).</li>
</ul>
<h4>Installation</h4>
<ol>
<li>Upload ‘gf-excel-import’ folder to the ‘/wp-content/plugins/’ directory.</li>
<li>Activate the plugin through the ‘Plugins’ menu in WordPress.</li>
<li>If you have any problems – please ask for support. </li>
<li>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.</li>
</ol>

Import Excel to Gravity Forms

Bulk Import of Records from Excel (CSV) files for "Gravity Forms" with Validation and Internal Logic support.

Tobias Bäthge

Boost your website with feature-rich tables that your visitors will love!
TablePress is the most popular and highest-rated WordPress table plugin.
<ul>
<li>Easily create, edit, and manage beautiful and modern data tables, no matter if small or large!</li>
<li>Add live sorting, pagination, searching, and more interactivity for your site’s visitors!</li>
<li>Use any type of data, insert images, links, and even math formulas!</li>
<li>Import and export tables from/to Excel, CSV, HTML, and JSON files or URLs.</li>
<li>Embed tables into posts, pages, or other site areas using the block editor, an Elementor widget, or Shortcodes.</li>
<li>All with no coding knowledge needed!</li>
</ul>
Even more great features for you and your site’s visitors and priority email support are available with a Premium license plan of TablePress. <a href="https://tablepress.org/premium/?utm_source=wordpress.org&utm_medium=textlink&utm_content=readme" rel="nofollow ugc">Go check them out!</a>
<h4>More information</h4>
Visit <a href="https://tablepress.org/" rel="nofollow ugc">tablepress.org</a> for more information, take a look at <a href="https://tablepress.org/demo/" rel="nofollow ugc">example tables</a>, or <a href="https://tablepress.org/demo/#try" rel="nofollow ugc">try TablePress on a free test site</a>. For latest news, <a href="https://twitter.com/TablePress" rel="nofollow ugc">follow @TablePress</a> on Twitter/X or subscribe to the <a href="https://tablepress.org/#newsletter" rel="nofollow ugc">TablePress Newsletter</a>.
<h3>How to use TablePress</h3>
After installing the plugin, you can create and manage tables on the “TablePress” screen in the WordPress Dashboard.
To insert a table into a post or page, add a “TablePress table” block in the block editor or a widget in the Elementor page builder and select the desired table or use Shortcodes with other page builders.
Beginner-friendly step-by-step <a href="https://tablepress.org/tutorials/" rel="nofollow ugc">tutorials, guides, and how-tos</a> show how to achieve common and popular tasks with TablePress. 
Examples for common styling changes via “Custom CSS” code can be found on the <a href="https://tablepress.org/faq/" rel="nofollow ugc">TablePress FAQ page</a>. 
You may also add certain features (like sorting, pagination, filtering, alternating row colors, row highlighting, print name and/or description, …) by enabling the corresponding checkboxes on a table’s “Edit” screen.
Even more great features for you and your site’s visitors and priority email support are available with a Premium license plan of TablePress. <a href="https://tablepress.org/premium/?utm_source=wordpress.org&utm_medium=textlink&utm_content=readme" rel="nofollow ugc">Go check them out!</a>

TablePress – Tables in WordPress made easy


Ich nutze das Plugin nun schon eine ganze Weil und bin immer wieder begeistert, wie einfach man damit Tabellen erstellen und einbetten kann. Dazu kommt, dass der Autor immer wieder neue Funktionen einbaut und das Plugin weiterhin kostenfrei bleibt.



I've been using the plugin for a while now and I'm still amazed at how easy it is to create and embed tables. In addition, the author keeps adding new features while the plugin remains free.






Best Plugin when it comes to tables


Working with TablePress has made it easier to manage data especially when working with hundreds of cells.



No way should one ever work with "plain HTML tables" again! :-)


Intuitive!


Developer solved all my problems, created individual code for my needs and explained everything thoroughly. Great job!


GREAT SUPPORT!!


TablePress 3.0 removed backward compatibility with free extensions. Now you need to use paid version in order for things to work. Someone skilled should fork this. 


Backward compatibility removed in favor of paid version

Embed beautiful, accessible, and interactive tables into your WordPress website’s posts and pages, without having to write code!

Import Excel to Gravity Forms vs TablePress – Tables in WordPress made easy