LibreOffice contains a very powerful database tool that is actually quite user friendly. Here's how to create a database query using the Design View tool.

Learn how to use Excel Power Query's extract and split column features to extract delimited strings into their components.

Storing the data independent of the SaaS database provides greater flexibility to transform, join, cleanse, cube, or aggregate data as required by downstream users and applications.