I have an output file in UiPath that has to be a pipe delimited CSV file. The original XLS file (formats I want) is this: [image] This is what is being produced in the output [image] I have tried to invoke a macro or even VBA code, but nothing changes. I suspect that is being there is “no thir…

Hi @jwetherin Can you try this <a class="lightbox" href="https://global.discourse-cdn.com/uipath/original/4X/a/8/7/a87911772aff7e24ba323389ad696f3676615188.png" data-download-href="/uploads/short-url/o2nBm35RtXa6Se2ZpZyVw77b6fm.png?dl=1" title="The image shows an automated process for converting an Excel file ("Input.xls") into a CSV file ("Output.csv") using the "Export to CSV" function within an Excel process scope. (Captioned by AI)">[The image shows an automated process for converting an Excel file ("Input.xls") into a CSV file ("Output.csv") using the "Export to CSV" function within an Excel process scope. (Captioned by AI)] Make sure to check Read formatting as Display value [An Excel auto…

Converting XLS to CSV (pipedelimited) not keeping exact date format

Help Studio

system (system) Closed April 17, 2025, 4:24pm 6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
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

Converting XLS to CSV (pipedelimited) not keeping exact date format

Related topics