# Trouble with importing .csv file to make cards with long texts

**URL:** https://forums.ankiweb.net/t/trouble-with-importing-csv-file-to-make-cards-with-long-texts/12704
**Category:** Help
**Created:** [August 27, 2021, 3:59pm UTC](https://forums.ankiweb.net/t/trouble-with-importing-csv-file-to-make-cards-with-long-texts/12704 "2021-08-27T15:59:35Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![matteo.rabagliati](https://avatars.discourse-cdn.com/v4/letter/m/50afbb/32.png) [@matteo.rabagliati](https://forums.ankiweb.net/u/matteo.rabagliati)
#### Post date: [August 27, 2021, 3:59pm UTC](https://forums.ankiweb.net/t/trouble-with-importing-csv-file-to-make-cards-with-long-texts/12704/1 "2021-08-27T15:59:35Z")

</div>

Hello!

I’m new to Anki, so I hope that it’s not something obvious that i missed.  
I tried to follow a tutorial on how to import cards into a deck through a .csv spreadsheet, with the basic Front/back card format, but, probably due to the fact that I’m trying to make a fairly long body of text fit into it, when I import the .csv file the two fields get mixed together and a big part of the second one gets cut.

This is the result:

 ![anki prova](https://us1.discourse-cdn.com/flex002/uploads/anki2/original/2X/5/5b6c23deacba2a74c958b6d43235b0ec33f4fd43.png)

I tried to do the same thing with just a couple of words for each field and that worked fine, and I also tried to add a card manually to a deck and there were no problems either, so I’m assuming that the problem lies in how I’m approaching the compilation of the .csv file.  
Is there any limit on the characters you’re allowed to use in the spreadsheet for it to be used in the basic format?

Thanks for your answers!

Matteo

---

<div class="post-metadata">

### Author: ![gnomek](https://avatars.discourse-cdn.com/v4/letter/g/e79b87/32.png) [@gnomek](https://forums.ankiweb.net/u/gnomek)
#### Post date: [August 27, 2021, 7:11pm UTC](https://forums.ankiweb.net/t/trouble-with-importing-csv-file-to-make-cards-with-long-texts/12704/2 "2021-08-27T19:11:25Z")

</div>

You need to figure it out by yourself but pay attention to Field delimiter and string delimiter as you save csv. If you put inside spreadsheet cell the same sign as you use for a separator Anki will be confused.

In LibreOffice Calc there are options for it:

 ![](https://us1.discourse-cdn.com/flex002/uploads/anki2/original/2X/d/d8084455f64bb465b553203e6bc2cf96b9920105.png)

Also check if “Allow HTML in fields” in Anki import options makes a difference.

---

<div class="post-metadata">

### Author: ![matteo.rabagliati](https://avatars.discourse-cdn.com/v4/letter/m/50afbb/32.png) [@matteo.rabagliati](https://forums.ankiweb.net/u/matteo.rabagliati)
#### Post date: [August 28, 2021, 11:52am UTC](https://forums.ankiweb.net/t/trouble-with-importing-csv-file-to-make-cards-with-long-texts/12704/3 "2021-08-28T11:52:12Z")

</div>

Thanks a lot, the problema was the field delimiter indeed.  
I changed it in the region settings of my pc from “,” to “;” and used that to separate the data in the two columns.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex002/uploads/anki2/original/1X/8f1279ababc5879d54e4838989f606cfe55af8c7.jpeg) [@system](https://forums.ankiweb.net/u/system)
#### Post date: [May 1, 2023, 4:53am UTC](https://forums.ankiweb.net/t/trouble-with-importing-csv-file-to-make-cards-with-long-texts/12704/4 "2023-05-01T04:53:35Z")

</div>