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.

[!NOTE] Visit LimberDuck.org to find out more!

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

[!TIP] You don’t need to install Python, install Converter CSV, or build it yourself. Just go to GitHub Releases and download the latest version of Converter CSV, ready to run on Windows, macOS, and Linux.

[!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

   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

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

# 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

~$ 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)

sudo apt-get install --reinstall libxcb-xinerama0

Build executable file

Meta

Change log

See CHANGELOG.

Licence

GNU GPLv3: LICENSE.

Authors

Damian Krawczyk created Converter CSV by LimberDuck.