Teachers' Resources

Excel to HTML

If calling this page from a link in EXCEL, input the information in the fields below that will be constant and Copy the URL to this Configuration.

Using the Excel to HTML Generator

Step	Process
1.	Make sure there arent any hidden rows or columns in the Excel table
	*NOTE:* The Excel Table cells cannot contain any paragraph marks or quotation marks. Quotation marks can be replaced in Excel (" -> "). Paragraph marks cannot be removed in Excel. To remove paragraph marks, copy and paste the table into Word and find and replace (^p -> <br>).
2.	Highlight and Copy the section of the table that will be converted
3.	Paste the info into the box above
4.	Check the appropriate options
	Format First Line: If this option is checked, the first row will be bold, italic, with white text, on a black background. All other rows will be in regular paragraph text. If this option is NOT checked, all rows will be in regular paragraph text.
	100%: If this option is checked, the table will take up 100% of the screen. If this option is NOT checked, the table will automatically resize to fit its content.
	Use Colors: If this option is checked, the first column of the table should contain the six-digit hexidecimal color for the entire row (no # sign). The background of the row will be the indicated hexidecimal color. If this option is not checked, the table background will be transparent.
	No Borders: If this option is checked, the borders of the table will be invisible. If this option is NOT checked, the borders will be set to the standard (outset 1px white).
5.	Press "Compile and Copy" paste the info into true code where the table should appear
	*NOTE:* To format this HTML code as a full page, input the Page Title, and the path to the style sheet and press the "Copy Full Page" button.
	*NOTE:* To automatically change the font-size of all text inside a table on a page, input a local style declaration for the desired font size. Copy a Sample.