How to Format and Import Data from a Single String into Excel Correctly

Welcome to the Make community!

You can use the built-in function split


{{ split("aaaaa;bbbbb;ccccc"; ";") }}

For more information, see

You can do this in a Set Variable module, then use the built-in function get

e.g.: This will return the third item

{{ get(array; 3) }}

For more information, see


Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —


Help Center Basics

Articles & Videos