# Challenge consuming data from csv

**URL:** <https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204>\
**Category:** Autopilot™\
**Tags:** autopilot\
**Created:** [August 22, 2025, 5:10pm UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204 "2025-08-22T17:10:23Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![christopher.puglise](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/christopher.puglise/32/513004_2.png) [@christopher.puglise](https://forum.uipath.com/u/christopher.puglise)\
**Post date:** [August 22, 2025, 5:10pm UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/1 "2025-08-22T17:10:23Z")

</div>

HI – and apologies if this has been addressed elsewhere. I am trying to have Autopilot do some basic summarization of data in a .csv file (1 record per row), however it often only consumes a fraction of the rows of data (only talking about 50 rows, often it only has summarization for 15-20). Any tips on what I might be doing wrong, or how to refine the prompt (beyond asking it to consume all XX rows of data – which seems a bit much, and still doesn’t consistently get me an accurate result)

Thanks for any tips/pointers,  
Chris

---

<div class="post-metadata">

**Author:** ![prashant1603765](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/prashant1603765/32/523412_2.png) [@prashant1603765](https://forum.uipath.com/u/prashant1603765)\
**Post date:** [August 22, 2025, 5:30pm UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/2 "2025-08-22T17:30:21Z")

</div>

Hi @christopher.puglise

 ![image](https://global.discourse-cdn.com/uipath/original/4X/3/0/c/30c6075cfc350288a0e1b144df70303fcbecb09d.png)

Pls check for more:

> **[Autopilot - Flex licensing](https://docs.uipath.com/autopilot/other/latest/overview/flex-licensing)**
>
> The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...

If you found helpful, Mark as a solution tick .  
Happy Automation

---

<div class="post-metadata">

**Author:** ![Paul\_Welch](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/paul_welch/32/542091_2.png) [@Paul\_Welch](https://forum.uipath.com/u/Paul_Welch)\
**Post date:** [August 22, 2025, 10:11pm UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/3 "2025-08-22T22:11:13Z")

</div>

“I’ve run into something similar before, Autopilot seems to sometimes cuts off when handling CSVs with multiple rows. What helped me was splitting the file into smaller chunks or guiding it with more structured prompts (like asking for summaries in batches of 10–15 rows). Might be worth testing if that gives more consistent results.”

---

<div class="post-metadata">

**Author:** ![christopher.puglise](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/christopher.puglise/32/513004_2.png) [@christopher.puglise](https://forum.uipath.com/u/christopher.puglise)\
**Post date:** [August 22, 2025, 10:46pm UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/4 "2025-08-22T22:46:34Z")

</div>

Thanks for the suggestion, will give it a try! Up to this point, even for small files (50 rows) I don’t get 50, and rarely get the same answer twice. Will suggest it consumes the file 10 rows at a time.

---

<div class="post-metadata">

**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\
**Post date:** [August 23, 2025, 5:44am UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/5 "2025-08-23T05:44:23Z")

</div>

@christopher.puglise

Welcome to the community

How are you passing it?

There is a input limit as well so that might be an issue

Cheers

---

<div class="post-metadata">

**Author:** ![christopher.puglise](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/christopher.puglise/32/513004_2.png) [@christopher.puglise](https://forum.uipath.com/u/christopher.puglise)\
**Post date:** [August 24, 2025, 7:56pm UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/6 "2025-08-24T19:56:53Z")

</div>

Thanks for the response, I was simply attaching a .csv file. Is there another approach I should take, or a way to “chunk” the input so the tool grabs what it can consume, then moves to the next part?

---

<div class="post-metadata">

**Author:** ![Anil\_G](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/anil_g/32/524291_2.png) [@Anil\_G](https://forum.uipath.com/u/Anil_G)\
**Post date:** [August 25, 2025, 7:54am UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/7 "2025-08-25T07:54:06Z")

</div>

@christopher.puglise

try to save the csv as text file with .txt and then try to feed it

cheers

---

<div class="post-metadata">

**Author:** ![christopher.puglise](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/christopher.puglise/32/513004_2.png) [@christopher.puglise](https://forum.uipath.com/u/christopher.puglise)\
**Post date:** [August 25, 2025, 2:12pm UTC](https://forum.uipath.com/t/challenge-consuming-data-from-csv/4800204/8 "2025-08-25T14:12:18Z")

</div>

Thanks, saving as a tab delimited text file seems to be helping. Still having issues with properly categorizing the entries (ticket severity) – but will keep playing with it.

I appreciate the suggestion!
