OP here. I made this app for quick data analysis on your spreadsheets and Google Sheets. You can ask questions like:
1. Run linear regression to predict Y variable given X inputs
2. Tell me the top 5 movies that had the highest ratio of revenue to votes
You can also do Data Analysis in BI mode by doing specific tasks such as filtering, cleaning, merging, and visualizing. You can even write SQL code that runs directly on the spreadsheets.
Each step in BI mode can use results from a previous step, so you can have a repeatable workflow for your data analysis. You can then generate a report that you can share.
This uses the Open AI API. We can install a custom LLM backend for you, and install this app on your servers if you have security concerns.
Hi guys! OP here. I made this tool initially to clean messy customer data from spreadsheets.
I released the API endpoints this week for 8 data types: Address, Names, Company Names, Dates, Emails, Phones, Open Ended Notes and Currency.
Things I found myself constantly writing data cleaning functions for in ETL processes or my web apps.
The data cleaning is aimed towards North American and European data but test it out with your own values. The algorithms are broad and can maybe clean your data too if you are outside of those regions.
This is a tough endeavor so feel free to reach out to me with any feedback or suggestions!
I am Adhaar, the developer behind API Spreadsheets. 1 year ago, I showcased a super lite MVP of API Spreadsheets. This led to my first ever customers from something I created (a huge moment in my life). Now I am back with a v2.0.
And before you begin pointing out all the various other similar tools, I know! I know! Heck there's a tool for converting Google Sheets to a website on the front page of Show HN right now.
So let me tell you what makes API Spreadsheets different (synthesized from our user feedback)
1. Built for Developers, By Developers:
This is a purely CRUD tool. You can instantly Read, Create, Update and Delete data from your Spreadsheets. I have built a subset of SQL style querying to make all this easier. There are also pre-written guides and code snippets in Javascript, Python, Ruby and PHP so you can get started right away. It is up to you what you want to do with your data.
2. Private Google Sheets & Dropbox Supported:
oAuth verification for both Google Sheets and Dropbox is built in so you don't have to make your files public to use with API Spreadsheets like many other tools. API Spreadsheets is verified by both Google and Dropbox.
3. Local Files, Google Sheets and Dropbox Spreadsheets Supported:
This was super important to me. It is a pain in the ass to integrate spreadsheets so I have made it very easy to connect to spreadsheets in any of your various sources. Literally drag and drop your local files or choose from Google Drive or Dropbox using the File Picker GUI.
A few things going forward
1. I will be raising prices next week so this is your last chance to subscribe at these prices. I do not raise legacy prices so your rate will be locked in.
2. There are still many things to build and improve upon and I appreciate anyone coming on this journey. I constantly integrate feedback so do let me know if you have any!
Hi Hacker News! I am Adhaar, the developer behind Clean Spreadsheets. A little story behind this tool. I used to work as a Consultant (the kind that all Tech people hate) and a lot of my work was cleaning dates, addresses and emails. I used to hate it. I still do.
But when I learned how to build Web Apps I promised myself that I will build an easy way to clean customer data types. This is my solution.
My design idea for this tool was to offload cleaning on the back-end and require no input from the user. Except the data type and column they are cleaning. Cleaning various formats for all these data types is a non-trivial task, so I would love any help from the community to test out the tool and give any feedback.
You can email me directly at [email protected]. I will gladly give anyone who emails more free credits!
A couple of things people always ask:
1. What about sensitive data?
- I use encryption in transit and rest but if your data is super super confidential and you still want to use the tool, get in touch, [email protected] and we will figure out a way.
2. I just code my own functions to clean these things. Why do I need this?
- Very good point, and honestly if you can code your own, there really is no need for this. But maybe your friend who is an Accountant can benefit from this tool :)
OP Here. I made this tool to easily split large CSV files into smaller ones. I have run into this task when non-tech people are unable to open large files.
There are many ways to do this if you can code but I wanted an easy browser based solution, especially so non-tech people I work with can do this on their own.
Feel free to try it out and let me know any feedback
You can also do Data Analysis in BI mode by doing specific tasks such as filtering, cleaning, merging, and visualizing. You can even write SQL code that runs directly on the spreadsheets.
Each step in BI mode can use results from a previous step, so you can have a repeatable workflow for your data analysis. You can then generate a report that you can share.
This uses the Open AI API. We can install a custom LLM backend for you, and install this app on your servers if you have security concerns.
Looking forward to having people try it out :)