# OpenAI ask a question about a table doesn't seem to work for an Excel table

**URL:** https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831
**Category:** Ask for Help
**Created:** [September 6, 2023, 9:58am UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831 "2023-09-06T09:58:40Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [September 6, 2023, 9:58am UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/1 "2023-09-06T09:58:40Z")

</div>

I always get the following system error when asking a question about my Excel table: “Answer question about a table: Could not get embeddings | Bad Request”

When I use a native Glide table it simply works.

It’s a problem since I use the Jira to Excel integration to easily download my issues into Glide.

Is this normal and or is there a workaround for this?

Many thanks for your support!

Tim

 ![Schermafbeelding 2023-09-06 om 11.54.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9a62b027c92aef876677f4d9ab029f7ff4fa038b.png)

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [September 6, 2023, 4:43pm UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/2 "2023-09-06T16:43:38Z")

</div>

I’ve had more issues than successes with the “Ask a question about a table” OpenAI feature. Maybe it’s just me.

One issue is that even when set up correctly, the feature seems to only read a subset of the table, and I’ve never understood which subset.

Have you tried importing the data from your Excel into a Glide Table to see if the feature is even doing what you want it to do? If it isn’t, it might not be worth to troubleshoot the issue with Excel.

I’m not addressing your issue directly, just sharing thoughts out loud before you go down a rabbit hole.

---

<div class="post-metadata">

### Author: ![Jeremy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeremy/32/29121_2.png) [@Jeremy](https://community.glideapps.com/u/Jeremy)
#### Post date: [September 6, 2023, 5:27pm UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/3 "2023-09-06T17:27:40Z")

</div>

How many rows are you processing? You may want to reduce the columns, rows or overall content if the API is struggling getting embeddings back - Usually points to too much data trying to be processed.

---

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [September 6, 2023, 9:08pm UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/4 "2023-09-06T21:08:38Z")

</div>

it’s only 600 rows and I tried to limit the columns allready. I don’t think the amount of data is the issue since I’ve used this for bigger glide tables before.

---

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [September 6, 2023, 9:10pm UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/5 "2023-09-06T21:10:23Z")

</div>

thanks for the feedback. I have tried to use the functionality with Glide tables and that seemed to work fine for me. However given the set-up for just an internal application where I want to leverage the Jira to Excel integration this is bit of a bummer.

---

<div class="post-metadata">

### Author: ![Jeremy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeremy/32/29121_2.png) [@Jeremy](https://community.glideapps.com/u/Jeremy)
#### Post date: [September 12, 2023, 11:00pm UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/6 "2023-09-12T23:00:09Z")

</div>

There’s a bug where OpenAI can’t process empty rows and you’ll get this value. Put a fix on our side to skip these. Hopefully lands this week.

---

<div class="post-metadata">

### Author: ![Tim\_Gestels](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_gestels/32/44044_2.png) [@Tim\_Gestels](https://community.glideapps.com/u/Tim_Gestels)
#### Post date: [September 14, 2023, 8:36pm UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/7 "2023-09-14T20:36:42Z")

</div>

let me know and I’ll test again

---

<div class="post-metadata">

### Author: ![Jeremy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeremy/32/29121_2.png) [@Jeremy](https://community.glideapps.com/u/Jeremy)
#### Post date: [September 14, 2023, 8:37pm UTC](https://community.glideapps.com/t/openai-ask-a-question-about-a-table-doesnt-seem-to-work-for-an-excel-table/65831/8 "2023-09-14T20:37:44Z")

</div>

I think it might have just landed, can you retest?
