bartoszpet
-
Posts
2 -
Joined
-
Last visited
Content Type
Blogs
Gallery
Downloads
Events
Profiles
Forums
Articles
Media Demo
Posts posted by bartoszpet
-
-
This one works perfectly (tested with macOS Monterey 12.6): https://github.com/bpetrynski/alfred-notification-dismisser
Convert CSV to XLSX
in Share your Workflows
Posted
Convert CSV to XLSX
Download URL: https://github.com/bpetrynski/alfred-convert-csv-to-xslx/
This is an Alfred Workflow that lets you convert CSV files to XSLX (Excel) format. This tool is very useful for data analysts or anyone who frequently works with data files and needs to convert them to a more user-friendly format for editing and visualization purposes.
The conversion process is done by a Python script which reads a CSV file, converts it into a DataFrame (a two-dimensional tabular data structure with labeled axes), and then writes that DataFrame into an XLSX (Excel) file.
Installation
Step 1: Install Python (if not already installed):
Open Terminal and type:
Step 2: Install the required Python libraries:
We'll need two libraries:
pandas
for data manipulation andopenpyxl
for Excel file handling.To install these libraries, type the following command in Terminal:
Usage
Use via Universal Actions in Alfred. Alfred's Universal Actions allow you to select a file in Finder or on your Desktop and apply an action to it, like converting the file format.
In Environment Variables you can change the default encoding, delimiter, and quote character.
Changelog
0.3
0.2
0.1