Skip to main content

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mb_excelexport_2csv-0.6.0.tar.gz (3.4 kB view details)

Uploaded Source

Built Distribution

mb_excelexport_2csv-0.6.0-py3-none-any.whl (3.9 kB view details)

Uploaded Python 3

File details

Details for the file mb_excelexport_2csv-0.6.0.tar.gz.

File metadata

  • Download URL: mb_excelexport_2csv-0.6.0.tar.gz
  • Upload date:
  • Size: 3.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.1.11 CPython/3.9.7 Darwin/21.1.0

File hashes

Hashes for mb_excelexport_2csv-0.6.0.tar.gz
Algorithm Hash digest
SHA256 5d4ee13903d8bae027d85c8e8b715295a435fb61a95328f680beceffa65000bf
MD5 317dcf698b73893663aed6f0b2ed3e4d
BLAKE2b-256 abe9c1759df7688ea5f33a3072ae6186d84f870157901dc54557f98e758d0ff5

See more details on using hashes here.

File details

Details for the file mb_excelexport_2csv-0.6.0-py3-none-any.whl.

File metadata

File hashes

Hashes for mb_excelexport_2csv-0.6.0-py3-none-any.whl
Algorithm Hash digest
SHA256 5ffd59b641760cfc8ed49d50f2825ee2bc3f39898bf8e78c820a50443201b7ff
MD5 2a1f615ced440747ea3176c8b0df2396
BLAKE2b-256 302b2ca7951c5d24c33fd337c43f1ff53d1166c71ceff9271f8626f2c26f70f8

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page