PasteQL

Posted

Saturday, March 18, 2017

Easily turn raw data files into charts and reports

I came up with the idea while through some of the frustrations that I ran into during my day job. A common use-case that I go through on almost a daily basis is: 1) Collect a bunch of excel and csv files from different sources / people 2) Merge those files into a single excel file so that I can join the data to make something useful 3) Create pivot tables and graphs using that data 4) Copy paste those figures into a word doc 5) Email it out to a bunch of people Sometimes, if Step #2 is really complicated, I end up writing a quick python script to upload all of those into a temporary MySQL database, do the query, and then export as a csv file, GOTO #3. This also becomes more annoying when I have to make some changes to the data, which now requires me to repeat the whole process again. PasteQL is the first stab at making this a little bit more sane.

Tags

Give PasteQL some love:





comments powered by Disqus

Recent startups

LogoCrisp

LogoCrisp, the real free logo maker

Agilean Solutions

Agilean is essentially an AI-based automated work-flow project management solutions

Atlaz

Full stack project management tool for tech companies

Thrive CRM

Manage relationships and build your business from your inbox

RallyHR

RallyHR - all-in-one HR platform for business

Oceans mHealth

Virtual Pharmacist App for Drug Safety, Drug Interaction & Drug Match