Explode JSON functionality allows a user to correctly parse/separate a file that may have not uploaded correctly. A column may look like this:
When it should appear as the following:
How to Explode JSON
Step 1: Open a Sheet and select Functions > Explode JSON.
Step 2: Select the designated column to explode and Apply.