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 hashes)

Uploaded Source

Built Distribution

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

Uploaded Python 3

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