Search Results for "sql excel"
Sort By:
Showing 167 open source projects for "sql excel"
View related business solutions-
Boost application security and continuity with SKUDONET ADC, our Open Source Load Balancer, that maximizes IT infrastructure flexibility. Additionally, save up to $470 K per incident with AI and SKUDONET solutions, further enhancing your organization’s risk management and cost-efficiency strategies.
-
HubSpot is an AI-powered customer platform with all the software, integrations, and resources you need to connect your marketing, sales, and customer service. HubSpot's connected platform enables you to grow your business faster by focusing on what matters most: your customers.
-
1
SQL Explorer
Easily share data across your company via SQL queries
SQL Explorer aims to make the flow of data between people fast, simple, and confusion-free. 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... -
2
DBeaver
Free universal database tool
DBeaver is a free, multi-platform database tool that supports any database having a JDBC driver. It is useful for developers, SQL programmers, database administrators and analysts. DBeaver comes with plenty of great features such as metadata and SQL editors, ERD, data export/import/migration and more. Plugins are available for certain databases, and there are also several database management utilities. DBeaver’s Enterprise Edition provides even more features and supports non-JDBC datasources. -
3
CSV Lint
CSV Lint plug-in for Notepad++ for syntax highlighting
CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files. Use CSV Lint for metadata discovery, technical data validation, and reformatting on tabular data files. It is not meant to be a replacement for spreadsheet programs like Excel or SPSS, but rather... -
4
DbGate
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application. DbGate is a cross-platform database manager. It's designed to be simple to use and effective when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualization or batch export and import. Mongo JavaScript editor, execute Mongo script (with NodeJs syntax). Redis tree view... -
Evolia is a web and mobile platform that connects enterprises with 1000’s of local shift workers and offers free workforce scheduling and time and attendance solutions. Is your business on Evolia?
-
5
VisiData
A terminal spreadsheet multitool for discovering and arranging data
.... Code in the stable branch of this repository, including the main vd application, loaders, and plugins, is available for use and redistribution under GPLv3. VisiData is a free, open-source tool that lets you quickly open, explore, summarize, and analyze datasets in your computer’s terminal. VisiData works with CSV files, Excel spreadsheets, SQL databases, and many other data sources. -
6
tableExport.jquery.plugin
jQuery plugin to export a html table to JSON, XML, CSV, TSV, TXT, SQL
jQuery plugin to export an html table to JSON, XML, CSV, TSV, TXT, SQL, Word, Excel, PNG, and PDF. -
7
AlaSQL
JavaScript SQL database for browser and Node.js for relational tables
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... -
8
dsq
Commandline tool for running SQL queries against JSON, CSV, Excel
Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more. This is a CLI companion to DataStation (a GUI) for running SQL queries against data files. So if you want the GUI version of this, check out DataStation. -
9
Apache Drill
Apache Drill is a distributed MPP query layer for self describing data
Apache Drill is a distributed MPP query layer that supports SQL and alternative query languages against NoSQL and Hadoop data storage systems. It was inspired in part by Google's Dremel. Get faster insights without the overhead (data loading, schema creation and maintenance, transformations, etc.) Analyze the multi-structured and nested data in non-relational datastores directly without transforming or restricting the data. Leverage your existing SQL skillsets and BI tools including Tableau... -
WorkforceHub is the instantly useful, delightfully simple to use, small business solution for tracking time, scheduling and hiring. It scales as your business grows while delivering the mission-critical features an organization needs. It is tailored to, built for, and priced for small business employers.
-
10
sq data wrangler
sq data wrangler
sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure... -
11
Excel to Graphviz
A Microsoft Excel spreadsheet which creates Graphviz graphs
Takes Excel data relationships and creates Graphviz graph visualizations. -
12
Quadratic
Data science spreadsheet with Python & SQL
..., Pandas, SQL, JS, Excel Formulas, etc). Quadratic has no environment to configure. The grid runs entirely in the browser with no backend service. This makes our grids completely portable and very easy to share. Quadratic has Python library support built-in. Bring the latest open-source tools directly to your spreadsheet. Quickly write code and see the output in full detail. No more squinting into a tiny terminal to see your data output. -
13
AWA-Core
Full application for factory, process engineer and Automation..
AWA-Core (Another Way of Automation) is a complete suite that allows engineers, PLC programmers and factory designers to create huge projects for retrieving data, creating graphics, automatic scripts, exports and data links. You can easily manage AWA-Core and it's easier than Historian softwares. -
14
Robolinux
MAX Privacy with Robolinux R12.12
All 3 Robolinux Desktop versions come with new login and grub boot splash screens & LibreWolf browser which has the highest privacy! LibreWolf is a fork of Firefox so you can use its data. The Legacy Bios isos only work in VM's & Non UEFI PC's. Don't miss 50% Off 12+ price only $59.95 Expires August 30 2024 The 12+ Sale details Robo UNTRACKER Custom Installer FREE! Save $40 FAAST Boot Custom Installer FREE! Save $40 Backdoor security Custom Installer FREE! Save $40 12 Advanced... -
15
DiLu Converter
Automated tool for bulk importing Excel into the database
DiLu Converter is a productivity tool that can automatically import excel into a database. Supports excel files in xls/xlsx/xlsm/xlsb/csv/txt format, imported into databases including mysql/oracle/sql server/postgresql/access/hive/sqlite/dm. Automation is its main feature, because it can automatically generate table information based on excel to establish contact with the database, and finally import the data into the database table. Batch is another feature of it, because it can be automated... -
16
ReportServer Community Edition
ReportServer is a modern and versatile business intelligence platform
ReportServer is a modern and versatile open source business intelligence (BI) platform with powerful reporting features. With ReportServer you are not limited to one provider's solutions. ReportServer integrates Jasper, Birt, Mondrian and Excel-based reporting: choose what best suits your needs! The source code is also available in GitHub: https://github.com/infofabrik/reportserver ReportServer scripting samples: https://github.com/infofabrik/reportserver-samples -
17
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
-
18
Ant Movie Catalog
Free program made to manage your collection of movies
... language, allowing to modify catalog: Find & replace, moving field values, ... Printing, using customizable templates. Export to other formats: HTML (based on a template that you can modify or create yourself), SQL commands (to re-import data in a DBMS such as MySQL), CSV (text files, can be used as tables with Microsft Excel for example). Import from other formats: CSV (Microsoft Excel can create such files, but a plain text file can be used too), Microsoft Access and a few others. -
19
OSHMI - Open Substation HMI
SCADA HMI for substations, IoT and automation applications
Now with IEC61850 support! This project combines existing open source projects and tools to create a very capable, mobile and cloud-friendly HMI system that can rival proprietary software. This approach makes it possible to join forces of each project (Chromium, SVG/HTML5, PHP, Lua, SQLite, Inkscape, Lib61850, OpenDNP3, Nginx, Vega, PostgreSQL, Grafana,…) to achieve a great set of open, evergreen, modular and customizable tools for building great HMIs for automation projects. This is not a... -
20
Clinic management program (Exir) - EMR
Medical record management of clinic (EMR or EHR) and patient file.
Exir Clinic management software is a software to manage medical records and health file of patient(Electronic medical records or EMR). It allows users to create customized medical record formats including texts,drawings, pictures and others. this software support english, arabic and persian. also had online and offline mode. English site: https://exirmatab.com/en/ Farsi site: https://exirmatab.com/ !! Please download application from website or download all of them together in a separate... -
21
FastReport Open Source
Free Open Source Reporting tool for .NET
Free Open Source Reporting tool for .NET Core/.NET Framework that helps your application generate document-like reports. -
22
Easy Database Forms For All
Create Web Based Forms Quickly, With In-built DB, For All Your Teams
Please watch the video/screenshots below for easy installation steps. This video is taken from my other project, with many similarities and some naming differences. After installation, login to the Administrator Page with : Username : root Password : change_this and look at the team1 database and the sample_table in it. You can now create your own required tables/forms. Also, login into the team1 user page ( from homepage ) with : Username : team1 Password : change_this to check its... -
23
RosarioSIS
Student Information System for School Management
Free Student Information System designed for school management. Modules included: - School Setup - Students (demographics, contacts...) - Grades - Scheduling - Eligibility - Attendance - Accounting - Student Billing - Discipline - Food Service Add-ons like Messaging, Email, Import tools, Quiz, Library modules and much more are available. Manage your school in one web-application powered by PHP/SQL (MySQL or PostgreSQL). RosarioSIS is multilingual and offers Moodle integration. Try... -
24
Jasper4Oracle-Server
Easy integration of JasperReports in Oracle Forms or Apex with PL/SQL
Integration of JasperReports in Oracle Forms or Apex application with a PL/SQL API for replacing Oracle Reports. The PL/SQL API offers functions for printing, exporting, downloading, mailing and showing documents (PDF, Word, Excel etc.) in a Browser. -
25
JBizMo
Powerful generator for Java applications (JPA, Java EE...)
JBizMo supports building of Angular, Eclipse RCP/RAP, JavaFX, JSF (Primefaces), Swing and Vaadin applications. The generated applications can run in a stand-alone mode or they can be deployed on a Java EE server (Wildfly 16, Payara 5). Alternatively, the Spring platform is also supported! JBizMo applications use JPA in order to access the target database. The plug-in contains a graphical editor for designing the domain model.