# Idiots guide to importing CSV files

**URL:** <https://forums.unrealengine.com/t/idiots-guide-to-importing-csv-files/298580>\
**Category:** Programming & Scripting\
**Tags:** unreal-engine\
**Created:** [November 9, 2014, 8:29pm UTC](https://forums.unrealengine.com/t/idiots-guide-to-importing-csv-files/298580 "2014-11-09T20:29:06Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Everynone](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/everynone/32/1135017_2.png) [@Everynone](https://forums.unrealengine.com/u/Everynone)\
**Post date:** [November 9, 2014, 10:03pm UTC](https://forums.unrealengine.com/t/idiots-guide-to-importing-csv-files/298580/4 "2014-11-09T22:03:30Z")

</div>

You will need Rama’s plugin:

> **[A new, community-hosted Unreal Engine Wiki](https://forums.unrealengine.com/t/a-new-community-hosted-unreal-engine-wiki/141494)**
>
> After over a year in maintenance mode, the official Unreal Engine Wiki is now permanently offline. These resources now live on a new community-run Unreal Engine Community Wiki — ue4community.wiki! You will be able to find content from the official...

The node you are interested in: _Load String Array From File_

**A.** This is my Excel file. Vertical bar (|) is used a separator. Since I need commas in the sentences, I use ‘|’ instead of handling comma-separated values.

 ![20571-excel.jpg](https://d3kjluh73b9h9o.cloudfront.net/original/4X/a/9/3/a938505b67cc8c6df5f91697d87afe45f0cb6207.jpeg)

**B.** Once copied to a text file, it looks messy.

 ![20570-textfile.jpg](https://d3kjluh73b9h9o.cloudfront.net/original/4X/9/f/8/9f80a364faefd7e26ab97d5eb2b25b321598d1cd.jpeg)

**C.** And the blueprint:

 ![20572-bpsetup.jpg](https://d3kjluh73b9h9o.cloudfront.net/original/4X/e/0/e/e0e85a0651c155476cd92a9a4469534295ddcf59.jpeg)

**D.** What happens here.

1. Loop through the array and explode each line into 7 elements using ‘|’ as a delimiter.
2. _Limit_ will prevent reading further down the road, 8th element will be skipped in this instance.
3. You can get one of the 7 strings directly from the array outputted by the explode node.

Let me know if it works as intended! :\>

---

_[View the full topic](https://forums.unrealengine.com/t/idiots-guide-to-importing-csv-files/298580)._