Title: Create database with search functionality Last modified: August 12, 2017 --- # Create database with search functionality * [sparty](https://wordpress.org/support/users/sparty/) * (@sparty) * [8 years, 10 months ago](https://wordpress.org/support/topic/create-database-with-search-functionality/) * Hello, * I want to create a database with names and numeric totals in it. It will be about 300 entries in it and the idea is to be able to search a name and a total comes up in a display. * The second part is I want this database to be in excel and the client wants to update the database bu just uploading an excel spreadsheet. How would I go about doing this ? * Thanks Viewing 4 replies - 1 through 4 (of 4 total) * [dayvee](https://wordpress.org/support/users/dayvee/) * (@dayvee) * [8 years, 10 months ago](https://wordpress.org/support/topic/create-database-with-search-functionality/#post-9404583) * There are somethings we need to know about your client’s site for us to help you. To begin with, is their website a wordpress site? If not what language was their site developed in? * Assuming the site is a wordpress site you could convert the excel files with the data of the names and values [like this](https://www.ablebits.com/office-addins-blog/2014/04/24/convert-excel-csv/) and then use [this](https://wordpress.org/plugins/wp-csv-to-database) wordpress plugin to convert the csv files and save them into your wordpress database which you can search and return values. * If the site is not a wordpress site then you would have to write a program that has the above functions i just explained which is easy for an intermediate web developer. Let me know if this answers your question. - This reply was modified 8 years, 10 months ago by [dayvee](https://wordpress.org/support/users/dayvee/). - This reply was modified 8 years, 10 months ago by [dayvee](https://wordpress.org/support/users/dayvee/). - This reply was modified 8 years, 10 months ago by [dayvee](https://wordpress.org/support/users/dayvee/). * Thread Starter [sparty](https://wordpress.org/support/users/sparty/) * (@sparty) * [8 years, 10 months ago](https://wordpress.org/support/topic/create-database-with-search-functionality/#post-9406476) * Its a wordpress site, I will go through the links your provided – Thanks * Thread Starter [sparty](https://wordpress.org/support/users/sparty/) * (@sparty) * [8 years, 10 months ago](https://wordpress.org/support/topic/create-database-with-search-functionality/#post-9406481) * Sorry to add, how to add it into my wordpress database and also how would I search and return values from this database ? Sorry for all the questions and thanks a lot, First time in days I seem to get somewhere * [dayvee](https://wordpress.org/support/users/dayvee/) * (@dayvee) * [8 years, 9 months ago](https://wordpress.org/support/topic/create-database-with-search-functionality/#post-9411968) * no problem, we are both learning. It depends with who you want the data to be displayed to and where? for instance, does your client want the data to be displayed to their audience (or customers) which would mean that this functionality would be presented in the front end of the website for their customers to use or would this functionality be exclusively for the client, who i assume is the web administrator and hence he wants to privately access the information (names and values from excel document) in the wordpress dashboard of his/her site? Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Create database with search functionality’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 4 replies * 2 participants * Last reply from: [dayvee](https://wordpress.org/support/users/dayvee/) * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/create-database-with-search-functionality/#post-9411968) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics