Skip to content

First Public Release – CSV & SQL File Merger with Shiny GUI for Preprocessing Data Imports

Latest
Latest
Compare
Choose a tag to compare
@Cardman08 Cardman08 released this 28 May 09:20
v0.10.2
bef50b5
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Version 0.10.2 – First Public Release

This is the first public release of the CSV & SQL File Merger, a Shiny-based R application for the structured preprocessing of tabular data. The tool allows users to combine multiple CSV files using SQL logic and export the result to new CSV or Excel files. It is designed to support data preparation workflows, such as importing into eLabFTW or similar platforms.

Key features:

  • Load and merge multiple CSV files using user-defined SQL scripts.
  • Shiny-based GUI for interactive configuration and preview of merged datasets.
  • Export of results to CSV or Excel (XLSX) files.
  • Suitable for preparing structured data for electronic lab notebooks (ELNs) or other database-driven systems.
  • Supports persistent storage of SQL declaration files for reproducible preprocessing.

System requirements:

  • R 4.3 or higher
  • Packages: shiny, DBI, RSQLite, readr, dplyr, openxlsx, shinyFiles

For installation instructions and usage examples, see the README:
https://github.com/Cardman08/CSV-SQL-TableMerger/blob/main/README.md

Feedback, bug reports, and contributions are welcome via GitHub Issues

Assets 2
Loading