Variable Text : Only first row is importing to Lightburn

I am busy designing a school timetable and use variable text, everything is working except when I import the csv file from excel, only the first row repeats in all the other rows.


This is my template in lightburn

This is my excel spreadsheet

When I import the excel spread sheet, it repeats the first row in all the other rows.
How can I change it, or what do I have to do or change, to correct this?

Thank you

That is working as designed. The %0-%10 is representing the 1st to the 11th field left to right. You have the same thing repeated 5 times vertically. if you use the “next” button, you will get then same thing, but with the 2nd line of your spreadsheet repeated 5 times vertically. Are you generating multiple different timetables? if so, you’d have to change the format of your spreadsheet to be 44 cells wide, with each row representing the 5 day timetable, and in lightburn, put 0-10 in the first row, 11-21 in the 2nd row etc etc.

If you want the entire spreadsheet output as it is you need to change the offset for each line. First line remains as 0, 2nd line 1, 3rd line 2, etc.

2 Likes

Yes, I realized that my offset was wrong, that’s why the first line repeat itself. My offset was 0 for the entire table. I changed that, and it is now working.

Thank you

2 Likes

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.