We currently manage large customer and prospect lists in multiple Google Sheets and Excel. We want to migrate this into a cloud database.
We do not current have a database setup, so we will need to create one based on an example customer list and handle migration of our lists into the database.
We will need a web user interface to perform create/read/update/delete operations on these contacts, as well as query them by such things as address and business type.
The solution should be cloud based so that we donāt need to have our own servers, preferably in Google Cloud or Amazon AWS.
Answer
There are quite a few options for you in migrating your Google Sheets and Excel sheets into an online database program.
Question: Background ======== I am creating a new Software sales, business development and outsourcing brokerage/management firm. I am wanting to setup a software development project sales funnel system, combined with Project Management. Customers can visit our website will allow for anyone to submit a services request enquiry form. We act as independent sales, business analysis …
I recently put togetherĀ a short course on all the top hosted website buildersĀ that you can use to develop your website. The main reason for creating the course was to save people time in evaluating the hundreds of options for developing an easy-to-manage website. Some of my main findings were: You often have to compromise on …
For context, I was looking at CRMs for clients and thought I’d found the best CRM for my needs in a flashy, expensive CRM that did everything including walking your dog and making your breakfast. It wasn’t until I’d dived into the software that I found it didn’t fit my style and visibility needs. Too …
I need a custom CRM web app and database
Further question details
We currently manage large customer and prospect lists in multiple Google Sheets and Excel. We want to migrate this into a cloud database.
We do not current have a database setup, so we will need to create one based on an example customer list and handle migration of our lists into the database.
We will need a web user interface to perform create/read/update/delete operations on these contacts, as well as query them by such things as address and business type.
The solution should be cloud based so that we donāt need to have our own servers, preferably in Google Cloud or Amazon AWS.
Answer
There are quite a few options for you in migrating your Google Sheets and Excel sheets into an online database program.
I’d recommend that you look at Airtable, Coda, Podio and Trello.
For your multi-faceted search of the database, business categories & quick import of .csv or .xls files, you’ll find Podio a useful solution.
Related Posts
Sales funnel software for outsourcing firm
Question: Background ======== I am creating a new Software sales, business development and outsourcing brokerage/management firm. I am wanting to setup a software development project sales funnel system, combined with Project Management. Customers can visit our website will allow for anyone to submit a services request enquiry form. We act as independent sales, business analysis …
Why be a Weebly Designer in Australia?
I recently put togetherĀ a short course on all the top hosted website buildersĀ that you can use to develop your website. The main reason for creating the course was to save people time in evaluating the hundreds of options for developing an easy-to-manage website. Some of my main findings were: You often have to compromise on …
The near-perfect onboarding outreach email
For context, I was looking at CRMs for clients and thought I’d found the best CRM for my needs in a flashy, expensive CRM that did everything including walking your dog and making your breakfast. It wasn’t until I’d dived into the software that I found it didn’t fit my style and visibility needs. Too …