Copying a table from Excel into Business Express

From time to time you may wish to copy and paste a table into Business Express from Excel.

Excel formatting is not compatible with HTML formatting by default but there can be work arounds.

Here is a process which can help you get your text table out of Excel and neatly into Buinsess Express.


 * 1)  Open your spreadsheet with your table
 * 2)  File > Save as.
 * 3)  Change the "Save as type:" from "Excel Workbook" to "Web Page (*.htm;*.html)
 * 4)  Save the file to your desktop
 * 5)  Minimise everything and find your new HTM file on your desktop
 * 6)  Open this file in a browser by double clicking it.
 * 7)  From the browser window, click in it and holding down Ctrl on the keyboard, press the letter A  (this will select all)
 * 8)  Now Ctrl and the letter c (for copy)
 * 9)  Go into Business Express, into a rich text box, such as that in Information Centre and ctrl and V (for paste)

Providing your table isn't too complext it should now be visible properly formatted for HTML.

If you are a HTML fan, Excel will add an awful lot of duff and dud HTML which isn't necessary, however this is a quick and easy way to get a table from Excel into HTML.

Images, objects and embedded items simply won't transfer unless you modify HTML directly, so this method is only for text based tables.