I have many song lyrics, and they're stored individually in Excel cells. I gradually acquire them in bulk and then manually add them one by one to labels.
I don't know if there's a way to do this automatically, like the "Text File to Label" option, but the difference is that these are lyrics, which are different from labels.
Is there an option that reads Excel files cell by cell and adds them to the "UNSYNCEDLYRICS" labels?
There is no function that deals with Excel files directly.
The only way to import data from external files is with Convert>Text file - Tag. So you would have to export the data from Excel first into a text file.
The text file has to have the structure of 1 line per file.
See the documentation:
Thanks for the information, I already knew that, since the letters have too many lines and that's why the function you mentioned doesn't work, but it's very useful for changing labels by copying the authors or title from an Excel file to a txt file.
You could transform the data first e.g. replace the carriage returns and linefeeds into a character that does not appear in the lyrics, e.g. the # or the _ so that the text becomes 1 line and then import it and then use $Replace() to get the line breaks back.