Skip to main content

Converter CSV by LimberDuck is a GUI tool to convert multiple large csv files to xlsx files.

Project description

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.

PyPI - Downloads License Repo size Code size Supported platform

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

  1. Go to Menu File.
  2. Choose one of below options:
    • Open file\-s if you want to open one or more csv files at once.
    • Open directory if you want to open all csv files from selected directory and its subdirectories.
  3. Click Start button to initiate conversion of all selected files.

Options

  • Click Change button (next to separator filed) to change separator to desired by you eg. ";".
  • Click Change button (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 suffix to add into each file name suffix with given text.
  • Click Open button 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.

  1. Install Converter CSV

    pip install converter-csv

  2. Run Converter CSV

    converter-csv

Additional steps

Linux (Ubuntu)

If you see below error:

~$ converter-csv
converter-csv: command not found

Add below to ~/.bashrc

# 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:

~$ 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 to fix the error:

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
    
  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.

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for converter-csv, version 0.3.0
Filename, size File type Python version Upload date Hashes
Filename, size converter_csv-0.3.0-py3-none-any.whl (59.3 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size converter_csv-0.3.0.tar.gz (58.8 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page