Skip to content

Latest commit

 

History

History
38 lines (24 loc) · 989 Bytes

README.md

File metadata and controls

38 lines (24 loc) · 989 Bytes
Raw

Excel to CSV Converter

Simple converter to save all the sheets in an Excel file to CSV files.

Installation

You need Python 3 with the following packages – install globally or with virtualenv.

pip3 install pandas
pip3 install xlrd
pip3 install tqdm

Just download the files and run excel2csv.

Usage

excel2csv [-h] [-d DELIMITER] [-f] excel_file

positional arguments:
  excel_file            input file

optional arguments:
  -h, --help            show this help message and exit
  -d DELIMITER, --delimiter DELIMITER
                        CSV delimiter
  -f, --force           force overwriting existing CSV files

Example

An example Excel file is included in the data directory.

Cd into the project directory and give the following command:

./excel2csv data/months.xlsx

Two CSV files were created in the data directory, containing the sample data from the Excel file.