Search Unity. Log in Create a Unity ID. Unity Forum. Forums Quick Links. Asset Store Spring Sale has begun! Unite Now has started!
Come level up your Unity skills and knowledge. Joined: Jul 9, Posts: Hi all, For my games, I tend to put as much of the game data such as in game item prices, unlock levels etc as I can out into separate config files to enable tuning the game without needing to modify the code. For this I normally use Excel to create the config files, and then convert them to json so they can be easily read in via code.
Anyway, I've made a simple Editor plugin that allows you to convert excel files to json within Unity. You can do it manually via a window or it can be performed automatically whenever Unity refreshes such as after an script change for example.
If this is useful to anybody else, you can grab it from here. Notes: Supports. Supports multiple sheets per file. Each sheet is saved separately to a Json file with the same name. Sheet1 saved to Sheet1. It should work on Windows also, but you may need to delete the Mono folder within ExcelToJsonConverter directory otherwise there may be a conflict with System.
SimteractiveDevJul 19, Joined: Sep 29, Posts: Hey Thank you very much, it is really useful. KhaledMNov 5, Joined: May 28, Posts: Second that. This is just what I needed. KristianHJJan 18, No problem, glad it's useful to others. SimteractiveDevJan 19, Joined: Sep 14, Posts: 3.
How To Convert Excel Spreadsheet to JSON
The dark mode beta is finally here. Change your preferences any time. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. I assume that your excel sheet is not complicated so that it can be stored as CSV. Obviously, you can implement any required logic during the process.
The above code use com. It is not advertised for this purpose, but it does it simply, and very well. There is one caveat -- you must have 64 bit Java installed. I recommend you go through their 3, brief, video tutorials before working with your data. OpenRefine will not corrupt your data, as it works with an in-memory copy of your data on your local computer; the tutorial helps you to better understand and use the tool. When you are ready, create a new project.
While your project is being created, the JSON is being generated. If it is already formatted to your liking, just click on the Export button, and you're done. If not, you can modify the template by adjusting the settings in one or more of the panels on the left.
Asked 2 years ago. Active 1 year, 1 month ago. Viewed 6k times. Active Oldest Votes. SerefAltindal SerefAltindal 2 2 silver badges 11 11 bronze badges. Why is it not coming in sequence in a JSON file?
What wrong in reading. Allan Allan 11 2 2 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.Keep in touch and stay productive with Teams and Officeeven when you're working remotely.
You can then use the Query Editor to edit query steps to shape or transform data. For more information, see Shape data. For steps, see the Office tab of this article. It works mostly the same as Power Query, but it's not an add-in - it comes installed, and you'll find it on the Data tab of the ribbon. The following sections provide steps for connecting to your data sources - web pages, text files, databases, online services, and Excel files, tables, and ranges.
In the Comma-Separated Values Browse dialog box, browse for or type a path to the file that you want to query. For example, if you imported the example CSV file below, Power Query automatically uses the first row as the column names and changes each column data type.
These automatic actions are equivalent to manually promoting a row and manually changing each column type. For example:. If prompted, in the From Table dialog box, you can click the Range Selection button to select a specific range to use as a data source. If the table or range of data has column headers, you can check My table has headers.
The header cells are used to define the column names for the query. Plain data will automatically be converted to a table when it is loaded into the Query Editor. In the Excel Browse dialog box, browse for or type a path to the file that you want to query. You can also use the Query Editor to write formulas for your query. In the Access Web dialog box, click a credentials option, and provide authentication values.
Power Query will analyze the web page, and load the Navigator pane in Table View. If you know which table you want to connect to, then choose it from the list. For this example, we chose the Results table. Otherwise, you can switch to the Web View and pick the appropriate table manually. In this case, we've selected the Results table. Click Loadand Power Query will load the web data you selected into Excel.
Optionally, you can specify a Database Name as well. If you want to import data using a native database query, specify your query in the SQL Statement box.
Windows : This is the default selection. Select this if you want to connect using Windows authentication.
After you select this, specify a user name and password to connect to your SQL Server instance. By default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect. If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted connection.
Click OK in the message to connect using an unencrypted connection. You can also use the Query Editor to write formulas for Power Query. In the next dialog box, select from Default or CustomWindowsor Database connection options, enter your credentials, then press Connect. In the Navigator pane, select the tables or queries that you want to connect to, then press Load or Edit. Follow the steps in the Navigator dialog to connect to the table or query of your choice.Released: Aug 9, View statistics for this project via Libraries.
Author: Toran Sahu Tags excel to json, xlsx to json, xls to json, xlsx, xls, json. Maintainers toransahu. Features Download as package using pip and use in your code. Project details Project links Homepage. Release history Release notifications This version. Download files Download the file for your platform. Files for excel2json-3, version 0. Close Hashes for excel2jsonGitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
If nothing happens, download GitHub Desktop and try again. If nothing happens, download Xcode and try again. If nothing happens, download the GitHub extension for Visual Studio and try again. Please note this has only been tested on Unity Mac. How to call from code: Note: This is not designed for runtime use although it should work in runtime, but will be slow. Skip to content. Dismiss Join GitHub today GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
Sign up. A Unity plugin to convert Excel files to Json. C Branch: master. Find file. Sign in Sign up. Go back. Launching Xcode If nothing happens, download Xcode and try again. Latest commit Fetching latest commit…. Select input folder where Excel files are located. Select output folder to save Json files. Hit "Convert Excel Files" button.This is a markdown table converter. When you edit the above Excel-like cells, or import existing json, csv, excel, html table and other data through the Import menu, the converter will automatically generate a markdown table.
Customize the markdown table format by changing the options on the right. Use this tool to edit and generate xml, or use the Import menu to convert excel, json, html table, and markdown table to xml. Compress xml or escape special xml symbols on the right. If you want to insert excel, csv, json, markdown table code into the web page, then this converter can help you convert them to HTML table code.
You can also generate and edit html tables similar to excel. This is an online LaTex table generator and editor, which can generate LaTex tables from excel, csv, json, html table, markdown table, etc. This is a json converter that provides the ability to convert excel, csv, markdown table, and html table to json 2d array. This is a two dimensional array generator and editor for the json syntax.
In addition to editing cells, you can also import excel, json, markdown table, html table code through the Import menu, or even load csv from a url: Example 2. Change the option on the right in order to output a special csv. Interactively edit and generate tables and export them to plain text, which great for source code comments, plain text emails, text documents etc. Click on the selector to select one of the predefined style. This is an online MediaWiki table generator and editor, which can generate MediaWiki tables from excel, csv, json, html table, markdown table, etc.
This is an online BBCode table generator and editor, which can generate BBCode tables from excel, csv, json, html table, markdown table, etc.
Options Copy Download. Markdown table generator and editor. Escape special markdown symbols. Pretty-print your markdown. Use simple markdown table. Bold first row. XML generator and editor. Escape special XML symbols. Minify or Compress XML.For all the examples, lets suppose that our excel file has two sheets, named as 'sheet1' and 'sheet2'. You will notice that if your sheet has some top rows setup as a header it is very commonthe first position of our result will have this data, which in this case it should not be very useful.
So we can tell the module how many of the rows are headers, so we can skip them and get only the data. Gets all the rows, for each sheet, but defining which columns should be returned and how they should be named on the result object. Gets all the rows, for each sheet, but defining which columns should be returned and how they should be named on the result object, per sheet.
OBS: The config header. A value from a specific cell can be defined as a key name e. To return all the data but having the object keys named as a row header found at the excel, instead of the column letters, is just use two special configs. Check the following columnToKey :. A specific range can be defined. Also like the previous configs, for all the sheets or per sheet.
Git github. Need private packages and team management tools?
Key features: Define a specific Range e. Keywords excel to json converts excel. Install npm i convert-excel-to-json Downloads Weekly Downloads 7, Version 1.
License MIT. Unpacked Size Total Files 9. Homepage github. Repository Git github. Last publish a year ago. Try on RunKit.
Report a vulnerability.