# Unreal Engine To Microsoft Excel **URL:** \ **Category:** Blueprint\ **Tags:** transfer, unreal-engine, UE4, Blueprint, question\ **Created:** [April 20, 2017, 2:29am UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382 "2017-04-20T02:29:38Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![anonymous\_user\_f4d93b8d](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@anonymous\_user\_f4d93b8d](https://forums.unrealengine.com/u/anonymous_user_f4d93b8d)\ **Post date:** [April 20, 2017, 2:29am UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/1 "2017-04-20T02:29:38Z")
I am looking to transfer inputted data from a built unreal engine game into an excel database. Any thoughts on this ? ---
**Author:** ![BlueMind\_Studio](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@BlueMind\_Studio](https://forums.unrealengine.com/u/BlueMind_Studio)\ **Post date:** [April 20, 2017, 11:36am UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/2 "2017-04-20T11:36:03Z")
Yes. Input your Values into a “Data Table” component. This can be exported/imported as CSV (or JSON!) which is great for adjusting and managing in Excel. Or do you mean runtime data? It’s harder because dataTable can’t be altered at runtime. Think you can use the JSON Plugin or need some C++ for that ---
**Author:** ![anonymous\_user\_f4d93b8d](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@anonymous\_user\_f4d93b8d](https://forums.unrealengine.com/u/anonymous_user_f4d93b8d)\ **Post date:** [April 25, 2017, 12:27am UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/3 "2017-04-25T00:27:24Z")
I do mean runtime data, for example someone using a phone or tablet would be inputting data into ue4 software, and that data would update an excel spread sheet at the same time on a computer. Sounds like I need to learn about what JSON is… ---
**Author:** ![BlueMind\_Studio](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@BlueMind\_Studio](https://forums.unrealengine.com/u/BlueMind_Studio)\ **Post date:** [April 26, 2017, 12:52pm UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/4 "2017-04-26T12:52:18Z")
hm, ok runtime is a other story. Possible would be creating a small c++ object containing a structure and a method to export as CSV! you can work quite well in excel with a csv. the next question is how to save it somewhere the excel on the pc get the data from…there are several ways how to connect excel to this external data source. (Network/Internet=\>Database, Lokal Network maybe an CSV/XML on a netshare ([XmlParser | Unreal Engine Documentation](https://docs.unrealengine.com/latest/INT/API/Runtime/XmlParser/index.html)) …) if you want to send the entered data back to a api server and save it for example in a mongo db, then i would suggest json. i think the cleanest and easiest way is: “UE Client → Push data to MySql-DB ← Excel read Data from DB”…but you see - it strongly depends on your requirements and environment, just want to give you some ideas. ---
**Author:** ![anonymous\_user\_f4d93b8d](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@anonymous\_user\_f4d93b8d](https://forums.unrealengine.com/u/anonymous_user_f4d93b8d)\ **Post date:** [April 27, 2017, 12:54am UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/5 "2017-04-27T00:54:44Z")
Thanks so much for your time, I feel like you have answered my question but my knowledge holds me back from completely understanding. I am going to save this and reference it well I attempt to follow your suggested workflow. Thanks again for your help ! ---
**Author:** ![Two-faced](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@Two-faced](https://forums.unrealengine.com/u/Two-faced)\ **Post date:** [April 27, 2017, 7:59pm UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/6 "2017-04-27T19:59:28Z")
Try to use for ex. Victory plugin and simply save your stuff in files using strings. You can always import this files to excel after. ---
**Author:** ![BlueMind\_Studio](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@BlueMind\_Studio](https://forums.unrealengine.com/u/BlueMind_Studio)\ **Post date:** [April 27, 2017, 8:04pm UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/7 "2017-04-27T20:04:18Z")
Can you provide some more details of your setup? Meaning you have a “backend” where one sits with a Excel wants to read in data. The Dataentry happens on Tablet - are they connected via WLAN/Internet to this “Backend”? Do you want the data “Online”/Immediate or could it sync on some time? Is there only one “Client” doing the Dataentry or do you have several Clients from which the data needs to be sorted out of Duplicates eg or entering data at the same time? Btw, I think it is not a big deal if you know what you’re doing (as always 🙂 ) - maybe it is a option for you to post it detailed in the forum as a paid/unpaid Project and you find someone doing it for you? ---
**Author:** ![anonymous\_user\_f4d93b8d](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@anonymous\_user\_f4d93b8d](https://forums.unrealengine.com/u/anonymous_user_f4d93b8d)\ **Post date:** [April 29, 2017, 12:51am UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/8 "2017-04-29T00:51:01Z")
Immediate sync would be preferable, as this software would be more used as a managers tool to keep tabs on employees and their sales orders, it would also make it so employees could notify the manager with status of orders or if issues with product occur or they need help ect. It would take place in the same warehouse and not have to be worldwide access ect. The excel spreadsheet would be based on the managers computer, well employees had IPADS with ue4 software they could use to input the data for manager to review. lol ya maybe i should put it in more detail into the forums and offer some cash. The job is yours if you want it, haha name your price. ---
**Author:** ![LiveSimulator](https://d3kjluh73b9h9o.cloudfront.net/original/4X/2/8/5/28502927f1d97ba1051b3b47ccfe17233bf41ef0.png) [@LiveSimulator](https://forums.unrealengine.com/u/LiveSimulator)\ **Post date:** [September 2, 2019, 10:53pm UTC](https://forums.unrealengine.com/t/unreal-engine-to-microsoft-excel/391382/9 "2019-09-02T22:53:22Z")
Might as well update this for google searches - there is a plugin for Unreal to directly export various data to excel, including formatting options [DirectExcel in Code Plugins - UE Marketplace](https://www.unrealengine.com/marketplace/en-US/slug/directexcel)