Import CSV data using FeedMe plugin into entries with Matrix fields

Question

I would like to import a CSV file into but the entries contain Matrix fields. When I set up the file, FeedMe provides a way to map columns in the CSV file to specific Matrix fields but I can't find a way to format the CSV file in a way that will allow FeeMe to generate multiple Matrix entries.

Example:
The CraftCMS entry has a Matrix field called References and this field has one block with two fields: Reference Title and Reference URL.

The CSV file has two columns Reference Title and Reference URL which I have mapped accordingly using FeedMe. For some entries I have multiple references so I need FeedMe to create one Matrix entry for each reference.

I have tried using the delimiter -|- between the title like so:

Reference Title                 Reference URL    
Example Ref1 -|- Example Ref 2; https://example1.com -|- https://example2.com

but FeedMe generates only one entry that contains both titles and URLs:

• Reference Title ends up as: ["Example Ref1","Example Ref 2"]
• Reference URL ends up as ["https://example1.com" -|- "https://example2.com"]

Is there a way to format the CSV in way that will make FeedMe generate two separate Matrix entries?

Answer 1

You may want to ignore my comment above - I discovered that there's an option to set a dataDelimiter character (docs) which should help with your CSV import, as described in this SE answer.