wpgear

<p>An easy and convenient way to bulk load and process large numbers of records in GF forms.<br />
Each record is checked for compatibility of field formats before saving.</p>
<p>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.</p>
<p>For example. Form Type Calculator:</p>
<p>Field id=2 “A”: Term 1.<br />
Field id=3 “B”: Term 2.<br />
Field id=5 “Ratio”: Coefficient.<br />
Field “Calc”: C = (A + B) * Ratio</p>
<p>When Importing Records, you usually need to prepare all the Values of all Fields:<br />
A; B; Ratio; C.<br />
So, to carry out preliminary calculations.</p>
<p>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.)<br />
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.</p>
<p>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.<br />
In any case, manual correction of Records after such an Import can be costly and resource intensive.</p>
<p>It is for such Tasks that this Plugin is needed.</p>
<p>It is enough to fill in only the Initial Fields.<br />
In our Example – Fields: A B and Ratio.<br />
Calculated Field “C” will be calculated in each imported Record by the internal Form algorithms and will be saved.</p>
<p>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.</p>
<p>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.</p>
<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>
<p>Possibility to choose encoding of CSV file: ‘utf-8’ – default; ‘ISO-8859-1’; ‘CP1251’; etc…</p>
<p><a href="https://wpgear.xyz/import-excel-to-gravity-forms-pro/" rel="nofollow ugc">PRO Version</a> Features:</p>
</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.

GravityKit

Doeke Norg

<blockquote>
<h3>GravityExport (Gravity Form Entries in Excel) is the ultimate no-hassle solution for exporting data from Gravity Forms.</h3>
<p>Powerful new functionality is available with GravityExport! Save exports to FTP & Dropbox, export as PDF, and format exports for data analysis.</p>
<p><a href="https://www.gravitykit.com/extensions/gravityexport/?utm_source=plugin&utm_campaign=gravityexport-lite&utm_content=readme-learn-more" rel="nofollow ugc">Learn more about GravityExport</a></p>
</blockquote>
<h3>Export entries using a secure URL</h3>
<p>When you configure a new export, the plugin will generate a secure download URL that you can share with anyone who needs the data (No need to log in!). Reports will automatically update as new entries are added.</p>
<h4>GravityExport Lite includes many features:</h4>
<ul>
<li>Limit access to downloads—either make a URL public or require users to be logged-in with correct permissions</li>
<li>Download reports from multiple forms at once</li>
<li>Export entry notes along with entries</li>
<li>Transpose data (instead of one entry per-row, it would be one entry per column)</li>
<li>Attach entry exports to notifications</li>
</ul>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/diqNgFCguM4?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<h3>Export Gravity Forms entries directly to Excel (.xlsx)</h3>
<p>Export your entries directly to .xlsx format. No more wasting time importing your CSV files into Excel and re-configuring columns.</p>
<h3>Export Gravity Forms submissions as CSV</h3>
<p>If you’d prefer to have your reports generated as CSV, GravityExport Lite makes it easy.</p>
<h3>Add search filters to the URL</h3>
<p>Once you have your download URL, you can easily <a href="https://gfexcel.com/docs/filtering/" rel="nofollow ugc">filter by date range and field value</a>.</p>
<h3>Configure export fields</h3>
<p>Save time generating exports in Gravity Forms: Configure the fields that are included in your CSV or Excel export. No need to set up every time!</p>
<h3>Documentation & support</h3>
<p>If you have any questions regarding GravityExport Lite, <a href="https://docs.gravitykit.com/category/791-gravityexport?utm_source=plugin&utm_campaign=gravityexport-lite&utm_content=readme-checkout-docs" rel="nofollow ugc">check out our documentation</a>.</p>
<p>If you need further assistance, <a href="https://wordpress.org/support/topic/read-me-first-9/" rel="ugc">read this first</a> and our support team will gladly give you a helping hand!</p>
<h4>Requirements</h4>
<ul>
<li>PHP 7.2</li>
<li><code>php-xml</code> and <code>php-zip</code> libraries. The plugin will check for those.</li>
<li>Gravity Forms 2.5 or higher</li>
</ul>
<h3>Gain additional powerful functionality</h3>
<p>The <a href="https://www.gravitykit.com/extensions/gravityexport/?utm_source=plugin&utm_campaign=gravityexport-lite&utm_content=readme-full-version" rel="nofollow ugc">full version of GravityExport</a> unlocks these game-changing features:</p>
<ul>
<li>📄 <strong>PDF Export</strong><br />
GravityExport supports exporting entries as PDF! You can choose to have a PDF generated for each entry or one PDF that includes all entries. You can also customize the PDF output by adjusting the size, orientation, and more.</li>
<li>📦 <strong>Dropbox integration</strong><br />
Save your form data directly to Dropbox.</li>
<li>👩🏽‍💻 <strong>Send reports to FTP</strong><br />
Store reports on your own FTP server! GravityExport supports the SFTP, FTP + SSL, and FTP protocols.</li>
<li>⬇️ <strong>Multiple download URLs</strong><br />
Create multiple export URLs that output to different formats and include different fields.</li>
<li>📊 <strong>Export data ready for analysis</strong><br />
Make it easier to process your Gravity Forms data by splitting fields with multiple values into different rows.</li>
</ul>
<p>We’ve written an article that contains all you need to know about <a href="https://www.gravitykit.com/exporting-gravity-forms-to-excel/?utm_source=plugin&utm_campaign=gravityexport-lite&utm_content=readme-all-need-to-know" rel="nofollow ugc">exporting data from Gravity Forms</a>.</p>
<h4>Credits</h4>
<ul>
<li>The GravityExport Lite plugin was created by <a href="https://doeken.org" rel="nofollow ugc">Doeke Norg</a></li>
</ul>


GravityExport Lite for Gravity Forms

Thank you

Export all Gravity Forms entries to Excel (.xlsx) or CSV via a download button or a secret shareable URL.

Import Excel to Gravity Forms vs GravityExport Lite for Gravity Forms