If a cell contains 10K characters and you are unable to map it in the column coz of cell limit
You can use a formula column to extract first 7k characters from that column and create another column and extract last 3K characters from the same column
This way you have splitted one big cell into smallers chunks
Also, whatever is retrning your crazy amount of data you can always limit the response you receive from the api