# 4.11 CSV import fails with no explanation **URL:** \ **Category:** Programming & Scripting\ **Tags:** unreal-engine\ **Created:** [April 12, 2016, 2:52am UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842 "2016-04-12T02:52:20Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![TarlRaney](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/tarlraney/32/1016964_2.png) [@TarlRaney](https://forums.unrealengine.com/u/TarlRaney)\ **Post date:** [April 12, 2016, 2:52am UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/1 "2016-04-12T02:52:20Z")
Every time I try and import a CSV file, no matter what’s in it, I get this error: Failed to import ‘D:/Projects/Unreal Projects/GamepadKeyboard/Names.csv’. Failed to create asset ‘/Game/GamepadKeyboard/Blueprints/Names’ It never asks what structure to use or what type of file it should be. I’m using Excel 365 and saving the file as .csv. I have data in A1 and a test CSV had this data setup if that helps anyone: ``` ,Age,Gender Bob,45,Male Judy,43,Female Timmy,36,Male ``` Is there anything that I need to set first in the editor to allow data tables? I can’t import by the Import button, drag and drop or creating a data table then trying to reimport. Any help would be greatly appreciated. ---
**Author:** ![GraeChan](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@GraeChan](https://forums.unrealengine.com/u/GraeChan)\ **Post date:** [April 12, 2016, 3:17pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/2 "2016-04-12T15:17:48Z")
Have you created the BlueprintFunctionLibrary C++ class and defined the data in a USTRUCT? Did you remember to leave A1 title blank? Also make sure no spaces are in the titles including A1. Are you making sure you are saving as normal .csv and not .csv(mac) or .csv(ms-dos)? > **[Data Driven Gameplay Elements](https://docs.unrealengine.com/4.27/en-US/InteractiveExperiences/DataDriven/)** > > Driving gameplay elements using externally stored data. > **[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... ---
**Author:** ![TarlRaney](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/tarlraney/32/1016964_2.png) [@TarlRaney](https://forums.unrealengine.com/u/TarlRaney)\ **Post date:** [April 12, 2016, 5:03pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/3 "2016-04-12T17:03:48Z")
I didn’t think I had to do any C++. I was following a tutorial that showed how to do it in BP. Maybe I missed a step or something. Otherwise, none of those other issues should be a problem. As stated above, it’s not asking for any type of struct so I don’t think it’s even getting that far. I’ve also tried an empty CSV to no avail. ---
**Author:** ![TarlRaney](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/tarlraney/32/1016964_2.png) [@TarlRaney](https://forums.unrealengine.com/u/TarlRaney)\ **Post date:** [April 12, 2016, 5:05pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/4 "2016-04-12T17:05:48Z")
BTW, I create a struct in BP that had the same two column headers for what it’s worth. ---
**Author:** ![TarlRaney](https://d1ap1mz92jnks1.cloudfront.net/user_avatar/forums.unrealengine.com/tarlraney/32/1016964_2.png) [@TarlRaney](https://forums.unrealengine.com/u/TarlRaney)\ **Post date:** [April 12, 2016, 9:55pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/5 "2016-04-12T21:55:20Z")
Finally got around to trying again today and it worked fine. No idea what was up, I didn’t do anything different. guess this can be closed. ---
**Author:** ![GraeChan](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@GraeChan](https://forums.unrealengine.com/u/GraeChan)\ **Post date:** [April 13, 2016, 1:50pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/6 "2016-04-13T13:50:36Z")
Glad you got it working; sometimes when I have problems with Blueprints I find closing project and Unreal Launcher then loading everything again can solve problem. ---
**Author:** ![Dinfael](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@Dinfael](https://forums.unrealengine.com/u/Dinfael)\ **Post date:** [August 25, 2016, 4:37am UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/7 "2016-08-25T04:37:38Z")
Hi, actually there is a proper answer to this issue, which is : .csv cannot be imported into UE4 if they are already opened in another software. To avoid the aforementioned issue you must make sure the document is closed, then import it. ---
**Author:** ![BakonKing](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@BakonKing](https://forums.unrealengine.com/u/BakonKing)\ **Post date:** [September 13, 2016, 6:22am UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/8 "2016-09-13T06:22:23Z")
Yep, I can vouch for this. Had this exact problem today, finally hit upon it by accident. Kind of annoying that you have to close it in Excel each time you want to reimport. ---
**Author:** ![chillipanda](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@chillipanda](https://forums.unrealengine.com/u/chillipanda)\ **Post date:** [October 17, 2016, 1:16pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/9 "2016-10-17T13:16:12Z")
Just had the same issue, thanks Dinfael. Logical when you look at it, a file open for write in another applications means you may not have the latest. Would be nice to have a sensible message like file already opened, as it barfs before it asks you to select the data table import format etc. sign of a poorly written error messages in the unreal engine SDK. ---
**Author:** ![noxxxxxious](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@noxxxxxious](https://forums.unrealengine.com/u/noxxxxxious)\ **Post date:** [November 25, 2016, 6:28pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/10 "2016-11-25T18:28:26Z")
Tripling up to say that this was the error I was having. The instant I closed Excel was the instant I could successfully import the CSV. You rule, Dinfael. ---
**Author:** ![David\_Oaken](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@David\_Oaken](https://forums.unrealengine.com/u/David_Oaken)\ **Post date:** [April 26, 2017, 5:32am UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/11 "2017-04-26T05:32:44Z")
Thanks for that Dinfael, fixed my issue. was driving me nuts 🙂 ---
**Author:** ![Spoondog](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@Spoondog](https://forums.unrealengine.com/u/Spoondog)\ **Post date:** [January 30, 2019, 2:39am UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/12 "2019-01-30T02:39:40Z")
Thank you. Very weird… surely the engine could create a temporary copy or something to get around this. ---
**Author:** ![phil123456](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@phil123456](https://forums.unrealengine.com/u/phil123456)\ **Post date:** [September 21, 2020, 5:13pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/13 "2020-09-21T17:13:22Z")
yep that was the issue fu cking unreal ---
**Author:** ![Meisterlol](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@Meisterlol](https://forums.unrealengine.com/u/Meisterlol)\ **Post date:** [March 11, 2022, 5:16pm UTC](https://forums.unrealengine.com/t/4-11-csv-import-fails-with-no-explanation/353842/14 "2022-03-11T17:16:07Z")
You have to close your Excel =)