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.

SpreadsheetConverter

Import Spreadsheets from Microsoft Excel is a WordPress plugin that allows you to import live, calculating spreadsheets from Microsoft Excel to your blog or website in WordPress. The plugin is free but the calculating web page must have been generated with a paid license for <a href="http://www.spreadsheetconverter.com/" title="Link to the SpreadsheetConverter web site" rel="nofollow ugc">SpreadsheetConverter</a>, an add-in for Excel that converts the Excel spreadsheet to HTML and the formulas in Excel to JavaScript. The uploaded online spreadsheet is live and looks and feels exactly like in Excel. Now you can use Excel everywhere!
SpreadsheetConverter works like an Excel compiler creating live online spreadsheets in HTML and JavaScript. It is not a simple Excel viewer; the web spreadsheet plugin runs all your formulas in real-time – all the cells and charts are live!
You usually need to have your own WordPress server to install plugins. It may not be possible to install plugins on WordPress.com or other shared WordPress servers. If you are unable to use this plugin, you can use our <a href="https://help.spreadsheetconverter.com/support/online-help/publish-to-cloud" title="Link to the Publish to Cloud help page" rel="nofollow ugc">Publish to Cloud</a> service instead. It is built into SpreadsheetConverter and uploads the calculator to a cloud server. In most cases, this works just as well.
Note: before you upload a spreadsheet, you must use <a href="http://www.spreadsheetconverter.com/" title="Link to the SpreadsheetConverter web site" rel="nofollow ugc">the SpreadsheetConverter add-in for Microsoft Excel</a> to convert your spreadsheet to web format. To use this add-in, you must have Microsoft Excel 2007 or later for Windows – and the basic skills to create spreadsheets with it. Prices for unlimited, lifetime licenses for the current version start at $254. There are no extra fees per server, month, page or visitor.
We’d love to help you try SpreadsheetConverter on one of your own spreadsheets. You don’t have to install the software to test it. Just send one of your own spreadsheets, and we’ll send it back as a live, intelligent web form or calculator. Use <a href="https://www.spreadsheetconverter.com/news/free-demo/" title="Link to the free-trial information page for for SpreadsheetConverter" rel="nofollow ugc">the online form</a> and remember to attach the spreadsheet!
This service is free, because it’s so simple to convert your spreadsheet to web format with SpreadsheetConverter that we can do it in almost no time at all. If you want to keep your web calculator or form up-to-date without ever installing or learning the converter, you can have us do all the conversion work for you, forever, using <a href="https://www.spreadsheetconverter.com/products/one-calculating-web-form-from-an-excel-sheet/" title="Link to the product page for paid one-time conversions" rel="nofollow ugc">the paid conversion service</a>.
SpreadsheetConverter is an advanced product that may require some time to learn. If you don’t want to invest in this new skill set right now, you can test the plugin right now with example files in the plugin’s ZIP file – read more below.
Please don’t post negative reviews until you have at least read the FAQ. Even better: contact support for any difficulties you have; we will help you get started for free!
<h4>Insert a live spreadsheet in your blog with just a few clicks</h4>
Any Excel spreadsheet can be published on the web:
<ul>
<li>Open the spreadsheet in Excel and click Convert on the SpreadsheetConverter toolbar to have the Excel converter create a web spreadsheet. </li>
<li>Click WordPress Plugin on the SpreadsheetConverter toolbar to create an SSC Calculator file with everything you will need in WordPress.</li>
<li>Use this plugin to upload the SSC Calculator file to WordPress. </li>
<li>Embed the calculator or form into one or more of your posts or pages in WordPress. </li>
<li>Click Publish in WordPress and your calculator goes live, online on the web!</li>
</ul>
Please visit the Embed a spreadsheet in WordPress, FAQ and Screenshots sections for more detailed instructions.
A full online help for the plugin is available <a href="http://help.spreadsheetconverter.com/support/online-help/help-wordpress-plugin-to-import-spreadsheets-from-microsoft-excel" title="Link to the SpreadsheetConverter online help for the plugin" rel="nofollow ugc">on the SpreadsheetConverter website</a>.
<h4>Create beautiful web apps</h4>
At last you can create online calculators for your website without the help of a programmer. All you need is Microsoft Excel. Help your visitors do a better job, and they will return to your website for more.
<ul>
<li>Price calculation: Online pricing calculators help your customers get the total price including options, maintenance etc.</li>
<li>Financial calculation: provide online mortgage calculators, interest calculation, loan calculators or online lease calculation.</li>
<li>Calculators for government and counties: online income tax calculation, online social benefits, online payroll calculators.</li>
<li>ROI: Use online return on investment calculation to better show the benefits of your product, or calculate internal rate of return (IRR).</li>
<li>Technical and engineering calculators: online dimensioning tools, online HVAC calculations, load calculators, concrete calculation, torque calculation, area calculators, volume calculation, electrical calculation, power calculation.</li>
<li>Health calculators: online body mass index calculator, online calorie calculation, online body fat calculator.</li>
</ul>
You can use any feature of Excel on the web, including formulas and functions, to validate data entry, select intelligent default values or show customized images or maps.
<ul>
<li>Create mobile-friendly, responsive calculators that automatically adapt to different screen widths, portrait/landscape orientation etc.</li>
<li>Embed xls files with smart table lookup in an unlimited number of background data tables.</li>
<li>Use graphical widgets like buttons and sliders to make the calculator easier to use.</li>
<li>Use advanced data validation including Excel’s Data Validation presets. </li>
<li>Show live graphs that automatically update when values are changed.</li>
<li>Upload spreadsheets to any standard web server.</li>
<li>With Real-time Sync, two or more persons can collaborate on an advanced calculation in real-time.</li>
<li>Fetch live data from corporate databases when run on Node.js servers. </li>
<li>Build calculating web apps that can be started directly from the iPhone or Android Home screen – even when the phone is offline.</li>
</ul>
Our calculators are completely self-contained and do not require any additional plugins. There is nothing to install in your server or website except this plugin, and it is only used when you edit. You don’t need any programming skills and there is no change to configuration or settings.
<h4>Build smart web forms with automatic data validation</h4>
Publish your electronic forms on the web and have completed web forms sent directly to your inbox. If you get a lot of electronic forms for post-processing, have forms saved in a cloud database as they arrive.
<ul>
<li>Website contact forms with quality assurance for all contact data including e-mail addresses, phone numbers and addresses. </li>
<li>HTML order forms with automatic calculation of totals and weights.</li>
<li>Web booking forms with built-in input data validation.</li>
<li>Online purchase order forms with automatic assignment of cost center and accounts. </li>
<li>Web surveys converted from xlsx files. </li>
</ul>
The tabular Excel worksheet makes it very easy to design easy-to-use forms. The web page inherits the formatting in Excel and supports the use of graphical themes.
You can use any feature of Excel, including formulas and functions, to validate data entry, select intelligent default values or show customized images or Google maps.
<ul>
<li>Create mobile-friendly, responsive forms that automatically adapt to different screen widths, portrait/landscape orientation etc.</li>
<li>To make it easier to understand a large form, split into two or more sections and let users navigate between the sections using tabs, next/previous buttons or sliding panels.</li>
<li>Use graphical widgets like menus and calendars to make the form easier to use.</li>
<li>Hide rows or complete sections of a form until you know they are applicable.</li>
<li>Allow file attachments with submitted web forms.</li>
<li>Form fields can be made mandatory. Use hidden fields to discretely include supplemental information in the form.</li>
<li>With Real-time Sync, two or more persons can collaborate on a form in real-time.</li>
<li>Fetch live data from corporate databases when run on Node.js servers. </li>
<li>Build apps for mobile data entry that can submit smart forms directly from iPhone or Android devices – even when the phone is offline.</li>
<li>Use live, interactive charts that invite users to point-and-click, and the charts automatically update when values are changed.</li>
</ul>
Our forms processing services are completely self-contained, and the only thing you need to provide is an e-mail address. There is nothing to install in your server or website except this plugin, and it is only used when you edit. You don’t need any programming skills and there is no change to configuration or settings.
<h4>Create simple sign-up lists and other shared forms</h4>
Want to bring people together for a football game, a beach party or a barbecue? The Real-Time Sync feature allows all the users of a web spreadsheet to share the same content. Just create a spreadsheet with column headings for the information you want from each participant, e.g. Name and Age. Publish the empty list on your blog with the Real-Time Sync feature enabled, and all the readers of your blog will see who has registered for the event.
<h4>More information</h4>
Learn more about the plugin in <a href="http://help.spreadsheetconverter.com/support/online-help/help-wordpress-plugin-to-import-spreadsheets-from-microsoft-excel" title="Link to the online help for the plugin" rel="nofollow ugc">the full Online Help for the plugin</a>.
Learn more about the SpreadsheetConverter add-in for Microsoft Excel on the <a href="http://www.spreadsheetconverter.com/" title="Link to the SpreadsheetConverter web site" rel="nofollow ugc">SpreadsheetConverter web site</a>.
<h3>Installation instructions</h3>
<h4>Requirements</h4>
To use the plugin, you need the following:
<ul>
<li>A web page created with a paid or free-trial license for SpreadsheetConverter. The plugin does not import unconverted spreadsheets. An example file is delivered with the plugin. </li>
<li>Your paid SpreadsheetConverter license must be for the Professional Edition.</li>
<li>You must use the same major version of the plugin as your SpreadsheetConverter license is for.</li>
<li>A WordPress server that allows you to install plugins and use iframes. If you use WordPress.com or other hosted environments that limit this, it’s usually just as easy to use <a href="https://help.spreadsheetconverter.com/support/online-help/publish-to-cloud" title="Link to the Publish to Cloud help page" rel="nofollow ugc">Publish to Cloud</a> instead.</li>
<li>Your WordPress server must be running version 4.5 or later of WordPress. For security reasons, WordPress should always be updated to the latest stable version.</li>
<li>The plugin supports PHP 5, PHP 7, and PHP 8. </li>
<li>The plugin requires that the ZipArchive extension for PHP is installed and enabled.</li>
<li>You will need the help of a WordPress Administrator or be one yourself to install and maintain the plugin. Unfortunately we are unable to support you with basic WordPress issues.</li>
</ul>
<h4>Test it with the example file!</h4>
To upload a spreadsheet to WordPress, you first convert it to web format with an add-in for Excel called <a href="http://www.spreadsheetconverter.com/" title="Link to the SpreadsheetConverter web site" rel="nofollow ugc">SpreadsheetConverter</a>. Excel and the add-in will be your primary tools when publishing spreadsheets on your website.
You should first test the plugin with the example files that come with it. If you like it, you can then install SpreadsheetConverter in Excel and learn how to convert your own spreadsheets for the web.
<h4>Install the plugin file directly from the WordPress plugin directory</h4>
<ol>
<li>Login to the WordPress administration page for your server.</li>
<li>Click on Plugins in the left-hand menu. If you cannot find this in the menu, contact your WordPress administrator.</li>
<li>Click on Add New.</li>
<li>Type import spreadsheets in the search box on the right-hand side, and navigate to the plugin Import Spreadsheets from Microsoft Excel.</li>
<li>Click on Install Now for this plugin.</li>
<li>Locate the new plugin in the list of installed plugins and click on Activate Plugin.</li>
<li>The plugin is now installed and active. You should now see a new menu option Upload SSC Calculator in the left-hand menu.</li>
</ol>
<h4>Manually upload the plugin file to your WordPress server</h4>
<ol>
<li>Login to the WordPress administration page for your server.</li>
<li>Click on Plugins in the left-hand menu. If you cannot find this in the menu, contact your WordPress administrator.</li>
<li>Click on Add New.</li>
<li>Click on Upload Plugin on the Add Plugin page.</li>
<li>Click on Choose File on the Add Plugin page.</li>
<li>In the File Explorer window, select the plugin zip file and click Open.</li>
<li>Click on Install Now on the Add Plugin page.</li>
<li>Locate the new plugin in the list of installed plugins and click on Activate Plugin.</li>
<li>The plugin is now installed and active. You should now see a new menu option Upload SSC Calculator in the left-hand menu. This is where you start when you want to upload a converted calculator to WordPress.</li>
</ol>
A full online help for the plugin is available <a href="http://help.spreadsheetconverter.com/support/online-help/help-wordpress-plugin-to-import-spreadsheets-from-microsoft-excel" title="Link to the SpreadsheetConverter online help for the plugin" rel="nofollow ugc">on the SpreadsheetConverter website</a>.
Unfortunately, we are unable to support you in normal day-to-day WordPress activities. If you have problems installing the plugin, begin by contacting your local WordPress Administrator or webmaster. If they find any errors in our plugin, they are welcome to report the error in the support forum for the plugin.
<h3>Uploading instruction</h3>
You upload the result of the conversion in SpreadsheetConverter to WordPress in the form of an SSC Calculator file. The SSC Calculator file contains everything that WordPress needs to run the calculator.
<h4>Uploading a new calculator</h4>
Follow these instructions only when you upload a new calculator for the first time. If you later want to update an existing calculator that you have already uploaded at least once to WordPress, there are separate instructions below.
<h4>Creating the SSC Calculator file</h4>
With the plugin, you get two example files, one that you will use for this initial upload and one for the update described below.
<h4>Uploading the SSC Calculator file</h4>
<ol>
<li>In WordPress, locate the Upload SSC Calculator link in your WordPress menu. If you don’t see this link, please verify that you have installed the plugin correctly according to the instructions above.</li>
<li>Click on Upload SSC Calculator, then Add New if you are about to upload a new calculator that you haven’t uploaded before. </li>
<li>Enter a unique, descriptive name for this particular calculator in the Enter calculator name field. For the example file, you can use Weekly Time Card. </li>
<li>Click on Choose Package and select the SSC Calculator file. The example file provided with the plugin is in the examples > 1-upload folder of the plugin ZIP. Locate the weekly-time-card.zip file, select it and press Open. </li>
<li>Press the Publish button and the SSC Calculator file will be uploaded to WordPress. It will not be visible in any post or page until you embed it (read more below). </li>
</ol>
<h3>Embedding instructions</h3>
Before you embed a spreadsheet, you must follow the steps above to upload the SSC Calculator file to WordPress. Now, it’s time to embed the calculator in one or more web pages.
<h4>Using the Block editor</h4>
To insert a converted spreadsheet in WordPress using the Block editor:
<ol>
<li>In WordPress, click on the Upload SSC Calculator link in the menu.</li>
<li>In the list of calculators, locate the calculator you want to embed. </li>
<li>In the column Calculator iframe, click on the Click to Copy button for the calculator you want to embed. This copies the complete embed code to the clipboard.</li>
<li>Open the Block editor for the …</li>
</ol>

Import Spreadsheets from Microsoft Excel

Import live, calculating spreadsheets from Microsoft Excel to WordPress. The uploaded online spreadsheet is live, and looks and feels like in Excel.

Import Excel to Gravity Forms vs Import Spreadsheets from Microsoft Excel