You can count the number of values in a single cell in Excel and Google Sheets that are seperated by comma using this function or formula.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.