In an Excel file, when there is a line break in a cell, a row is divided into multiple segments. #3614

Closed
opened 2026-02-21 17:59:56 -05:00 by yindo · 0 comments
Owner

Originally created by @anopern on GitHub (May 23, 2024).

Self Checks

  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
  • Please do not modify this template :) and fill in all the required fields.

1. Is this request related to a challenge you're experiencing?

I want to convert an Excel file into a dataset and build a Q&A chatbot. In the file, the questions are in column 1, and the answers are in column 2. The content of each row should be treated as a single segment, but if a cell in a row contains line breaks, that row should be split into multiple segments.
4df454b135a266b6b4ff771e7e9c0cf

2. Describe the feature you'd like to see

If the system detects that the uploaded file is an Excel file (XLSX, CSV, XLS), it should provide an option to "Remove line breaks in cells". If the user selects this option, the line breaks in the Excel document will be removed during the cleaning process.

3. How will this feature improve your workflow or experience?

With this feature, when our common Q&A data file is uploaded, it can automatically split a row into a chunk, improving the accuracy of the Q&A chatbot's responses.

4. Additional context or comments

No response

5. Can you help us with this feature?

  • I am interested in contributing to this feature.
Originally created by @anopern on GitHub (May 23, 2024). ### Self Checks - [X] I have searched for existing issues [search for existing issues](https://github.com/langgenius/dify/issues), including closed ones. - [X] I confirm that I am using English to submit this report (我已阅读并同意 [Language Policy](https://github.com/langgenius/dify/issues/1542)). - [X] Please do not modify this template :) and fill in all the required fields. ### 1. Is this request related to a challenge you're experiencing? I want to convert an Excel file into a dataset and build a Q&A chatbot. In the file, the questions are in column 1, and the answers are in column 2. The content of each row should be treated as a single segment, but if a cell in a row contains line breaks, that row should be split into multiple segments. ![4df454b135a266b6b4ff771e7e9c0cf](https://github.com/langgenius/dify/assets/126169959/050e7358-b997-42e1-abca-58eae482b00d) ### 2. Describe the feature you'd like to see If the system detects that the uploaded file is an Excel file (XLSX, CSV, XLS), it should provide an option to "Remove line breaks in cells". If the user selects this option, the line breaks in the Excel document will be removed during the cleaning process. ### 3. How will this feature improve your workflow or experience? With this feature, when our common Q&A data file is uploaded, it can automatically split a row into a chunk, improving the accuracy of the Q&A chatbot's responses. ### 4. Additional context or comments _No response_ ### 5. Can you help us with this feature? - [X] I am interested in contributing to this feature.
yindo added the 💪 enhancement label 2026-02-21 17:59:56 -05:00
yindo closed this issue 2026-02-21 17:59:56 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langgenius/dify#3614