putting excel sheet in wordpress blg

F

freejobalerts

Regular Member
Joined
Nov 21, 2025
Messages
287
Reaction score
44
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
 
Advertise on BHW
Use Search & Filter Pro or JetEngine to create a searchable database.Import all 7 Excel sheets as a custom post type (or database table).Add two search fields: Roll No + DOB.Show the result only when both fields match.
 
Catalinaa said:
this can be done by not importing the excel file. Instead, the file should be imported to a proper table and the search form should be created with criteria as roll number and DOB.
Click to expand...
dont want to create sep 7 db fr categry wise search
 
For this volume of information, it will be better not to store this information in Excel format. Import all sheets into a special database table and use a search form by DOB and roll number. The process can be done either using WP Data Tables plugins or even via WP queries with ACF.
 
The Excel data can be imported into a custom post type or database table and searched with the help of a search/filter plug-in for custom fields. For instance, the combination of WP All Import with FacetWP/Search & Filter Pro can perform a roll, DOB search without creating thousands of pages
It is not recommended to store all data in posts if the data is huge; a custom table would work better.
 
Import the excel data into a database table and use a search/filter plugin.
tablepress or a custom query should work for this.
 
Don’t embed the Excel sheets as normal tables, because the full rank list may still be visible in the page source. Import the sheets as CSV into a database and use the free Participants Database WordPress plugin. Create fields for roll number, DOB, category, rank, etc., then make a search form requiring both roll number and DOB before showing a matching record.

Keep DOB formatted consistently, and don’t display the complete database publicly. For only 700 rows, this should work fine without a paid plugin.
 
freejobalerts said:
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
Click to expand...
avoid the use of Excel as the front end. the data must be exported to a real table or database, whereupon a look-up should be made based on Roll No & DOB.
 
freejobalerts said:
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
Click to expand...
wp table builder is an excellent tool for this kind of job.
 
I often use the WP DataTables plugin. The free version of this plugin fully supports importing Excel files and enabling column filtering. You can try it out.
 
freejobalerts said:
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
Click to expand...
excel will be shown for only 700 row, but I would not do that. It is possible to use a filter form by using data that can be imported to a table with Roll No + DOB.
 
freejobalerts said:
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
Click to expand...
only 700 rows have to be imported nd for that a table plugin will suffice, although preferably without having to show the spreadsheet. Import the data to the table and apply a filter by Roll No.+DOB.
 
freejobalerts said:
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
Click to expand...
even for just 700 record , there is no need to create page separately. just import this data in a table and make a sarch facility using Roll No/DOB.
 
Since you have this amount of data, I wouldn’t use Excel for storage of all of them. Rather, I would use database table to import all the data and use search form based on DOB and roll number. You can achieve this either via WP Data Tables plugin or by using WP queries with ACF.
 
in case you plan on keeping the excel data within your WordPress website iwould suggest against uploading the Excel sheets directly into tables.This requires a very small search form where users enter Roll and DOB and the website scans all 7 database for an exact match.
 
freejobalerts said:
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
Click to expand...
for just 700 records, I would go for simplicity and import the excel sheet into WP datatables nd use Roll No + DOB as filter. It is not required that the entire spreadsheet be shown on the webpage.
 
freejobalerts said:
kindly dont dm me for paid solutions and dont give chatgot solutions
plz give plugin or trick

I have rank list in varipis categories

7 excel sheet of 100 row each
I want to put them n wordpress blog and people will use combo of roll and dob then only earchable

any idea hw toa chive it
Click to expand...
In case of only 700 entrie I would advise against showing excel on the blog. Just import it into the databas nd use a simple filter for Roll No + DOB, I feel it should be easy to manage.
 
Put all 7 categories in one table and add a category option. Users can select the category, enter Roll No and dob and see only their result.
 
Since there are only around 700 records, importing the data into WordPress and adding a simple search/filter would probably be easier than keeping the Excel file embedded.
 
you can embed the Excel file directly if you need people to view it. for regular updates, I would use a proper table plugin instead.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top