Search Results for "convert excel to json"

...It is a Django-based application that you can add to an existing Django site, or use as a standalone business intelligence tool. Quickly write and share SQL queries in a simple, usable SQL editor, preview the results in the browser, share links, download CSV, JSON, or Excel files (and even expose queries as API endpoints, if desired), and keep the information flowing! Comes with support for multiple connections, to many different SQL database types, a schema explorer, query history (e.g. lightweight version control), a basic security model, in-browser pivot tables, and more. SQL Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the principle of least surprise. ...

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel. We focus on speed by taking advantage of the dynamic nature of JavaScript when building up queries. Real-world solutions demand flexibility regarding where data comes from and where it is to be stored. We focus on flexibility by making sure you can import/export and query directly on data stored in Excel (both .xls and .xlsx), CSV, JSON, TAB, IndexedDB, LocalStorage, and SQLite files. ...

...Redis tree view, generate script from keys, run Redis script. Runs as an application for Windows, Linux and Mac. Or in Docker container on the server and in a web browser on the client. Import, export from/to CSV, Excel, JSON, XML. Free table editor - quick table data editing (cleanup data after import/before export, prototype tables, etc.) Archives - back up your data in JSON files on local filesystem (or on DbGate server, when using web application) Charts, export chart to HTML page.

1.SQL Compare Compare and synchronize SQL Server database schemas effortlessly. 2.SQL Data Compare Identify and sync data differences between SQL Server databases. 3.Folder to SQL Compare Compare SQL script folders with live SQL Server databases. 4.SQL Trace / SQL Profiler (Azure Supported) Capture, trace, and analyze SQL Server events and performance — includes Azure SQL support. 5.SQL Table Documents Generate structured documentation for SQL Server table schemas. 6.SQL Data Export Export SQL Server data into multiple formats (CSV, Excel, JSON, etc.). 7.Excel to SQL Move Import Excel spreadsheets directly into SQL Server tables. 8.Import / Export Data Perform high-speed bulk data transfer between databases and formats. 9.Daily Tasks Automate and schedule routine SQL Server maintenance tasks. 10.Procedure Creation Easily design, edit, and manage stored procedures. 11.Script Maintenance Organize, version, and manage SQL scripts within the applica

DiLu Converter is a powerful Excel import and export tool that supports more than 10 databases such as MySQL, Oracle, SQL Server, PostgreSQL and so on. The supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience of simplified Excel import and export, making Excel import and export easier than ever before.

DBConvert is a cross converter for HanDBase-, List-, JFile-, MobileDB-, PilotDB-, MariaDB-, MySQL-, PostgreSQL-, SQLite-, MS-Access-, SQL Server-, Firebird- , DBase- and Foxpro- databases, as well as MS-Excel and Calc spreadsheets, CSV- , JSON-, vCard-, hCard-, jCard-, xCard-, YAML- and XML files. Source files: https://github.com/TvBreukelen/fnpdbservices

FNProg2PDA is a freeware add-on tool for the FNProgramvare software (http://www.fnprg.com) to export data from the FNProgramvare databases (for assets, books, CD's, LP's, video's, DVD's, software or stamp collections) to BookBuddy, MovieBuddy or MusicBuddy as well as a Firebird, PostgreSQL, MariaDB, SQL Server, SQLite , xBase or HanDBase database, Calc orMS-Excel spreadsheet, CSV-, TSV-, JSON-, YAML- or XML file. Source files: https://github.com/TvBreukelen/fnpdbservices

MDB Admin allows you to open, visualize and edit MSAccess databases (MDB or ACCDB files) without having Access installed. You can also install MDB Admin using winget: winget install --id=MarcielDegasperi.MDBAdmin -e IMPORTANT: To work with .accdb files you must manually install "Microsoft Access Database Engine Redistributable" 32bits, which can be found at the link below: https://www.microsoft.com/en-us/download/details.aspx?id=54920 (please make sure to select 32-bit...

P.S. Dear friends. Repository migration to https://github.com/ascrus/getl . You can download jar file from this site or maven. GETL - based package in Groovy, which automates the work of loading and transforming data. His name is an acronym for «Groovy ETL». GETL is a set of libraries of pre-built classes and objects that can be used to solve problems unpacking, transform and load data into programs written in Groovy, or Java, as well as from any software that supports the work with...

Convert a MSAccess database into a Excel spreadsheet. It's a pure java implementation, using POI (https://poi.apache.org/) and Jackcess (http://jackcess.sourceforge.net/). Use: java -jar Access2Excel.jar -inputFile=<inputFile> [-outputFile=<outputFile>] [-format=<format>] where <inputFile>: A file name to Access database (.MDB or .ACCDB) <outputFile>: A file name to Excel streadsheet (optional, default "inputFile.xls" or "inputFile.xlsx") <format>: Output format ("XLS" or "XLSX", optional, default "XLSX")

Project has moved to: https://github.com/OptimalBPM/qal QAL is a collection of libraries for mining, transforming and writing data from and to a number of places. Sources and destinations include different SQL and NoSQL backends, file formats like .csv, XML and excel. Even untidy HTML web pages. It has a database abstraction layer that supports connectivity to Postgres, MySQL, DB2, Oracle, MS SQL server. JSON and MongoDB is coming. It uses XML/JSON formats(self-generated SQL schemas) for representing queries, transformation and merging, making it scriptable. This means that QAL can be backend agnostic about a subset of SQL features and data types. ...

dbf is an easy-to-use command line tool to show and convert the content of dBASE III, IV, and 5.0 files. It reads dBASE databases and prints the content to the screen or converts it to comma-separated (*.csv) files which can be opened in Excel, Calc.

Build a tool with nice GUI as well as powerful options to automate building SQL DDL and import statements from an Excel Sheet / Workbook.

Csvtosql is a library and tool to convert any CSV-based data. It accepts multiple data formats (such as CSV, Excel, or arrays), converts it into SQL statements, and writes the data back in multiple formats (textfile, database).