How to prevent CSV data that exceeds spreadsheet cell character limit from spilling over to neighboring cells?

When I open my CSV in excel, LibreOffice Calc, or Google Sheets, the character limit per cell is exceeded and the data in one cell spills over into the neighboring cells. How can I prevent this, so that the file maintains its original structure? Alternatively, is there another way I can edit this file that avoids this issue? Or if not, is there a way to cut off anything that exceeds the cell character limit so that I can use the spreadsheet properly?