Skip to content

beastoin/csv-master

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

CSV MASTER

Convert .CSV to any format ~

Supported formats (3):

To .XLSX

Prerequisites

Run

  1. Open command line tool, e.g Terminal, Powershell

  2. Run command:

  • For single file convert:
 python csv_xlsx.py -i <PATH/TO/CSV> -o <PATH/TO/OUTPUT/XLSX>

Example: python csv_xlsx.py -i ~/Downloads/my-sample.csv -o my-sample.xlsx

  • For multiple files convert:
python csv_xlsx_bulk.py -i <PATH/TO/CSV/FOLDER>

Example: python csv_xlsx_bulk.py -i ~/Downloads/my-csv-folder/

  • NOTICE: Input folder path must end with / character
  • The .xlsx files will be located in the same folder with the .csv files

To .CSV Utf8-Sig (Utf8 BOM)

Prerequisites

Run

  1. Open command line tool, e.g Terminal, Powershell

  2. Run command:

  • For single file convert:
 python csv_utf8sig.py -i <PATH/TO/CSV> -o <PATH/TO/OUTPUT/CSV>

Example: python csv_utf8sig.py -i ~/Downloads/my-sample.csv -o my-sample.utf8sig.csv

  • For multiple files convert:
python csv_utf8sig_bulk.py -i <PATH/TO/CSV/FOLDER>

Example: python csv_utf8sig_bulk.py -i ~/Downloads/my-csv-folder/

  • NOTICE: Input folder path must end with / character
  • The .csv (.utf8sig.csv) files will be located in the same folder with the .csv files

Troubleshootings

  1. How to install python in Windows 10 pro?

-> Please visit https://www.python.org/downloads/windows/ and follow the instructions

  1. ModuleNotFoundError: No module named 'openpyxl'

-> Install module openpyxl via pip: pip install openpyxl

  1. ModuleNotFoundError: No module named 'pandas'

-> Install module pandas via pip: pip install pandas

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages