# \#csv **URL:** https://forum.uipath.com/tag/csv/21.md [Últimos](https://forum.uipath.com/latest.md) · [Categorias](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [A atividade WriteCSV não adiciona aspas mesmo com a propriedade "should quote" ativada](https://forum.uipath.com/t/writecsv-activity-does-not-add-quote-even-though-should-quote-property-is-on/5261676)
**Author:** [@Yoichi](https://forum.uipath.com/u/Yoichi)\ **Respostas:** 2\ **Última atualização:** [Novembro 6, 2025, 12:36am UTC](https://forum.uipath.com/t/writecsv-activity-does-not-add-quote-even-though-should-quote-property-is-on/5261676 "2025-11-06T00:36:29Z")
Este é um relatório de bug. No pacote UiPath.Excel.Activities 3.1.1-3.2.1, a atividade WriteCSV não adiciona aspas, embora a propriedade „should quote“ esteja ATIVADA. Isso causa problemas no CSV quando ele contém cara… --- ## [JSON形式のデータをCSV形式のファイルに変換する方法について](https://forum.uipath.com/t/json-csv/2772910)
**Author:** [@Kazuto](https://forum.uipath.com/u/Kazuto)\ **Respostas:** 8\ **Última atualização:** [Abril 4, 2025, 6:22am UTC](https://forum.uipath.com/t/json-csv/2772910 "2025-04-04T06:22:26Z")
UiPath StudioXで、UiPath Orchestrator APIから取得したJSON形式のトリガーデータをCSV形式のファイルに変換することを試みています。取得したJSONの構造は最下部をご覧ください。 【UiPath】「Orchestrator への HTTP 要求」からジョブやプロセスの全データを取得し、CSVで出力する #UiPathOrchestrator - Qiita 上記の記事を参考に、JSONの逆シリ… --- ## [ExcelをCSVに変換したい](https://forum.uipath.com/t/excel-csv/860137)
**Author:** [@curry](https://forum.uipath.com/u/curry)\ **Respostas:** 1\ **Última atualização:** [Fevereiro 10, 2025, 1:49am UTC](https://forum.uipath.com/t/excel-csv/860137 "2025-02-10T01:49:29Z")
なるべくGUI操作やUiPath以外のツールやシステムを使用せずにCSVに変換したいです。 【環境】 ・UiPathクラシック ・Invoke Codeは使用できない 【試したこと】 ・Excelの内容をDataTableに読み込んでCSVに書き込む →データ量が多く、時間がかかりすぎる。 ・ExcelマクロでCSVに変換 →あまりスマートではないので使いたくない ・Invoke MethodでSaveAsを呼び出し … --- ## [ExcelをCSVに変換したい](https://forum.uipath.com/t/excel-csv/860081)
**Author:** [@curry](https://forum.uipath.com/u/curry)\ **Respostas:** 4\ **Última atualização:** [Fevereiro 7, 2025, 7:50am UTC](https://forum.uipath.com/t/excel-csv/860081 "2025-02-07T07:50:33Z")
なるべくGUI操作やUiPath以外のツールやシステムを使用せずにCSVに変換したいです。 【環境】 ・UiPathクラシック ・Invoke Codeは使用できない 【試したこと】 ・Excelの内容をDataTableに読み込んでCSVに書き込む →データ量が多く、時間がかかりすぎる。 ・ExcelマクロでCSVに変換 →他ツールを使用しているのでなるべく採用したくない。 ・Invoke MethodでSaveAs… --- ## [Read CSV doesn't work as it should](https://forum.uipath.com/t/read-csv-doesnt-work-as-it-should/785690)
**Author:** [@maciek](https://forum.uipath.com/u/maciek)\ **Respostas:** 3\ **Última atualização:** [Dezembro 13, 2024, 1:18pm UTC](https://forum.uipath.com/t/read-csv-doesnt-work-as-it-should/785690 "2024-12-13T13:18:58Z")
Hi I have a problem with reading a csv file. I will attach a screenshot for you to see the structure of the file. I think somehow the problem is with the quotation marks. The read csv acivity properly reads only rows wit… --- ## [Read CSV with different delimiters (semicolon and linebreak)](https://forum.uipath.com/t/read-csv-with-different-delimiters-semicolon-and-linebreak/781003)
**Author:** [@JenJen](https://forum.uipath.com/u/JenJen)\ **Respostas:** 5\ **Última atualização:** [Novembro 21, 2024, 10:15am UTC](https://forum.uipath.com/t/read-csv-with-different-delimiters-semicolon-and-linebreak/781003 "2024-11-21T10:15:33Z")
Hey hey, at the moment I try to find out how to read a csv file with this content: test;aaa;bbb;ccc\\ntest;aaa;bbb;ccc \\n signs the end of line. With standard activities (Read CSV) I get one row out of it, but I expect… --- ## [csvファイルから読み込んだデータテーブルを、計算したい。Sum(round(C列\*0.6),1)](https://forum.uipath.com/t/csv-sum-round-c-0-6-1/743634)
**Author:** [@Shou-kun](https://forum.uipath.com/u/Shou-kun)\ **Respostas:** 3\ **Última atualização:** [Maio 27, 2024, 1:07pm UTC](https://forum.uipath.com/t/csv-sum-round-c-0-6-1/743634 "2024-05-27T13:07:33Z")
csvから読み込んだ、dt1（画像のA1:C3）に対し、 C列を各々に”Sum(round(C列\*0.6),1)”の計算をした合計を求めたいです。 C列\*0.6の合計値は、過去のトピックを参考にさせていただき、 dt1.AsEnumerable().Sum(Function(r) Int32.Parse(r(“金額”).ToString())\*0.6) と書くことができたのですが、roundの個所がわかりません。 各々の行の結… --- ## [Getting error: bulkAddQueueItemsParameters must not be null](https://forum.uipath.com/t/getting-error-bulkaddqueueitemsparameters-must-not-be-null/735135)
**Author:** [@NiesonF](https://forum.uipath.com/u/NiesonF)\ **Respostas:** 3\ **Última atualização:** [Abril 17, 2024, 11:32am UTC](https://forum.uipath.com/t/getting-error-bulkaddqueueitemsparameters-must-not-be-null/735135 "2024-04-17T11:32:50Z")
Im trying to upload a few transaction items in a queue via CSV. When I upload them it prompts me the error “bulkAddQueueItemsParameters must not be null” Where can i change this? This is what my CSV looks like. --- ## [Append to CSV is adding quotation marks](https://forum.uipath.com/t/append-to-csv-is-adding-quotation-marks/728355)
**Author:** [@Alisa\_Su](https://forum.uipath.com/u/Alisa_Su)\ **Respostas:** 10\ **Última atualização:** [Março 20, 2024, 12:38pm UTC](https://forum.uipath.com/t/append-to-csv-is-adding-quotation-marks/728355 "2024-03-20T12:38:09Z")
Hey guys, I have an issue with creating a CSV file. Upon reviewing the DataTable,the number 2-6 have a leading white space. This white space is necessary because without it, the CSV formats it incorrectly as a date. If … --- ## [Csv 파일 행추가와 데이터 수정](https://forum.uipath.com/t/csv/728248)
**Author:** [@Benimaru](https://forum.uipath.com/u/Benimaru)\ **Respostas:** 3\ **Última atualização:** [Março 20, 2024, 7:02am UTC](https://forum.uipath.com/t/csv/728248 "2024-03-20T07:02:47Z")
UiPath 입문자입니다. csv파일을 실행시켜서 데이터 테이블에 row 데이터를 추가하거나 특정 셀 데이터를 수정하고 싶습니다. 어떤 액티비티를 써야하고 로직을 짜야할지 모르겠어요 --- ## [Please tell me how to add as many rows as meet the conditions](https://forum.uipath.com/t/please-tell-me-how-to-add-as-many-rows-as-meet-the-conditions/728185)
**Author:** [@Benimaru](https://forum.uipath.com/u/Benimaru)\ **Respostas:** 1\ **Última atualização:** [Março 20, 2024, 2:25am UTC](https://forum.uipath.com/t/please-tell-me-how-to-add-as-many-rows-as-meet-the-conditions/728185 "2024-03-20T02:25:25Z")
I want to read each row of a csv file and if the value of end date - start date is 4 then I want to append 4 corresponding same rows. I’m not sure how to approach this. --- ## [Adding csv file as local test data file](https://forum.uipath.com/t/adding-csv-file-as-local-test-data-file/723400)
**Author:** [@sz118](https://forum.uipath.com/u/sz118)\ **Respostas:** 3\ **Última atualização:** [Fevereiro 29, 2024, 10:32am UTC](https://forum.uipath.com/t/adding-csv-file-as-local-test-data-file/723400 "2024-02-29T10:32:29Z")
Hi everybody, I’d like to add my csv test data file locally to my test case. I right click on the test case and select Add test data. I select File as data source. But just xlsm, xlsx and json files can be selected (see… --- ## [Read csv - Format](https://forum.uipath.com/t/read-csv-format/717527)
**Author:** [@Birgit\_Plank](https://forum.uipath.com/u/Birgit_Plank)\ **Respostas:** 5\ **Última atualização:** [Fevereiro 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… --- ## [From CSV to XML](https://forum.uipath.com/t/from-csv-to-xml/713394)
**Author:** [@AaronMark](https://forum.uipath.com/u/AaronMark)\ **Respostas:** 3\ **Última atualização:** [Janeiro 29, 2024, 9:02am UTC](https://forum.uipath.com/t/from-csv-to-xml/713394 "2024-01-29T09:02:25Z")
Hi everyone. I need advice on how to structure a bot for converting a file from CSV to XML, with partially variable parts and data. Let’s say that we start from a CSV, which has a structure like this: A - introduction … --- ## [Append to CSV special characters](https://forum.uipath.com/t/append-to-csv-special-characters/714708)
**Author:** [@Alisa\_Su](https://forum.uipath.com/u/Alisa_Su)\ **Respostas:** 4\ **Última atualização:** [Janeiro 24, 2024, 1:45pm UTC](https://forum.uipath.com/t/append-to-csv-special-characters/714708 "2024-01-24T13:45:00Z")
Hey guys, when I use the activity Append to CSV special characters like Ä,Ö,Ü are not formatted correctly as you can see in the screenshot below. I tried different encodings like UTF-8 but it’s not working. Thanks in a… --- ## [Import csv/text file to excel](https://forum.uipath.com/t/import-csv-text-file-to-excel/714169)
**Author:** [@quick\_123](https://forum.uipath.com/u/quick_123)\ **Respostas:** 20\ **Última atualização:** [Janeiro 23, 2024, 4:35am UTC](https://forum.uipath.com/t/import-csv-text-file-to-excel/714169 "2024-01-23T04:35:31Z")
Hi, I want import csv file to excel, Currently I am reading csv file and writing it directly to excel but if I import it from excel directly the format is changing, any leads --- ## [Converting a csv file to text to columns](https://forum.uipath.com/t/converting-a-csv-file-to-text-to-columns/714090)
**Author:** [@YANG\_zing](https://forum.uipath.com/u/YANG_zing)\ **Respostas:** 9\ **Última atualização:** [Janeiro 23, 2024, 12:52am UTC](https://forum.uipath.com/t/converting-a-csv-file-to-text-to-columns/714090 "2024-01-23T00:52:59Z")
Hi I want convert a csv file delimited by character “|” to new excel file. Is there any option to convert other than text to column from modern activity because through this activity i will have read csv , write range … --- ## [Unable to read CSV file](https://forum.uipath.com/t/unable-to-read-csv-file/703279)
**Author:** [@Vivek\_Ramani](https://forum.uipath.com/u/Vivek_Ramani)\ **Respostas:** 4\ **Última atualização:** [Novembro 30, 2023, 9:27am UTC](https://forum.uipath.com/t/unable-to-read-csv-file/703279 "2023-11-30T09:27:16Z")
Hi I want to read the CSV file. I’m using the READ CSV activity but getting error Error: “Read CSV: The CSV file format for Communication File\\data.csv is invalid. Line 2 contains more values than the header line.” I… --- ## [Filter and Merge Multiple CSV file](https://forum.uipath.com/t/filter-and-merge-multiple-csv-file/702050)
**Author:** [@hanviprebday](https://forum.uipath.com/u/hanviprebday)\ **Respostas:** 5\ **Última atualização:** [Novembro 25, 2023, 5:37am UTC](https://forum.uipath.com/t/filter-and-merge-multiple-csv-file/702050 "2023-11-25T05:37:19Z")
Dear friends, I have 4 CSV files. In that 4 files I have some date and I want to remove ,ABC,ABC from that CSV file and write the remaining output to the same sheet again. I have to do this for all the 4 CSV files. Ple… --- ## [How to convert datatype in CSV](https://forum.uipath.com/t/how-to-convert-datatype-in-csv/645693)
**Author:** [@siddhi.kamble](https://forum.uipath.com/u/siddhi.kamble)\ **Respostas:** 7\ **Última atualização:** [Outubro 17, 2023, 9:01am UTC](https://forum.uipath.com/t/how-to-convert-datatype-in-csv/645693 "2023-10-17T09:01:26Z")
There is date column(J) in csv with General format and i need to change that to Date format. Also another column(A) to integer format. how it can be done? Help is much appreciated. --- ## [How to speed up for each rows process in a Datatable?](https://forum.uipath.com/t/how-to-speed-up-for-each-rows-process-in-a-datatable/700597)
**Author:** [@tejas.ma](https://forum.uipath.com/u/tejas.ma)\ **Respostas:** 9\ **Última atualização:** [Novembro 20, 2023, 1:44pm UTC](https://forum.uipath.com/t/how-to-speed-up-for-each-rows-process-in-a-datatable/700597 "2023-11-20T13:44:55Z")
Hey everyone i have a csv file that I read as a datatable to perform operations on and after each row i mark another column as “finished” once the process is completed. Later when i reopen the csv file i have to read eac… --- ## [データテーブルの値(カラム含む)を引用符(")で囲みたい](https://forum.uipath.com/t/topic/700862)
**Author:** [@curry](https://forum.uipath.com/u/curry)\ **Respostas:** 2\ **Última atualização:** [Novembro 20, 2023, 1:08am UTC](https://forum.uipath.com/t/topic/700862 "2023-11-20T01:08:20Z")
最終的にはデータテーブルをCSVに出力するのですが、 CSV取込み先のシステムの都合上、値を引用符で囲む必要があります。 現在は以下の方法で引用符で囲んでいますが、 データ数が多くかなり時間がかかってしまうため 他に何か効率の良い方法はないでしょうか。 ①データテーブルのカラムの繰り返しでカラムを引用符で囲う ②データテーブルの各行の繰り返しで値を引用符で囲う 以下のトピック確認しましたが バージョン違いが原因でアクティビ… --- ## [I need solution for below question for CSV file](https://forum.uipath.com/t/i-need-solution-for-below-question-for-csv-file/700647)
**Author:** [@Vicky\_K](https://forum.uipath.com/u/Vicky_K)\ **Respostas:** 2\ **Última atualização:** [Novembro 18, 2023, 7:03am UTC](https://forum.uipath.com/t/i-need-solution-for-below-question-for-csv-file/700647 "2023-11-18T07:03:11Z")
Hi All, I receive data in CSV file format and i receive the data in below format, In above screen shot xyz and abc column have numbers but it don’t have proper format. I need in below format, Note : I received … --- ## [How to convert UiPath DataTable to python pandas DatafFrame](https://forum.uipath.com/t/how-to-convert-uipath-datatable-to-python-pandas-datafframe/274267)
**Author:** [@sufyant](https://forum.uipath.com/u/sufyant)\ **Respostas:** 2\ **Última atualização:** [Novembro 9, 2023, 12:31am UTC](https://forum.uipath.com/t/how-to-convert-uipath-datatable-to-python-pandas-datafframe/274267 "2023-11-09T00:31:29Z")
Hello, I have datatable in my UiPath project. I want to convert this datatable into pandas dataframe and process it with python code. And after doing python operations I want to get it back as UiPath datatable. How can I… --- ## [How do I filter data from a csv file?](https://forum.uipath.com/t/how-do-i-filter-data-from-a-csv-file/642600)
**Author:** [@anlinalbert](https://forum.uipath.com/u/anlinalbert)\ **Respostas:** 3\ **Última atualização:** [Outubro 16, 2023, 4:34pm UTC](https://forum.uipath.com/t/how-do-i-filter-data-from-a-csv-file/642600 "2023-10-16T16:34:13Z")
Hello, I need some help with filtering a csv file. I have a csv file that contains some data, and I want to filter it based on the following criteria: The value in the “Suspicion” column should be greater than 4. Howe… --- ## [Export all Jobs via API Request](https://forum.uipath.com/t/export-all-jobs-via-api-request/595474)
**Author:** [@IvanKurtovic](https://forum.uipath.com/u/IvanKurtovic)\ **Respostas:** 0\ **Última atualização:** [Setembro 19, 2023, 10:06am UTC](https://forum.uipath.com/t/export-all-jobs-via-api-request/595474 "2023-09-19T10:06:34Z")
Hi all, im trying to export all jobs via API request. Im using following endpoint: the request is working fine but im not able to to get the csv file. I dont see any output or jobs What do i need to add to my … --- ## [CSVデータで対になるデータがないものを抽出したいです](https://forum.uipath.com/t/csv/577083)
**Author:** [@y.c](https://forum.uipath.com/u/y.c)\ **Respostas:** 6\ **Última atualização:** [Agosto 31, 2023, 8:12am UTC](https://forum.uipath.com/t/csv/577083 "2023-08-31T08:12:11Z")
いつもお世話になっております。 現在、CSVデータを確認して、売り上げの赤黒伝票が揃っていない、赤伝票のみの場合にその取引IDを取得するロボットを作成しています。 ＜サンプル＞ D列：１が黒、２が赤、それ以外が０ E列：D列が「２」のもので、取り消した元の黒伝票の取引IDが表示されている 現在、①の仕様まで作ってみたのですが、確認で上手くいっていないのと、その先の設計に悩んでいます。 ①赤伝票のD列（打消取引ID）を全て取得… --- ## [Convert several Excel files (\*.xlsx) to CSV files with the same name and sheets](https://forum.uipath.com/t/convert-several-excel-files-xlsx-to-csv-files-with-the-same-name-and-sheets/569858)
**Author:** [@Anaskra](https://forum.uipath.com/u/Anaskra)\ **Respostas:** 11\ **Última atualização:** [Agosto 8, 2023, 1:07pm UTC](https://forum.uipath.com/t/convert-several-excel-files-xlsx-to-csv-files-with-the-same-name-and-sheets/569858 "2023-08-08T13:07:59Z")
Hi everyone, I have a case, where I have to copy/convert all Excel Files in one folder to CSV files. The sheets and names should remain in the CSV file. Currently every Excel file contains one sheet, but every sheet has… --- ## [Unable to maintain the data format in CSV sheet](https://forum.uipath.com/t/unable-to-maintain-the-data-format-in-csv-sheet/567139)
**Author:** [@Sai\_deepthi](https://forum.uipath.com/u/Sai_deepthi)\ **Respostas:** 2\ **Última atualização:** [Agosto 2, 2023, 1:53pm UTC](https://forum.uipath.com/t/unable-to-maintain-the-data-format-in-csv-sheet/567139 "2023-08-02T13:53:07Z")
Iam currently using a workbook to write the data, and require trailing zeroes in a column. I used padleft to write the trailing zeroes. It’s working fine with workbook activities. But when trying to copy the same data t… --- ## [Data from one sheet of Excel extract to three sheets and then make a 3 csv files](https://forum.uipath.com/t/data-from-one-sheet-of-excel-extract-to-three-sheets-and-then-make-a-3-csv-files/558763)
**Author:** [@anama](https://forum.uipath.com/u/anama)\ **Respostas:** 4\ **Última atualização:** [Junho 29, 2023, 12:09pm UTC](https://forum.uipath.com/t/data-from-one-sheet-of-excel-extract-to-three-sheets-and-then-make-a-3-csv-files/558763 "2023-06-29T12:09:57Z")
Dear All, I am struggling to create a robot that uses an information from one excel sheet and then takes data from different columns in this sheet and creates 3 different sheets which are then turned into csv files. Th… [Próxima página](https://forum.uipath.com/tag/csv/21.md?match_all_tags=true&page=1&tags%5B%5D=csv)