Converter CSV
Converter CSV by LimberDuck (pronounced ˈlɪm.bɚ dʌk) is a GUI tool which lets you convert multiple large csv files to xlsx files keeping your operational memory usage at a low level. You can run it on your operating system no matter if it is Windows, MacOS or Linux. It's free and open source tool. The reason this tool was created is to speed-up your tasks.
Main features
- select one or more csv files at once
- select directory to get all csv files from it and from all it's subdirectories
- change separator to desired char, or leave it default (comma "
,") - change target directory for output files to desired one, or leave it default (the same as source files)
Usage
- Go to Menu
File. - Choose one of below options:
Open file\-sif you want to open one or more csv files at once.Open directoryif you want to open all csv files from selected directory and its subdirectories.
- Click
Startbutton to initiate conversion of all selected files.
Options
- Click
Changebutton (next to separator filed) to change separator to desired by you eg. ";". - Click
Changebutton (next to directory field) to change target directory and use it for all output files. - Mark checkbox
add suffix with "_YYYYMMDD_HHMMSS"to add into each file name suffix with current time with given format. - Key-in custom suffix and mark checkbox
add custom suffixto add into each file name suffix with given text. - Click
Openbutton to open current working directory.
Installation
Note: It's advisable to use python virtual environment for below instructions. Read more about python virtual environment in The Hitchhiker’s Guide to Python!
Read about virtualenvwrapper in The Hitchhiker’s Guide to Python!: virtualenvwrapper provides a set of commands which makes working with virtual environments much more pleasant.
-
Install Converter CSV
pip install converter-csvTo upgrade to newer version run:
pip install -U converter-csv -
Run Converter CSV
converter-csvOptionally for Linux and macOS:
converter-csv&Run with
&at the end to start the process in the background. -
Make a shortcut with Converter CSV
Windows:
- Run in cmd
where converter-csv.exe - Copy returned path.
- Go to e.g. to Desktop.
- Right click on Desktop and choose
New > Shortcut. - Paste returned path.
- Click
Next,Finish.
Linux (Ubuntu) / macOS
- Run in Terminal
which converter-csv - Run in Terminal
ln -s path_returned_in_previous_command ~/Desktop/
macOS
- Run in Terminal
which converter-csv - Open
binfolder whereconverter-csvis located. - Right click on
converter-csvand chooseMake alias. - Move your alias e.g. to Desktop.
- Run in cmd
Additional steps
Click to see additional steps for Linux (Ubuntu)
#### Linux (Ubuntu) If you installed without python virtual environment, and you see below error: ```shell ~$ converter-csv converter-csv: command not found ``` Add below to `~/.bashrc` ```bash # set PATH so it includes user's private ~/.local/bin if it exists if [ -d "$HOME/.local/bin" ] ; then PATH="$HOME/.local/bin:$PATH" fi ``` If you see below error: ```shell ~$ converter-csv qt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" even though it was found. This application failed to start because no Qt platform plugin could be initialized. Reinstalling the application may fix this problem. Available platform plugins are: eglfs, linuxfb, minimal, minimalegl, offscreen, vnc, wayland-egl, wayland, wayland-xcomposite-egl, wayland-xcomposite-glx, webgl, xcb. Aborted (core dumped) ``` Run below to fix the error: ```shell sudo apt-get install --reinstall libxcb-xinerama0 ```Build executable file
Click to see instruction for Windows
### Windows 1. Clone **Converter CSV** repository using below command ``` git clone https://github.com/LimberDuck/converter-csv.git ``` 2. Install requirements using below command ``` pip install -r requirements.txt ``` 3. Run **Converter CSV** using below command ``` python -m converter_csv ``` 4. Upgrade setuptools using below command ``` pip install --upgrade setuptools ``` 5. Install PyInstaller ``` pip install PyInstaller ``` 6. Build your own executable file using below command ``` pyinstaller --onefile --windowed --icon=.\icons\LimberDuck-converter-csv.ico --name converter-csv converter_csv\__main__.py ``` 7. Go to `dist` catalog to find executable file `converter-csv.exe`Click to see instruction for Linux (Ubuntu)
### Linux (Ubuntu) 1. Clone **Converter CSV** repository using below command ``` git clone https://github.com/LimberDuck/converter-csv.git ``` 2. Install requirements using below command ``` pip install -r requirements.txt ``` 6. Run **Converter CSV** using below command ``` python -m converter_csv ``` 7. Upgrade setuptools using below command ``` pip install --upgrade setuptools ``` 5. Install PyInstaller ``` pip install PyInstaller ``` 8. Build your own executable file using below command ``` pyinstaller --onefile --windowed --icon=./icons/LimberDuck-converter-csv.ico --name converter-csv converter_csv/__main__.py ``` 9. Go to `dist` catalog to find executable file `converter-csv`.Click to see instruction for macOS
### macOS 1. Clone **Converter CSV** repository using below command ``` git clone https://github.com/LimberDuck/converter-csv.git ``` 2. Install requirements using below command ``` pip install -r requirements.txt ``` 3. Run **Converter CSV** using below command ``` python -m converter_csv ``` 4. Upgrade setuptools using below command ``` pip install --upgrade setuptools ``` 5. Install PyInstaller ``` pip install PyInstaller ``` 6. Build your own executable file using below command ``` pyinstaller --onefile --windowed --icon=./icons/LimberDuck-converter-csv.ico --name converter-csv converter_csv/__main__.py ``` 7. Go to `dist` catalog to find executable file `converter-csv`.Meta
Change log
See CHANGELOG.
Licence
GNU GPLv3: LICENSE.
Authors
Damian Krawczyk created Converter CSV by LimberDuck.