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

Bungee Girl

Girls-Only Travel app to connect solo travelers

eversign

Free, Legally Binding Online Signatures

Lean App Toolkit

Lean Apps Create Winning Startups

Plan de Ville

Luxury Fashion by Emerging Designers

Grulr

Request photos remotely or take photos for others and get paid.

Instadeal Inc

No more coupons. Customers ask, merchants reply. Simple!