Tip: Copying data from Excel

Here's a simple little trick, courtesy of Ian Yorston. If you've got a bunch of data in an Excel spreadsheet that you'd like to copy into ProjectForum, you can use Excel's 'concatenate' function to build up a ProjectForum table from your data.

So let's say you've got a three column table, starting at cell A1, and going down a whole bunch of rows. Somewhere else in the spreadsheet, enter this into a cell:

=concatenate("| ", A1, " | ", A2, " | ", A3, " |")

Next, use 'Fill Down' to create lines for each row of the table (B1/B2/B3, C1/C2/C3, etc.).

Copy the resulting cells (one column wide by the number of rows in your original table high) into ProjectForum, perhaps prefacing it with "[tablestyle:borders]" if you'd like to show a grid.