UiPath Community Forum
Converting XLS to CSV (pipedelimited) not keeping exact date format
Help
Studio
question
,
activities_panel
,
studio
lrtetala
(Lakshman Reddy)
April 14, 2025, 4:24pm
5
@jwetherin
Can you try below sample?
The image depicts an automation workflow where an Excel file is read, a range of data from a specified sheet is extracted, and the data is then written to a CSV file. (Captioned by AI)
585×980 26 KB
This image depicts an UiPath workflow configuration where an Excel file named "Input.xls" is read with the "Read formatting" option set to "Display value" and the resulting data is saved to a variable called "dt". (Captioned by AI)
1296×609 36.9 KB
An automation workflow is set up to read data from an Excel sheet and write it to a CSV file using a pipe delimiter, with headers included. (Captioned by AI)
1270×613 35.4 KB
Regards,
show post in topic
Related topics
Topic
Replies
Views
Activity
Issue with date format from csv to excel
Forum
question
24
2201
July 15, 2021
Problems with date column when converting an excel file to CSV
Studio
excel
,
csv
,
studio
8
2557
September 22, 2021
How to change the format from .csv to .xls in automation
Help
excel
,
activities
8
8921
September 1, 2017
Opening CSV file using UiPath changes the format
Help
4
1345
July 13, 2018
Converting .xls (Workbook) to .csv
Studio
4
1211
June 28, 2020