Skip to main content

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.

pepy - Downloads PyPI Downloads GitHub Downloads (all assets, latest release) GitHub Downloads (all assets, all releases) Latest Release version GitHub Release Date 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
  • automatically detect separator or change it to desired char,
  • change target directory for output files to desired one, or leave it default (the same as source files)
  • automatically set filters and freeze first row in generated spreadsheet to make it easier to analyze the data

Usage

  1. To open csv files:
    1. Open Converter CSV by LimberDuck, go to Menu "File" and choose:
      • "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.
    2. On OS level select one or more csv files:
      • Click RMB (Right Mouse Button) on them and choose from contextual menu option "Open with..."
      • Choose Converter CSV by LimberDuck to open selected files.
    3. On OS level select one or more csv files or directories containing csv files:
      • drag and drop selected file\-s on Converter CSV by LimberDuck window.
      • drag and drop selected directory or directories on Converter CSV by LimberDuck window.
  2. Click Start button to initiate conversion of all selected files.

Options

  • Keep Auto-detect separator checkbox selected to automatically detected separators such as ,, ;, tab, | and : based on the first 5 lines.
  • Disable Auto-detect separator option and 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

  1. Install Converter CSV

    pip install converter-csv

    To upgrade to newer version run:

    pip install -U converter-csv

  2. Run Converter CSV

    converter-csv

    Optionally for Linux and macOS:

    converter-csv&

    Run with & at the end to start the process in the background.

  3. Make a shortcut for 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 bin folder where converter-csv is located.
    • Right click on converter-csv and choose Make alias.
    • Move your alias e.g. to Desktop.

Additional steps

Click to see additional steps for Linux (Ubuntu)

Linux (Ubuntu)

If you installed without python virtual environment, and 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 below 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.

Metadata

Release files for converter-csv 0.6.2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for converter-csv 0.6.2
File Size Uploaded Provenance Actions
converter_csv-0.6.2.tar.gz 59.5 kB Without provenance Details for converter_csv-0.6.2.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for converter-csv 0.6.2
File Interpreter ABI Platform Actions
converter_csv-0.6.2-py3-none-any.whl Python 3 none any Details for converter_csv-0.6.2-py3-none-any.whl

Total release size: 121.3 kB

Release files / converter_csv-0.6.2.tar.gz

Download URL converter_csv-0.6.2.tar.gz
Size 59.5 kB
Tags Source
SHA-256 checksum
How to use checksums
b859fa0011f90314b5743ae85493f04a34c3dd418200e2278c2d2f66011b7694
BLAKE2b-256 checksum
How to use checksums
c7a328b06c71031d89b40a1400e474f59f244dfa44101c02726a39286690e736
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.9.25

Release files / converter_csv-0.6.2-py3-none-any.whl

Download URL converter_csv-0.6.2-py3-none-any.whl
Size 61.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
c6c6d8710fdd4b298aa283ba6caaf545d27a9d57b169007f559bd03835424f4d
BLAKE2b-256 checksum
How to use checksums
85552fece6aa024386e0df61f4aa633a2376faf9c190e4ec3dda41738f2b2a40
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.9.25

Security for converter-csv 0.6.2

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page