Converts to Excel XLSX from a TSV or CSV text file.
Project description
text2excel
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.
- You'll find the text2excel source on GitHub
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?
- Please check the CONTRIBUTING guide.
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
Built Distribution
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 20e3d6c884fda556425368456e799c17d9ecb88316b257d8208b9580eee3fa9e |
|
MD5 | a90600b846c98b037df95cf82d0e4b35 |
|
BLAKE2b-256 | 4e3ac8ae361c42248a8bb4ce1db2ac2c39c9adea2dd9a3ff87e36509e1920635 |
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 37a48d216b0cccee9ac3a84f49db06d20d50fc5e7ecafae797409ff394f0b27f |
|
MD5 | 2e405c549180cf471bfa9d5d54488559 |
|
BLAKE2b-256 | 340d6f54ccbd846b3585bbe72a8e512763667aff5cfb2198938a20c17efcd4ea |