Skip to main content

No project description provided

Project description

excel_normalizer

A CLI tool to force an entire Excel spreadsheet, CSV, or tab-delimited TXT file to be treated as text. I was getting extremely annoyed at Excel for automattically formatting large numbers into scientific notation with no way to disable the behavior. I made a python script to treat the whole file as text, fueled by spite and rage. I decided a CLI would be more convenient for myself, and if I'm going that far I might as well publish it. So here ya go.

Install

pip install excel_normalizer

Usage

normalize /path/to/file.csv

A new Excel (.xlsx) file will be saved in the same directory as the source file with the source file name appended with "_NORMALIZED." I may or may not add the option to specify an output filename and location. Or you can, I don't really care. MIT licsense, do what you want.

Supported File Types

.xlsx .csv .txt (tab-delimited)

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

excel_normalizer-0.3.tar.gz (3.1 kB view details)

Uploaded Source

Built Distribution

excel_normalizer-0.3-py3-none-any.whl (3.7 kB view details)

Uploaded Python 3

File details

Details for the file excel_normalizer-0.3.tar.gz.

File metadata

  • Download URL: excel_normalizer-0.3.tar.gz
  • Upload date:
  • Size: 3.1 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.0 CPython/3.9.7

File hashes

Hashes for excel_normalizer-0.3.tar.gz
Algorithm Hash digest
SHA256 5fdefd2e9da98090f85d4406f7ec4dd871781928656cc9d3827eadc0c952046d
MD5 49c7650258161c4dd9c76ef711f49e22
BLAKE2b-256 0ebeb05e919c4780fbdfb00354766d32b9c1a54e3f4b43da457aba16745ec492

See more details on using hashes here.

File details

Details for the file excel_normalizer-0.3-py3-none-any.whl.

File metadata

File hashes

Hashes for excel_normalizer-0.3-py3-none-any.whl
Algorithm Hash digest
SHA256 9df2ccbfadace0bab98d77dbc7147b61afb9dfe62f5fce415d60162d68807094
MD5 1c7c79d825d5668893d0a574ade7c082
BLAKE2b-256 035a50304614bd38e6ade3a0f826ac06e80495ae30a83ad8f65e272b3b91602d

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