Text to Table

Converts selected text into table


Author(s) : Onetastic ★
Category : Table
Last Updated : September 20, 2022
Requirements : OneNote 2010 or above
Watch this short video to learn more about this macro
Screenshot :

Text to Table

Leave empty for TAB character as delimiter
Changelog :

September 20, 2022 (92F8ED) - Onetastic ★
Added option to choose delimiter

March 08, 2022 (AB968E) - Onetastic ★
Fixed a bug where macro would fail to complete if there are tags on the selected paragraphs

November 22, 2021 (C51564) - Onetastic ★
Macro no longer leaves blank lines after the table

March 04, 2019 (705973) - Onetastic ★
Now copies tags from each paragraph to the first cell in each row in the table.

May 15, 2017 (780F89) - Onetastic ★
Fixed certain cases where the table would not appear at the location of the selected paragraphs.

June 20, 2016 (BDBDC6) - Onetastic ★
Re-written with the new Macro Language to take advantage of cleaner syntax and performance improvements

These versions are no longer supported:

July 05, 2014 - Onetastic ★
Now correctly generates columns from tab characters. Original version did not generate columns

April 05, 2014 - Onetastic ★
Initial version


Paul Feldman - 2022-06-22
Add a popup box that asks for a column delimiter. Put each bit of text in a separate column. So for example if there's raw data that looks like:

Alpha: $10m
Beta: $12m
Gamma: $5m

The user would select a colon as the delimiter, and that would create a 2-column, 3-row table. Thank you.
Robert Jacobson - 2021-12-03
I have one problem with this macro -- it modifies the entire page.  For me that's a problem because I often have multiple people editing sections of the page.  OneNote marks those sections with their initials.  

When I run this macro, I then "own" all of the page; the information for other users editing page sections is lost.
julien - 2018-08-01
works like a charm but I would appreciate a version able to conserve the tags !