MMEX Discussion Forum

Is there a way to parse multiple Tags upon import of a CSV?

I have labeled my raw CSV rows with one to many tags per row. When I attempt importing multiple tags that are separated by a semicolon, MMEX interprets it as one string.

For example, my CSV looks like this:
Amount,Type,Category,SubCategory,Tags
-240.00,Withdrawal,Sports,Basketball,Amy;Brian

I want "Amy" to come in as a tag, and "Brian" to come in as a tag. MMEX is instead creating a new tag called "Amy;Brian".

Since the delimiter is a comma, Amy;Brian is considered a single value.
I don't know whether multiple tags can be imported, but you can try replacing the ; with a ,

SereneLandscape wrote: Sat Jan 24, 2026 8:47 pm Is there a way to parse multiple Tags upon import of a CSV?

I have labeled my raw CSV rows with one to many tags per row. When I attempt importing multiple tags that are separated by a semicolon, MMEX interprets it as one string.

For example, my CSV looks like this:
Amount,Type,Category,SubCategory,Tags
-240.00,Withdrawal,Sports,Basketball,Amy;Brian

I want "Amy" to come in as a tag, and "Brian" to come in as a tag. MMEX is instead creating a new tag called "Amy;Brian".

Renato’s suggestion may actually cause some issues (and I hope he’ll forgive me for contradicting him ) .
Replacing with does not work when the comma is used as the CSV delimiter, because it would be interpreted as the start of a new column, potentially shifting or breaking the following data.

Replacing with a space, instead, avoids breaking the CSV import and allows MMEX to correctly interpret the values as multiple separate tags.
I have personally tested this solution and I am still using it successfully.

Fantastic - thank you for your replies.

I have successfully imported data with the tag values separated by spaces, and it came in perfectly.

MMEX is an impressive program. Thank you for the great help documentation and the "Using Tags in Reports" section. I look forward to grouping by tags to be available in official MMEX reports.