Parses an .xls excel file downloaded from ManageBac and converts to comma-deliminated csv. Particularly useful to convert to GSheets without having to use Excel.
Project description
mb-excelexport-2csv
This simple command line tool can be used to take an .xls
file (that is actually formatted in xml), and output it as a csv. The main use case in mind here is to convert excel files downloaded from ManageBac and upload them to Google Sheets, without having to open Excel.
This tool provides the exact same output if the xls file was opened in Excel, copied, and then pasted into Google Sheets, but without requiring Excel.
Getting Started
Requires Python 3.6.1 or above. Install Python 3 at python.org. Installing Python also installs a package manager (called pip) that can install the command mb_excelexport_2csv
into your command line environment.
pip3 install mb_excelexport_2csv
Then, open the mini app using this command:
mb_excelexport_2csv gui
For those who want the command line, use:
mb_excelexport_2csv cmd
See "Command Line" below for more info
Upgrade
Should you need to update to the latest version, you can do:
pip install --upgrade mb_excelexport_2csv
Command Line
After pip install worked, it is now installed on your path, and the command mb_excelexport_2csv is now available:
mb_excelexport_2csv cmd ~/path/to/xml.xls ~/path/to/output.csv
You can then import the csv file into Google Sheets. The delimiter used is a comma.
Alternatively, on Mac, you can skip the step of saving the csv file, and just run the following fancy command line, and it'll be on your clipboard.
mb_excelexport_2csv cmd ~/path/to/xml.xls - | pbcopy
Just paste into "A1" cell of your Google Sheet, Data -> Split Text into Columns.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for mb_excelexport_2csv-0.6.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5d4ee13903d8bae027d85c8e8b715295a435fb61a95328f680beceffa65000bf |
|
MD5 | 317dcf698b73893663aed6f0b2ed3e4d |
|
BLAKE2b-256 | abe9c1759df7688ea5f33a3072ae6186d84f870157901dc54557f98e758d0ff5 |
Hashes for mb_excelexport_2csv-0.6.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5ffd59b641760cfc8ed49d50f2825ee2bc3f39898bf8e78c820a50443201b7ff |
|
MD5 | 2a1f615ced440747ea3176c8b0df2396 |
|
BLAKE2b-256 | 302b2ca7951c5d24c33fd337c43f1ff53d1166c71ceff9271f8626f2c26f70f8 |