To get the data into separate columns in Excel, you could use the "Text to Columns" feature. In Excel, select the column with the data, go to the "Data" tab, and choose "Text to Columns." Then, just choose the delimiter (in your case, a comma or semicolon) to split the data into multiple columns.
Alternatively, if you're working with a more complex file structure, you might want to explore using some VBA scripting to automate the process. There are plenty of guides online that walk through the specifics of writing data to a file in a structured format, which might be exactly what you need. For example, you can check out www.myexcelonline.com for some tips on how to manage CSV files and automate data processing in Excel.