Search Results for "sql excel"
Sort By:
Showing 117 open source projects for "sql excel"
View related business solutions-
Ship Agents FasterGemini Enterprise Agent Platform lets you rapidly build, scale, govern and optimize production-ready agents grounded in your organization's data. The platform enables developers to build custom or pre-built agents for virtually any use case. New customers get $300 in free credits.
-
Cut Data Warehouse Costs by 54%BigQuery delivers 54% lower TCO with exabyte scale and flexible pricing. Free migration tools handle the SQL translation automatically.
-
1
SQL Notebook
SQL Notebook — Casual data exploration in SQL
SQL Notebook is a free Windows application for querying and analyzing data across multiple sources, including SQLite, PostgreSQL, Excel, and CSV files. It combines a SQL editor with a notebook interface, allowing for data exploration, transformation, and visualization in one place. SQL Notebook is ideal for analysts and data enthusiasts. -
2
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! ... -
3
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. -
4
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. -
Go from Code to Production URL in SecondsSkip the Kubernetes configs. Cloud Run handles HTTPS, scaling, and infrastructure automatically. Two million requests free per month.
-
5
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. -
6
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 (tables, columns, size). ... -
7
JimuReport
Open source drag-and-drop reporting and dashboard builder platform
...JimuReport also includes components for building interactive charts, data tables, and analytical displays that can be used in enterprise applications. It can connect to multiple data sources and retrieve data through SQL queries, APIs, or other structured formats. It can be embedded into Java applications using Spring Boot integration modules. -
8
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. -
9
Nushell
A new type of shell
NuShell (often shortened to “Nu”) is a modern, cross-platform shell written in Rust that treats all data as structured tables rather than plain text. It supports pipelines on rich typed data, has built-in commands for JSON/CSV/SQL/excel, and offers scripting, autocompletion, scoped variables, and strong error handling—bridging the gap between shell scripting and programming. -
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
10
Quadratic
Data science spreadsheet with Python & SQL
...Our goal is to build a spreadsheet that enables you to pull your data from its source (SaaS, Database, CSV, API, etc) and then work with that data using the most popular data science tools today (Python, 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. ... -
11
AI Data Science Team
An AI-powered data science team of agents
AI Data Science Team is a Python library and agent ecosystem designed to accelerate and automate common data science workflows by modeling them as specialized AI “agents” that can be orchestrated to perform tasks like data cleaning, transformation, analysis, visualization, and machine learning. It provides a modular agent framework where each agent focuses on a step in the typical data science pipeline — for example, loading data from CSV/Excel files, cleaning and wrangling messy datasets, engineering predictive features, building models with AutoML, connecting to SQL databases, and producing visual outputs — all driven by natural language or programmatic instructions. The project includes ready-to-use applications that showcase these agents in action, such as an exploratory data analysis copilot that generates reports, a pandas data analyst that combines wrangling and plotting, and SQL database agents that can query business databases and output results directly. -
12
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 it's a quality control tool to examine, verify or polish up a dataset before further processing. -
13
VisiData
A terminal spreadsheet multitool for discovering and arranging data
...VisiData works with CSV files, Excel spreadsheets, SQL databases, and many other data sources. -
14
Python 100 Days
Python - From Novice to Master in 100 Days
...It starts with foundational syntax, control flow, data structures, and functions, then advances through object-oriented programming, file I/O, exceptions, and modules. The middle sections focus on real-world Python applications, including working with CSV, Excel, Word, PowerPoint, PDFs, images, email/SMS, and regular expressions. The curriculum expands into databases and SQL, Linux essentials, web fundamentals, and a substantial Practical Django track that covers ORM, sessions, RESTful APIs, caching with Redis, asynchronous tasks with Celery, authentication, testing, and deployment. Data analysis and visualization receive dedicated coverage via NumPy, pandas, matplotlib, seaborn, and pyecharts, followed by an applied machine learning track with kNN, trees, Bayes, regression, clustering, ensembles, and neural networks. -
15
Apache Drill
Apache Drill is a distributed MPP query layer for self describing data
...Leverage your existing SQL skillsets and BI tools including Tableau, Qlikview, MicroStrategy, Spotfire, Excel and more. Drill supports a variety of NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. A single query can join data from multiple datastores. -
16
CyberScraper 2077
A Powerful web scraper powered by LLM | OpenAI, Gemini & Ollama
CyberScraper 2077 is not just another web scraping tool – it's a glimpse into the future of data extraction. Born from the neon-lit streets of a cyberpunk world, this AI-powered scraper uses OpenAI, Gemini and LocalLLM Models to slice through the web's defenses, extracting the data you need with unparalleled precision and style. -
17
dataline
AI data analysis and visualization on CSV, Postgres, MySQL, Snowflake
dataline is an open-source AI data analysis and visualization platform that allows users to interact with datasets using natural language. The system enables both technical and non-technical users to explore data by asking questions conversationally, which the platform translates into database queries and analytical operations. It supports connections to multiple structured data sources such as PostgreSQL, MySQL, Snowflake, SQLite, Excel files, CSV datasets, and other database systems. Once... -
18
ISQLHelper
SQL Server Helping Application For Developers
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 -
19
WagLabel Barcode Label Printing Software
WagLabel is an advanced Barcode Labeling Software
WagLabel is a powerful barcode label software that helps businesses easily create, customize, and print professional barcode labels in seconds. Import data from Excel, CSV, SQL and Oracle databases. Designed for speed, accuracy, and flexibility, WagLabel supports all major 1D (linear) and 2D barcode formats, making it the ideal solution for product labeling, inventory management, logistics, retail, and manufacturing. With an intuitive interface and high-performance barcode engine, WagLabel enables users to generate high-resolution barcode labels quickly—without technical complexity. -
20
ExcelToDatabase
An automated tool for batch-importing Excel data into a database
ExcelToDatabase is an automated tool for batch-importing Excel data into a database. It supports 10 popular databases including MySQL, Oracle, SQL Server, PostgreSQL, and so on. Supported file formats include xls, xlsx, xlsm, xlsb, csv, txt, xml, json, and dbf. Its native user interface brings users a comfortable experience for simplified Excel import and export, making it easier than ever before. -
21
TEAM-Jasper-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. -
22
ART
A Reporting Tool
ART is a reporting tool. It enables quick deployment of SQL query results. Supports tabular reports, charts, dashboards, scheduling. -
23
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 -
24
RosarioSIS
Student Information System for school management and communication
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... -
25
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