# Importing data which can be used in form calculation

**URL:** <https://community.gravityforms.com/t/importing-data-which-can-be-used-in-form-calculation/11262>\
**Category:** Get Help\
**Tags:** custom, calculations, populate-anything, dynamic-population, gravity-wiz\
**Created:** [November 24, 2021, 2:03pm UTC](https://community.gravityforms.com/t/importing-data-which-can-be-used-in-form-calculation/11262 "2021-11-24T14:03:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zholy9](https://sea2.discourse-cdn.com/flex020/user_avatar/community.gravityforms.com/zholy9/32/4028_2.png) [@zholy9](https://community.gravityforms.com/u/zholy9)\
**Post date:** [November 24, 2021, 2:03pm UTC](https://community.gravityforms.com/t/importing-data-which-can-be-used-in-form-calculation/11262/1 "2021-11-24T14:03:34Z")

</div>

Hi guys.

Beginners question : how can I import data to gravity forms, which can then be later used in calculations?

I want to create a form, where customers can order/reserve 6 types of fuel. That form should be a 2 step form, where in the first the customer chooses the preffered fuel and the quantity…and the 2nd part (confirmation) would show the calculated price.  
The price is updated on a regular/daily basis. For you - the pros - this might be a trivial question, but I don’t know :

1. how to import the 6 fuel prices (just numbers in CSV, or Excel) so they can be used in a form (for the calculation - hidden field)?

Can you advice how to do this please? Looking forward to your reply.

Kind regards, Zed

---

<div class="post-metadata">

**Author:** ![chrishajer](https://sea2.discourse-cdn.com/flex020/user_avatar/community.gravityforms.com/chrishajer/32/88_2.png) [@chrishajer](https://community.gravityforms.com/u/chrishajer)\
**Post date:** [November 24, 2021, 5:57pm UTC](https://community.gravityforms.com/t/importing-data-which-can-be-used-in-form-calculation/11262/2 "2021-11-24T17:57:30Z")

</div>

Hi Zed. I recommend taking a look at Populate Anything from Gravity Wiz:

> **[Gravity Forms Populate Anything - Enable Dynamic Population - Gravity Wiz](https://gravitywiz.com/documentation/gravity-forms-populate-anything/)**
>
> Dynamically filter and populate field choices and values with posts, users, taxonomies, terms, Gravity Forms entries, and databases.

It can’t populate from an Excel spreadsheet, so the data would need to be entered into a database table in order for that solution to work.

They do have a method to populate from a Google Sheet though:

> **[Populate Gravity Forms with Google Sheets](https://gravitywiz.com/populate-gravity-forms-with-google-sheets/)**
>
> Dynamically load data from Google Sheets into your WordPress Form's field choices, or values, using Gravity Forms.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/gravityforms1/original/2X/f/fef63f0599c45e0218c30d9f5d7ca8bff9b00189.png) [@system](https://community.gravityforms.com/u/system)\
**Post date:** [December 24, 2021, 5:57pm UTC](https://community.gravityforms.com/t/importing-data-which-can-be-used-in-form-calculation/11262/3 "2021-12-24T17:57:32Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.