Large text with several lines in one excel cell

Large text with several lines in one excel cell

Postby umuteren1 » Fri Jun 28, 2024 12:27 pm

Hi, I am trying to create a new deck with several cards with excel spreadsheet. I copied and pasted several lines into one excel cell. When I upload these cards, instead of creating one card, flashcard delux website creates several card for eac line, which are in one excel cell, instead of creating one card that will include these several lines in one card. How can I overcome this issue ? Thanks in advance.
umuteren1
 

Re: Large text with several lines in one excel cell

Postby Ernie » Fri Jul 05, 2024 1:34 pm

Hi. I'm sorry for the very slow response. If you can use OneDrive, Dropbox, or Google Drive to transfer, you shouldn't have this problem. Are you using my website? When you copy-paste from Excel into the website, the paste process should put quotes around the entire text if new-lines exist in a cell. Keep in mind that a new-line usually means a new card, so new lines in a cell can be tricky to interpret. There needs to be double-quotes around the complete text. Then the website import process should be able to interpret. But I've seen some cases where quotes don't get added when pasting. Or if you already have quotes in your text, this could also cause complications. If you still need guidance, I recommend you email me (et@orangeorpple.com) and send me an Excel file and I can try on my end.
Ernie
Site Admin
 
Posts: 5075
Joined: Fri Oct 01, 2010 6:12 pm
Location: San Francisco / Taiwan

Return to Comments, Questions and Feedback