Table Tool is a professional utility for processing tabular data that allows you to:
- ✅ Clear the contents of selected columns in tables
- ✅ Delete entire columns from tabular files
- ✅ Process large files without the interface freezing
📁 Supported Formats
🔹 Input Formats:
- Text files: `.csv`, `.tsv`, `.txt`
- Excel files: `.xlsx`, `.xls`
🔹 Output Formats:
- Text files: `.csv`, `.tsv`, `.txt`
- Excel files: `.xlsx`
🚀 Quick Start
1. 📂 Opening a file
- Click the "Open" button next to the "Input file" field
- Select your tabular file
- The program will automatically detect the delimiter and encoding
2. 🔍 Loading columns
- Click the "Load columns" button
- All columns of your table will appear in the dropdown list
- The preview area will display the headers and the first rows
3. ⚙️ Selecting an action
🧹 Clear column - clears the data in the selected column
🗑️ Delete column - completely removes the column from the table
4. 🎯 Selecting a column
- Select a column from the dropdown list in the format `[number] name`
- Or enter the column number manually (starting from 0)
5. 💾 Output settings
🔒 Create .bak copy - creates a backup copy of the original file
📊 Export to Excel - converts the result to XLSX format
📝 Output file - Specify the save path or leave it blank for automatic naming
6. 🚀 Start Processing
- Click the "Start" button
- Monitor the progress in the progress bar
- Wait for the success message
🛠️ Additional Features
⌨️ Keyboard Shortcuts
- `Ctrl+C` - Copy
- `Ctrl+V` - Paste
- `Ctrl+X` - Cut
- Right-click - Context menu
🔄 Batch Processing
- Multiple files can be processed sequentially
- Repeat steps 1-6 for each file
📋 Preview
- The bottom of the window displays:
- A list of all columns with numbers
- A preview of the first 10 rows of data
- Automatically updates after processing
⚠️ Important Features
🎪 Automatic Format Detection
- The program automatically detects the delimiter (comma, tab, semicolon)
- Supports various text file encodings
🐛 Error Handling
- Detailed error messages are displayed for file reading errors
- The program does not freeze when processing large files
- Maintains functionality with incorrect settings
💡 Usage Tips
1. For large files, use text formats instead of Excel
2. Before mass processing, test on a small file
3. If the file does not open, try changing the encoding
4. Always create .bak copies for important data
🆘 Troubleshooting
❌ File does not open
- Check the file path
- Make sure the file is not open in another program
- Try a different encoding
❌ Incorrect data in preview
- The program may have incorrectly identified the delimiter
- Check the source file in a text editor
❌ Error when processing Excel
- Make sure... - Make sure openpyxl is installed: `pip install openpyxl`
- Check that the file is not password protected
The program does not require the installation of additional software and works on any version of Windows with Python 3.6+
Table Tool is a professional utility for processing tabular data that allows you to:
- ✅ Clear the contents of selected columns in tables
- ✅ Delete entire columns from tabular files
- ✅ Process large files without the interface freezing
📁 Supported Formats
🔹 Input Formats:
- Text files: `.csv`, `.tsv`, `.txt`
- Excel files: `.xlsx`, `.xls`
🔹 Output Formats:
- Text files: `.csv`, `.tsv`, `.txt`
- Excel files: `.xlsx`
🚀 Quick Start
1. 📂 Opening a file
- Click the "Open" button next to the "Input file" field
- Select your tabular file
- The program will automatically detect the delimiter and encoding
2. 🔍 Loading columns
- Click the "Load columns" button
- All columns of your table will appear in the dropdown list
- The preview area will display the headers and the first rows
3. ⚙️ Selecting an action
🧹 Clear column - clears the data in the selected column
🗑️ Delete column - completely removes the column from the table
4. 🎯 Selecting a column
- Select a column from the dropdown list in the format `[number] name`
- Or enter the column number manually (starting from 0)
5. 💾 Output settings
🔒 Create .bak copy - creates a backup copy of the original file
📊 Export to Excel - converts the result to XLSX format
📝 Output file - Specify the save path or leave it blank for automatic naming
6. 🚀 Start Processing
- Click the "Start" button
- Monitor the progress in the progress bar
- Wait for the success message
🛠️ Additional Features
⌨️ Keyboard Shortcuts
- `Ctrl+C` - Copy
- `Ctrl+V` - Paste
- `Ctrl+X` - Cut
- Right-click - Context menu
🔄 Batch Processing
- Multiple files can be processed sequentially
- Repeat steps 1-6 for each file
📋 Preview
- The bottom of the window displays:
- A list of all columns with numbers
- A preview of the first 10 rows of data
- Automatically updates after processing
⚠️ Important Features
🎪 Automatic Format Detection
- The program automatically detects the delimiter (comma, tab, semicolon)
- Supports various text file encodings
🐛 Error Handling
- Detailed error messages are displayed for file reading errors
- The program does not freeze when processing large files
- Maintains functionality with incorrect settings
💡 Usage Tips
1. For large files, use text formats instead of Excel
2. Before mass processing, test on a small file
3. If the file does not open, try changing the encoding
4. Always create .bak copies for important data
🆘 Troubleshooting
❌ File does not open
- Check the file path
- Make sure the file is not open in another program
- Try a different encoding
❌ Incorrect data in preview
- The program may have incorrectly identified the delimiter
- Check the source file in a text editor
❌ Error when processing Excel
- Make sure... - Make sure openpyxl is installed: `pip install openpyxl`
- Check that the file is not password protected
The program does not require the installation of additional software and works on any version of Windows with Python 3.6+
No feedback yet