Dreamweaver: Create HTML tables from CSV files
Using Dreamweaver you can easily create HTML tables from existing—tab or comma delimited—CSV files.
Here is an example CSV file I created using Google Docs.
Make sure to save the file as a CSV file.
Create a new HTML file in Dreamweaver and go to File->Import->Tabular Data…
- Click browse to navigate to the .csv file
- Specify table width, cellpadding, cellspacing etc. and press OK
And here it is HTML table generated from the CSV file.
Jed Benoit
I love when someone posts an intuitive solution that works flawlessly. Thank you!
eplicanic
Thanks Jed!
Kev
How can I import just a particular part of a csv file?
eplicanic
I don’t think you can do it directly from a CSV. But, if you import the whole CSV and save it as an HTML table, you can use that table as a Spry Data Source. Here are the steps:
1. Import CSV into n HTML table following this tutorial
2. Give the table an ID, i.e. id=”data”
3. Save the file. i.e data.html
4. Create a new HTML file and go to Insert->Spry->Spry Data Set
5. A three step wizard will launch that will help you with the rest.
6. On the last step of the process make sure to click the “Set Up…” button, which will help you pick the columns
I know it’s not as simple, but you may like the result!
Suhail
Is there a script that generates a table on the spot, from a csv file saved on the server? I want a small database that stores everything in a csv file, and an html file that generates a table from the csv file.
Also, is there a way to edit csv files using HTML?