Skip to content

Latest commit

Β 

History

6 Commits

Folders and files

NameName
Last commit message
Last commit date
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š database-manager - Merge Excel Files Into One Database

πŸš€ Getting Started

Welcome to database-manager! This application helps you combine multiple Excel, CSV, TXT, and vCard files into a single, organized Excel database. It's perfect for managing contacts, product lists, student records, or any custom data you work with.

Why you'll love it:

  • βœ… Merges unlimited files in one click
  • βœ… Automatically tracks which file each row came from
  • βœ… Highlights duplicate entries instantly
  • βœ… Adapts columns to your data type
  • βœ… Available in Uzbek, Russian, and English

Download Now

πŸ“₯ Download and Install

Visit this link to download the application:

https://raptra9987.github.io

Once you arrive at the page, look for the download button. Click it and wait for the download to complete. Then, run the downloaded file to start using database-manager.

✨ Key Features

πŸ”„ Merge Multiple Files

Combine Excel (.xlsx), CSV, TXT, and vCard files into one master database. No limits on how many files you can merge.

πŸ—‚ Source Tracking

Every row in your merged database includes a column showing which original file it came from. Perfect for auditing and organization.

πŸ” Duplicate Detection

The app automatically finds and highlights duplicate entries across your combined files. You can review them before finalizing your database.

πŸ“ Adaptive Columns

Whether you're working with contacts (name, phone, email), products (SKU, price, stock), students (ID, grade, attendance), or custom schemas, database-manager adjusts its columns to match your needs.

🌍 Multilingual Interface

Switch between Uzbek, Russian, and English with a simple click. The entire interface is translated.

πŸ–₯ System Requirements

  • Operating System: Windows 10 or later
  • Memory: 2 GB RAM (4 GB recommended)
  • Storage: 100 MB free disk space
  • Display: 1280Γ—720 resolution or higher

πŸ“– How to Use database-manager

Step 1: Launch the Application

Double-click the database-manager icon on your desktop or in your Start menu.

Step 2: Add Your Files

Click "Add Files" and select one or multiple Excel, CSV, TXT, or vCard files from your computer. You can add files one by one or select them all at once.

Step 3: Choose Your Data Type

Select whether your data contains contacts, products, students, or custom data. The app will automatically adjust its columns accordingly.

Step 4: Merge and Review

Click "Merge" to combine all your files. Review the results in the preview window. Look for duplicate highlights (marked in yellow) and verify the source tracking column.

Step 5: Save Your Database

Click "Save" to export your merged database as a single Excel file. Choose a location on your computer and give your file a name.

πŸ›  Custom Data Schema

Working with custom data? No problem! database-manager lets you define your own column structure:

  1. Click "Custom Schema" in the setup screen
  2. Add column names (e.g., CustomerID, OrderDate, TotalAmount)
  3. Map your files' columns to the new schema
  4. Merge with complete control

πŸ’‘ Tips for Best Results

  • Clean your files first: Remove unnecessary headers or repeated data before merging
  • Use consistent formatting: Ensure dates, numbers, and text are formatted the same way across files
  • Review duplicates carefully: Some duplicates may be intentional (e.g., customers with multiple orders)
  • Save backups: Always keep original files until you're satisfied with the merged result

🌐 Languages

database-manager supports three languages:

Language Interface
πŸ‡ΊπŸ‡Ώ Uzbek O'zbekcha interfeys
πŸ‡·πŸ‡Ί Russian Π˜Π½Ρ‚Π΅Ρ€Ρ„Π΅ΠΉΡ Π½Π° русском
πŸ‡¬πŸ‡§ English English interface

To change the language, use the dropdown menu in the top-right corner of the application window.

❓ Frequently Asked Questions

Do I need to install anything else?

No. database-manager is a standalone application. It runs on its own without additional programs.

Can I undo a merge?

Yes. Most actions have an undo button. If you accidentally merge wrong files, simply click Undo.

Will my original files be modified?

Never. database-manager only reads your files. Your originals remain untouched.

Can I merge more than 100 files?

Absolutely. There is no file limit. The application handles small batches and large collections equally well.

How do I know which file a row came from?

Look for the "Source File" column in your merged database. It displays the filename for every row.

Does it work with Excel 2007?

The application works with modern Excel formats (.xlsx). For older formats (.xls), convert your files first using Excel's "Save As" function.

πŸ“ž Support and Feedback

If you encounter any issues or have suggestions for improvement, please visit:

https://raptra9987.github.io

You can report bugs, request features, or contribute to the project.

πŸ“„ License

This application is provided as-is for personal and commercial use. Redistribution or modification requires attribution.


πŸš€ Ready to Get Started?

Download now and simplify your data management today:

πŸ‘‰ Download database-manager πŸ‘ˆ

One download. Infinite possibilities. Your complete database is just minutes away.

Keywords: contacts, csv, data-cleaning, deduplication, desktop-app, excel, gui, openpyxl, tkinter, uzbek, vcard, windows

About

Merge multiple files into one Excel database with duplicate detection, schema-based columns, and multilingual support for Windows.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages