# \#format **URL:** https://forum.uipath.com/tag/format/2472.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [How to extract .gz](https://forum.uipath.com/t/how-to-extract-gz/2878525)
**Author:** [@jai\_kumar2](https://forum.uipath.com/u/jai_kumar2)\ **Replies:** 6\ **Last updated:** [July 8, 2025, 3:44am UTC](https://forum.uipath.com/t/how-to-extract-gz/2878525 "2025-07-08T03:44:57Z")
Hi, I’m currently working on a project where I need to handle .gz files. These files act like zip archives and contain multiple files within them. The requirement is: Extract the contents of the .gz file into a folde… --- ## [Read csv - Format](https://forum.uipath.com/t/read-csv-format/717527)
**Author:** [@Birgit\_Plank](https://forum.uipath.com/u/Birgit_Plank)\ **Replies:** 5\ **Last updated:** [February 6, 2024, 3:36pm UTC](https://forum.uipath.com/t/read-csv-format/717527 "2024-02-06T15:36:36Z")
Hello, I would like to import the data from a CSV file into an Excel worksheet. Unfortunately, the formatting of the CSV is being distorted during import. In the first row of the CSV, the date is in the format dd.mm.y… --- ## [How to update utf 8 bom and save as csv](https://forum.uipath.com/t/how-to-update-utf-8-bom-and-save-as-csv/567574)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 7\ **Last updated:** [July 27, 2023, 4:27pm UTC](https://forum.uipath.com/t/how-to-update-utf-8-bom-and-save-as-csv/567574 "2023-07-27T16:27:43Z")
hello, my requirement is as follows. i have one csv file with name issues.csv - \> need to open file as notepad after opening as note pad -\>need tos select option in encoding UTF- with BOM and and replce previous… --- ## [Format text to Json format and write in in file](https://forum.uipath.com/t/format-text-to-json-format-and-write-in-in-file/564192)
**Author:** [@Andrei\_Croitoru](https://forum.uipath.com/u/Andrei_Croitoru)\ **Replies:** 1\ **Last updated:** [July 18, 2023, 2:59pm UTC](https://forum.uipath.com/t/format-text-to-json-format-and-write-in-in-file/564192 "2023-07-18T14:59:17Z")
Hello! I have this string: “"crt": {\\r\\n "type": "string",\\r\\n "valueString": "00080",\\r\\n "content": "00080",\\r\\n "boundingRegions": \[\\r\\n {\\r\\n "pageNumber": 1,\\r\\n "polygon": \[\\r\\n 0.1838,\\r\\… --- ## [Replace Text in Document](https://forum.uipath.com/t/replace-text-in-document/528509)
**Author:** [@meghan.myers](https://forum.uipath.com/u/meghan.myers)\ **Replies:** 9\ **Last updated:** [March 28, 2023, 2:46pm UTC](https://forum.uipath.com/t/replace-text-in-document/528509 "2023-03-28T14:46:07Z")
Hello, I keep getting an error when using the replace text in Document activity in StudioX. The document is formatted like: A. \[A\] B. \[B\] C. \[C\] and so on. So I had to increment the alphabet and in the document it i… --- ## [Convert value in excel to correct format](https://forum.uipath.com/t/convert-value-in-excel-to-correct-format/447932)
**Author:** [@Dhruvi\_Arumugam](https://forum.uipath.com/u/Dhruvi_Arumugam)\ **Replies:** 15\ **Last updated:** [June 16, 2022, 2:09pm UTC](https://forum.uipath.com/t/convert-value-in-excel-to-correct-format/447932 "2022-06-16T14:09:40Z")
Hi Everyone, I have a column in a file named Serial Number which is having values like - 1092534, J101KPN4, J1007PEA, 1048E75 this data is in an excel table format. When I am copying this data to another sheet every v… --- ## [Change format of the column automatically in destination excel](https://forum.uipath.com/t/change-format-of-the-column-automatically-in-destination-excel/406305)
**Author:** [@Muralikrishna\_Basani](https://forum.uipath.com/u/Muralikrishna_Basani)\ **Replies:** 11\ **Last updated:** [March 16, 2022, 12:08pm UTC](https://forum.uipath.com/t/change-format-of-the-column-automatically-in-destination-excel/406305 "2022-03-16T12:08:59Z")
Hi Team, I am trying to perform calculations in master sheet in some coloumn which is the percentage. After that, I am filtering some values according to some conditions and writing those rows in another excel. Now in … --- ## [Preserve format type when Merge data from two excel files](https://forum.uipath.com/t/preserve-format-type-when-merge-data-from-two-excel-files/397722)
**Author:** [@Lynx](https://forum.uipath.com/u/Lynx)\ **Replies:** 4\ **Last updated:** [February 8, 2022, 7:31pm UTC](https://forum.uipath.com/t/preserve-format-type-when-merge-data-from-two-excel-files/397722 "2022-02-08T19:31:14Z")
Good afternoon friends: One question please, could you tell me how I could maintain the original format of the data that I want to add from one excel file to another. I turned on the keep formatting options, but it did… --- ## [Convert Time string to Datetime format](https://forum.uipath.com/t/convert-time-string-to-datetime-format/368757)
**Author:** [@tomnguyen795](https://forum.uipath.com/u/tomnguyen795)\ **Replies:** 3\ **Last updated:** [December 10, 2021, 11:05am UTC](https://forum.uipath.com/t/convert-time-string-to-datetime-format/368757 "2021-12-10T11:05:25Z")
Hi all, currently I am importing data from a Jason string output. In the data, there is a datetime string which looks like this: “Fri Dec 03 06:22:00 UTC 2021”. I am struggling to convert it to the date time format as “d…