MRxls2csv

This application converts Excel spreadsheets (both XLS and XLSX) into CSV (comma-separated values) files. Each sheet is stored as a separate CSV file. While data is made available in Excel spreadsheets, most researchers work with CSV files, and this application helps to make it easier to change those Excel spreadsheets into CSV files that researchers can work with.

This application is distributed as a ZIP file. Before using, uncompress the ZIP file into any folder in your computer. No installation is required.

Then, simply double click on the application file, or run MRxls2csv on the command line from the directory in which the application file is stored. To use, first choose an Excel file to convert, then choose the directory to save the CSV files. Click on "Execute" to actually convert the Excel file. If you do not select a directory for the output files, the CSV files will be stored in a subdirectory under the same base name as the Excel file.

You can also run this tool from the command line using:

MRxls2csv source.xls target_dir

You can send feedback on this application to support@maplerain.com or use our contact form. If you wish to receive updates on this application, please send an email to register@maplerain.com with the application's name as the subject. Subsequent updates on the application will be sent to you via the email address provided.

Technical notes:

- This application runs on Python, and uses tkinter for its GUI.
- Packaging for Windows was done using PyInstaller to obtain a one-file executable.
- xlrd is used to process .xls files, while openpyxl is used to process .xlsx files.