How to Convert Excel to Web Database

Converting Excel to a web database need data, such as this:

 

data tableYou should first select all data, before clicking the File.ribbon file

Click Export (1), press CSV (2), and then press Save As (3).

save as csv

Name the file (1), and press save (2).

press save

Click Yes.

click yes

In conclusion, with these steps, you have what you need to import with access, if you so wish, and keep working on the database. We have just converted the data into a web database that looks like this:

database created

Template

You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial