I want to add a long list of data items from an excel spreadsheet into a data (text) column however this results in all content being placed into a single cell. Is there a way to do this? even pasting a whole column from fresh data would be useful.
Use the collection component instead. It will give you multiple layout to try
Let me know if you need further help!
Are you pasting onto the cell, or clicking inside the cell before pasting? Make sure you are not clicking into the cell, causing the cursor to show. Just make sure the cell is highlighted without clicking again to open it for editing.
That said, I believe you need to have enough rows already added and I’m not sure how many rows can be pasted at one time.
If it’s a lot of data, you may be better off using the Import function instead. This will automatically add as many new rows as are necessary.
how do i add a lot of data items from the preview window, I’m presuming you mean the component item in preview?
Is there a reason you don’t use the import function in your Data view?