# Excel to Markdown

**David Chambers**
dc at davidchambers.me

*Sun Feb 2 12:59:18 EST 2014*

Thanks for sharing this, Sherwood. I'd probably have exported a CSV and

written a Python program to do the conversions, but solving the problem

using Excel itself is a much better solution. :)

On 2 February 2014 08:33, Sherwood Botsford <sgbotsford at gmail.com> wrote:

>* While MMD is wonderful, much of the time you want to do other things with
*

>* the data first.
*

>*
*

>* My problem: I have a whole bunch of small tables I keep on an excel
*

>* spreadsheet for setting my prices for various numbers of trees and whatnot.
*

>*
*

>*
*

>* Here's a couple recipes for using excel data.
*

>*
*

>* Layout your spreadsheet as normal.
*

>* Insert a blank row for the formating row.
*

>* Create a wide column to the right of your table
*

>*
*

>* Each row corresponding to a table row has a formula something like this:
*

>*
*

>* "|"&A1&"|"&B1&"|"&C1...
*

>*
*

>* You will need to modify for possible grouping. E.g. A one line title on a
*

>* 5 column table will end up being
*

>* "|"&A1&"||||"
*

>*
*

>*
*

>* In the blank cell corresponding to the formatting row, type an appropriate
*

>* string of |:--------:|...
*

>*
*

>* My problem was a bit messier than that. I advertise on Canada kijiji (not
*

>* the same as the US version) They allow some formatting in ads but do not
*

>* have a table format at all.
*

>*
*

>* I needed as ascii table. The results of cut and paste from excell into a
*

>* text processor are less than stellar, as data is separated with a single
*

>* tab character. Anything that lines up is coincidence.
*

>*
*

>* My route was to take this notion one step further, and make an ascii
*

>* formated column that would work for either MMD or for text base ads.
*

>*
*

>* First attempt:
*

>*
*

>* "|" & A1 & REPT(" ",15-LEN(A1)) &
*

>* "|" & B1 &...
*

>*
*

>* I didn't like the hard coding of the column widths.
*

>* And if your source column is $2.50 it comes across as 2.5
*

>*
*

>* Second attempt.
*

>*
*

>* 1 blank column for column I want to use.
*

>*
*

>* If our table is 5 columns wide, I need another 5 columns.
*

>*
*

>* F1 in this one has the formula =TEXT(A1,"$0.00")
*

>* Replicate across and down as needed.
*

>*
*

>* Secondly, insert a row above. In this row, but the column width you want
*

>* for the output.
*

>*
*

>* Now your formula for K2 will look like this:
*

>* "|" & F1 & REPT(" ",K$1-LEN(F1)) &
*

>* "|" & G1 ...
*

>*
*

>* At this point if I want flush right text, I have to reverse
*

>* the REPT and the Cell reference. No thoughts of centering.
*

>*
*

>* Sample output results
*

>*
*

>* |Bareroot Bundles of 25 2-3 year olds ||||
*

>* |Bundles |# Trees | Cost| Price Per Tree|
*

>* |:-------------------|:---------|---------:|--------------:|
*

>* |5 Trees |5 | $30.00| $6.00|
*

>* |Single Bundle |25 | $75.00| $3.00|
*

>* |5 Bundles |125 | $300.00| $2.40|
*

>* |10 Bundles |250 | $525.00| $2.10|
*

>*
*

>*
*

>*
*

>* Respectfully,
*

>*
*

>* Sherwood of Sherwood's Forests
*

>*
*

>* Sherwood Botsford
*

>* Sherwood's Forests -- http://Sherwoods-Forests.com
*

>* 780-848-2548
*

>* 50042 Range Rd 31
*

>* Warburg, Alberta T0C 2T0
*

>*
*

>* _______________________________________________
*

>* Markdown-Discuss mailing list
*

>* Markdown-Discuss at six.pairlist.net
*

>* http://six.pairlist.net/mailman/listinfo/markdown-discuss
*

>*
*

>*
*

-------------- next part --------------

An HTML attachment was scrubbed...

URL: <http://six.pairlist.net/pipermail/markdown-discuss/attachments/20140202/8e66a589/attachment.html>

More information about the Markdown-Discuss
mailing list