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

[Sune_Moldt]

Hello everyone,

I’m working with a product feed that I download using the “HTTP → Get A File” method. When I fetch the URL, it retrieves a lot of information, but it’s all in a single string, not separated in a way that allows me to easily import it into Excel.

The data comes in a format like this: aaaaa;bbbbb;ccccc (each piece of data separated by semicolons). I’m looking for advice on how to format this string so that each piece of data (aaaaa, bbbbb, ccccc, etc.) can be imported into separate cells or columns in Excel.

Does anyone have any suggestions on tools or techniques that could help split this string into a format that Excel can work with more easily? Ideally, I’d like to automate this process to make handling future data more efficient.

Thanks in advance for your help!

[samliew]

Welcome to the Make community!

You can use the built-in function split

e.g.:

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

For more information, see https://www.make.com/en/help/functions/string-functions#split--text--separator-

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 https://www.make.com/en/help/functions/general-functions#get--object-or-array--path-

Links

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 —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← CHECK THIS OUT
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array ← CHECK THIS OUT
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make