Skip to content

Latest commit

 

History

History
31 lines (26 loc) · 1.25 KB

README.md

File metadata and controls

31 lines (26 loc) · 1.25 KB

FastXlsToCsv

Made by William Norland, 2023

Fast way to convert large .xls/.xlsx files to CSV by saving them via a vbs running via windows script host.

Why?

During a project i did i noticed how slow pandas read excel files to dataframe, because pandas reads csv to dataframe much faster i decied to release my solution for turning excel into csv!

Dependencies

  • Excel (Only tested on excel 2016).
  • Windows operating system (Only tested on Windows 10).
  • Only tested on Python 3.11, should probably work on any python.
  • Windows script host (Exists on pretty much every windows ever).

Usage

Install

Screenshot (2)

Import

Screenshot (3)

Use

inputFile: str = r"c:\Users\someone\Desktop\ExcelFiles\excelFileThatWantsTobeCsv.xlsx"
inputDir: str = r"c:\Users\someone\Desktop\ExcelFiles"
outputDir: str =  r"c:\Users\someone\Desktop\FolderForExportedCsvs"
XlsConverter.convertXlFileToCsv(inputFile, output)
XlsConverter.convertXlDir(inputDir, output)

License

Relased under the MIT License, check FastXlsToCsv/LICENSE for more information.