# Add line items automatically from an Excel

**URL:** <https://community.hubspot.com/t/add-line-items-automatically-from-an-excel/114080>\
**Category:** Sales Hub Tools\
**Tags:** object\
**Created:** [August 8, 2024, 2:11pm UTC](https://community.hubspot.com/t/add-line-items-automatically-from-an-excel/114080 "2024-08-08T14:11:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![WvanderGarde](https://avatars.discourse-cdn.com/v4/letter/w/ed655f/32.png) [@WvanderGarde](https://community.hubspot.com/u/WvanderGarde)\
**Post date:** [August 8, 2024, 2:11pm UTC](https://community.hubspot.com/t/add-line-items-automatically-from-an-excel/114080/1 "2024-08-08T14:11:37Z")

</div>

Hi there!

We are a company that sells heating systems with a lot of components.

To calculate we use a tool in Excel, which gives a list with the quantity, SKU, name and price of all the products needed.

Does anyone know wheter it would be possible to add line items from an external list / excel / other calculation tool to a deal?

---

<div class="post-metadata">

**Author:** ![RBozeman](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/rbozeman/32/8786_2.png) [@RBozeman](https://community.hubspot.com/u/RBozeman)\
**Post date:** [August 8, 2024, 4:21pm UTC](https://community.hubspot.com/t/add-line-items-automatically-from-an-excel/114080/2 "2024-08-08T16:21:46Z")

</div>

Hi @WvanderGarde, yes this should be possible. Check out [this help doc](https://knowledge.hubspot.com/import-and-export/set-up-your-import-file).

On there it says this:

"

- **Line items**** :** _Name_, _Quantity_, _Price,_ and the associated deals’ _Record ID_ or _Deal name_. Include the product’s Product ID if you’re also associating the line item with a product, which will be mapped as a line item property during the import."

So as long as you can include that data on the spreadsheet, you shouldn’t have an issue.

---

<div class="post-metadata">

**Author:** ![Akash\_Vi\_R](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Akash\_Vi\_R](https://community.hubspot.com/u/Akash_Vi_R)\
**Post date:** [March 4, 2025, 7:44am UTC](https://community.hubspot.com/t/add-line-items-automatically-from-an-excel/114080/3 "2025-03-04T07:44:18Z")

</div>

hey @WvanderGarde - there are a couple of ways.  
you can import directly with the in-built functionality. check out this [help doc](https://knowledge.hubspot.com/import-and-export/set-up-your-import-file?) for that.  
you can also use hubspot certified apps like [Superjoin](https://www.superjoin.ai/integrations/hubspot?utm_source=hubspot&utm_medium=organic&utm_campaign=excel_sync) (it has a free version) to push data into hubspot. they have a neat 2-way sync, so you can push from excel/google sheets into hubspot.

---

<div class="post-metadata">

**Author:** ![Vj\_Srini](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vj_srini/32/205671_2.png) [@Vj\_Srini](https://community.hubspot.com/u/Vj_Srini)\
**Post date:** [May 9, 2025, 2:15pm UTC](https://community.hubspot.com/t/add-line-items-automatically-from-an-excel/114080/4 "2025-05-09T14:15:24Z")

</div>

Hi @WvanderGarde You can use [Coefficient Excel Add-in](https://ecosystem.hubspot.com/marketplace/apps/coefficient) to automate the whole thing directly from Excel. You can push and pull data between Excel and HubSpot, setup email alerts conditionally, setup auto-refreshes.