Hi Product Hunt,
I am Adhaar, one of the makers of Merge Spreadsheets. I used to be a tech consultant in a past life and frequently had to merge many many spreadsheets. I went into the Tech world afterwards and weirdly, my need to merge spreadsheets did not slow down. I found myself firing up a merge_spread_FINAL.py file on my computer over and over again. I talked about this with my sister and she also faced this problem many times during her day (her script was called Merge_Please.R π).
So, we decided to build Merge Spreadsheets as a product within our company, Love Spreadsheets.
We had 3 goals with this tool:
1. Default to automatically merge based on column names
- So we can drag 100 files at once and voila!
2. Join exactly like SQL
- So we can do full, inner, left and right joins on spreadsheets
3. Have an interface to easily move around columns and their values
- For any more complex task
We believe this is the easiest way to Merge Spreadsheets, especially for use cases that fit these goals. And our small business and analyst customers seem to agree.
Try it out and let us know what you think. Happy Merging Spreadsheets!
Api Spreadsheets