# CSV import comma **URL:** \ **Category:** Get Help\ **Created:** [July 25, 2022, 7:56am UTC](https://forum.adalo.com/t/csv-import-comma/29912 "2022-07-25T07:56:43Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 25, 2022, 7:56am UTC](https://forum.adalo.com/t/csv-import-comma/29912/1 "2022-07-25T07:56:43Z")
Hello, I want to import a lot of text in Adalo database with CSV import function. Unfortunately in the text, there are commas… Is it posible to tell adalo to use another symbol instead of comma ? Or is it possible to tell adalo the commas are the text and not commas for the CSV. For exemple with “,” or with ,. ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 25, 2022, 9:36am UTC](https://forum.adalo.com/t/csv-import-comma/29912/2 "2022-07-25T09:36:10Z")
Hi @Nirvana, You mean you want to import the commas too or not? Thank you ---
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 25, 2022, 10:10am UTC](https://forum.adalo.com/t/csv-import-comma/29912/3 "2022-07-25T10:10:59Z")
Yes I want to import the commas too. I found a workaround, I delete the commas before importation. Then I add the commas in Adalo. But it’s a waste of time. ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 25, 2022, 10:14am UTC](https://forum.adalo.com/t/csv-import-comma/29912/4 "2022-07-25T10:14:25Z")
I just tried exporting a collection that has commas in the texts and again when I import that CSV in Adalo I got the commas. If you don’t get them you can use Google sheet and download and then upload! : [Ñ Symbol showing "?" - #4 by dilon\_perera](https://forum.adalo.com/t/n-symbol-showing/19062/4) , [Accent marks don't come through when I upload a csv - #2 by dilon\_perera](https://forum.adalo.com/t/accent-marks-dont-come-through-when-i-upload-a-csv/22285/2) ---
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 25, 2022, 10:54am UTC](https://forum.adalo.com/t/csv-import-comma/29912/5 "2022-07-25T10:54:45Z")
If I have 2 text fields of text. For example in the cv: Word 1, word 2, word 3, word 4 It may be understood by Adalo: Text 1: Word 1 Text 2: word 2, word 3, word 4 Or Text1: Word 1, word 2 Text2: word 3, word 4 Or Text1: Word 1, word 2, word 3 Text2: word 4 ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 25, 2022, 10:56am UTC](https://forum.adalo.com/t/csv-import-comma/29912/6 "2022-07-25T10:56:10Z")
You need to create different rows for each word? ---
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 25, 2022, 7:32pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/7 "2022-07-25T19:32:23Z")
In my example with these 4 words and commas. If I have only 2 text fields, how Adalo will understand the csv : Word 1, word 2, word 3, word 4 ? And how to change its understanding if I need to. For example if Adalo use the first coma to separate the field 1 and the field 2 (so field 1 would be « word 1 » and field 2 would be « word 2, word 3, word 4 ») but I wanted the field 1 is « word 1, word 2 » and the field 2 is « word 3, word 4 ». Is it clear? ---
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 26, 2022, 7:25pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/8 "2022-07-26T19:25:25Z")
@Dilon do you understand the problem ? ---
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 28, 2022, 9:07pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/9 "2022-07-28T21:07:46Z")
My example was a bit tricky to understand. Let’s simplify. If I want to create with CSV in 1 text field this sentence: “Hello, I’m fine”. How to do it with the comma in my sentence ? ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 28, 2022, 10:11pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/10 "2022-07-28T22:11:34Z")
I think then you need to cut them down like that in your CSV and then upload it on Adalo! ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 28, 2022, 10:12pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/11 "2022-07-28T22:12:29Z")
You mean add the comma after Hello too? It doesn’t add? ---
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 28, 2022, 11:52pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/12 "2022-07-28T23:52:09Z")
Yes I want to add the comma too. I want my text field to be: « hello, I am fine » Adalo understands the comma after « Hello » like the end of the field. And so « I am fine » is another field. How to tell Adalo it’s not a comma for separation but it’s the same field ? ---
**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\ **Post date:** [July 29, 2022, 8:02am UTC](https://forum.adalo.com/t/csv-import-comma/29912/13 "2022-07-29T08:02:09Z")
Once you add **hello,I am fine** in the CSV and upload it on Adalo you don’t get the comma? Is it possible to explain this from a video showing the CSV and the setup? ---
**Author:** ![Nirvana](https://avatars.discourse-cdn.com/v4/letter/n/ee7513/32.png) [@Nirvana](https://forum.adalo.com/u/Nirvana)\ **Post date:** [July 29, 2022, 8:35pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/14 "2022-07-29T20:35:12Z")
I am stupid. I used CSV without " ". It worked but with " " it solved my comma problem. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\ **Post date:** [August 8, 2022, 8:35pm UTC](https://forum.adalo.com/t/csv-import-comma/29912/15 "2022-08-08T20:35:47Z")
Closed on August 8, 2022, 8:35pm UTC This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.