Skip to main content

Converts to Excel XLSX from a TSV or CSV text file.

Project description

text2excel

Lint and Test PyPI - Python Versions PyPI GitHub license Code style: black CodeQL

This program converts CSV Or TSV text files to Microsoft Excel format. It uses openpyxl to create Excel files.

As input it takes tab-separated *.txt files (TSV), or any CSV files (Comma-Separated Values) that can be auto-detected by the Python standard library csv module.

Example

$ printf "one\ttwo\tthree\n1\t2\t3\n" | tee my_data_file.txt
one two three
1   2   3

$ text2excel --numbers my_data_file.txt
Saved to file: my_data_file.xlsx

Installation

To install or upgrade text2excel from PyPI, I recommend using pipx:

pipx install text2excel
pipx upgrade text2excel

If you don't have pipx, you could also use pip with your preferred Python version:

python3 -m pip install --user --upgrade-strategy eager --upgrade text2excel

News

Please see the changelog for more details.

Contributing

Do you want to help out with this project?

Credits

This project was originally based on a Gist by Konrad Förstner.

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

text2excel-0.4.3.tar.gz (5.7 kB view details)

Uploaded Source

Built Distribution

text2excel-0.4.3-py3-none-any.whl (6.5 kB view details)

Uploaded Python 3

File details

Details for the file text2excel-0.4.3.tar.gz.

File metadata

  • Download URL: text2excel-0.4.3.tar.gz
  • Upload date:
  • Size: 5.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.1.13 CPython/3.10.2 Darwin/20.6.0

File hashes

Hashes for text2excel-0.4.3.tar.gz
Algorithm Hash digest
SHA256 20e3d6c884fda556425368456e799c17d9ecb88316b257d8208b9580eee3fa9e
MD5 a90600b846c98b037df95cf82d0e4b35
BLAKE2b-256 4e3ac8ae361c42248a8bb4ce1db2ac2c39c9adea2dd9a3ff87e36509e1920635

See more details on using hashes here.

File details

Details for the file text2excel-0.4.3-py3-none-any.whl.

File metadata

  • Download URL: text2excel-0.4.3-py3-none-any.whl
  • Upload date:
  • Size: 6.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.1.13 CPython/3.10.2 Darwin/20.6.0

File hashes

Hashes for text2excel-0.4.3-py3-none-any.whl
Algorithm Hash digest
SHA256 37a48d216b0cccee9ac3a84f49db06d20d50fc5e7ecafae797409ff394f0b27f
MD5 2e405c549180cf471bfa9d5d54488559
BLAKE2b-256 340d6f54ccbd846b3585bbe72a8e512763667aff5cfb2198938a20c17efcd4ea

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