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
Very cool site, I have thought of making a CLI utility the same thing a few times but corporate computer limitations squashed that. I initially wanted to bring up bandwidth limitations but stopped myself as most people at work would not need to worry about that.
I made this tool to vertically combine multiple spreadsheets and CSV files. There are many ways to do this, Pandas in Python provides a great set of features, but I found myself repeatedly writing and tinkering with my set of functions for this often used task.
Hope it helps and let me know any questions and feedback!
My sister and I built this tool to easily convert a spreadsheet into an API link.
We had a personal need for this when we were working on creating a model with some real estate data for a client. We found ourselves constantly emailing each other the updated spreadsheets and having to reimport them in our code again and again. We used the Google Sheets API for a bit but wanted something even more simple for less experienced members on our team.
So we made this web app and corresponding libraries in R and Python. You can re-upload an updated file and your script won’t need to be updated. We also started using this for small hobby websites instead of setting up a database.
As a launch and early adopter pricing, we are offering this for $10 paid just once (no monthly) if you need over 10,000 rows. We will be constantly working on improving this tool.
We hope you find this helpful and would love to hear feedback from you guys if you use it!
It's focused towards Data Scientists. We built Python and R libraries so you don't have to be understand REST API concepts to get and share your data. And I think it's much easier to get started with :)
Hi guys! I have built a Web App and API to detect common and some uncommon errors in your data and give you details. You can upload a csv on the webapp or call the API with your data. Feel free to provide any feedback and hope it helps!
Hi all, OP here. I hate both Data Cleaning and QA so I built an API and Web App to do it in a straightforward way. Feel free to ask questions and give 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 :)