Configurable list widget data will not export in separate columns

I created a table to easily capture information, however, when it is exported, all information in all rows are exported to one column in an excel spreadsheet. (even exporting as CSV)

You are using the configurable list widget. I'm sorry, but there's no currently no way you can export the data on this widget into multiple columns in excel/CSV. 

You need to either separate them manually or try using split function in excel:

https://support.office.com/en-us/article/Split-names-by-using-the-Convert-Text-to-Columns-Wizard-39f7b055-6b39-4cb5-9512-13cc19b3a807

https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7