Creating a table - BuzzJack Music Forum

BuzzJack - Entertainment Discussion _ Site Communications _ Forum News and Help

Latest Site News

Hozier gets a second week at number one

Hozier climbs to number one

A chart double for Beyonce

Creating a table

Display modes

Track this thread - Email this thread - Print this thread - Download this thread - Subscribe to this forum

Dannyboy View member profile	3rd July 2016, 11:50 AM Post #1
BuzzJack Legend Joined: 26 May 2006 Posts: 24,574 User: 632	How can I take Spreadsheet data and put it into a table format so its easier to read - Pos Act Song Pos Weeks Points 484 Akon Right Now 6 31 1873 485 Akon Beautiful 8 35 1869 486 Katy Perry California Girls 1 35 1868 487 Bruno Mars Billionaire 3 32 1868 488 Olly Murs Troublemaker 1 35 1864 489 Sinitta So Macho 2 30 1864 490 Boyz II men End of the road 1 26 1864 491 Leona Lewis Run 1 44 1861 492 Platters Smoke gets in your eyes 1 20 1860 493 Madonna Crazy for you 2 23 1857 494 Naughty Boy Runnin 4 27 1855 495 One Direction Drag me down 1 31 1852 496 David Guetta Play Hard 6 29 1849 497 Ellie Goulding Your Song 2 33 1846 498 Calvin Harris I need your love 4 29 1845 499 Pat Boone Friendly Persuassion 3 21 1843 500 Lorde Royals 1 34 1839 This post has been edited by Dannyboy: 3rd July 2016, 05:26 PM


Mart!n View member profile	3rd July 2016, 12:30 PM Post #2
Infamy Infamy they all got it in for me Joined: 5 March 2006 Posts: 129,134 User: 2	The only way I can think of... is to screen shot it, and import it as a image through photobucket or other photo sites. Unless anyone else can shed more light on it.


Dannyboy View member profile	3rd July 2016, 12:34 PM Post #3
BuzzJack Legend Joined: 26 May 2006 Posts: 24,574 User: 632	QUOTE(Mart!n @ Jul 3 2016, 01:30 PM) The only way I can think of... is to screen shot it, and import it as a image through photobucket or other photo sites. Unless anyone else can shed more light on it. I know someone showed me the coding for it years ago but I cant remember now


Spinning Adam View member profile	3rd July 2016, 02:41 PM Post #4
Former iconic poster with no consistent posting style Pronouns: Don't take em seriously tbh Joined: 20 June 2014 Posts: 20,582 User: 21,005	QUOTE(Mart!n @ Jul 3 2016, 01:30 PM) The only way I can think of... is to screen shot it, and import it as a image through photobucket or other photo sites. Unless anyone else can shed more light on it. Yeah this is the best way that I'm aware of. If you use Excel I know you can select part of the spreadsheet you want to post, copy and then paste it into Paint, save it as an image then upload on imgur.com/whatever image upload site and paste the link to it in your post QUOTE(Dannyboy @ Jul 3 2016, 01:34 PM) I know someone showed me the coding for it years ago but I cant remember now On this forum? That's quite interesting. I've not seen a non-screenshotted table on here before. It's always been image tables I've seen in the major BJSC results at least.


mdh View member profile	3rd July 2016, 02:47 PM Post #5
BuzzJack Legend Joined: 19 December 2015 Posts: 20,102 User: 22,776	I use a screenshot tool where you select your screen part to copy, press enter and it gives you a url that you can paste into a post. It takes seconds, and saves time uploading it to a website.


Dannyboy View member profile	3rd July 2016, 03:01 PM Post #6
BuzzJack Legend Joined: 26 May 2006 Posts: 24,574 User: 632	QUOTE(BASTILLEmdh @ Jul 3 2016, 03:47 PM) I use a screenshot tool where you select your screen part to copy, press enter and it gives you a url that you can paste into a post. It takes seconds, and saves time uploading it to a website. Hi, whats the screenshot tool ?


mdh View member profile	3rd July 2016, 05:09 PM Post #7
BuzzJack Legend Joined: 19 December 2015 Posts: 20,102 User: 22,776	Lightshot I believe.


Dannyboy View member profile	3rd July 2016, 05:22 PM Post #8
BuzzJack Legend Joined: 26 May 2006 Posts: 24,574 User: 632	It doesn't even have to be a table, just coding that will put things into more organised columns


richie View member profile	4th July 2016, 08:44 AM Post #9
Poet and Storyteller Joined: 11 March 2006 Posts: 6,753 User: 166	CODE <table><tr><th>Heading 1</th><th>Heading 2</th></tr><tr><td>Data 1</td><td>Data 2</td></tr></table> That's the HTML above, but the code option doesn't seem to support it. Does anyone know a way for this to accept HTML? This post has been edited by richie: 4th July 2016, 08:46 AM


Philip View member profile	4th July 2016, 01:37 PM Post #10
Creator/ Joined: 2 March 2006 Posts: 8,048 User: 1	pre currently is the best way, if your tabs are well defined (they are columns in Excel) then you can copy/ paste into here and add the pre tags: Test1 Title1 Name1 Test2 Title2 Name2 Test3 Title3 Name3 Test4 Title4 Name4 Test5 Title5 Name5 Test6 Title6 Name6 Test7 Title7 Name7 Test8 Title8 Name8 Test9 Title9 Name9 Test10 Title10 Name10 Test11 Title11 Name11 Test12 Title12 Name12 Test13 Title13 Name13 Test14 Title14 Name14 Test15 Title15 Name15 Test16 Title16 Name16 Test17 Title17 Name17 Test18 Title18 Name18 new site will have the ability to add a table either immediately or in phase 2, but certainly on the plan.


Dannyboy View member profile	4th July 2016, 05:18 PM Post #11
BuzzJack Legend Joined: 26 May 2006 Posts: 24,574 User: 632	QUOTE(Phil @ Jul 4 2016, 02:37 PM) pre currently is the best way, if your tabs are well defined (they are columns in Excel) then you can copy/ paste into here and add the pre tags: Test1 Title1 Name1 Test2 Title2 Name2 Test3 Title3 Name3 Test4 Title4 Name4 Test5 Title5 Name5 Test6 Title6 Name6 Test7 Title7 Name7 Test8 Title8 Name8 Test9 Title9 Name9 Test10 Title10 Name10 Test11 Title11 Name11 Test12 Title12 Name12 Test13 Title13 Name13 Test14 Title14 Name14 Test15 Title15 Name15 Test16 Title16 Name16 Test17 Title17 Name17 Test18 Title18 Name18 new site will have the ability to add a table either immediately or in phase 2, but certainly on the plan. I use Excel but when I use Pre, I get this - Baha Men Who let the dogs out 2 29 1952 One Direction History 6 32 1951 Tom Jones Help Myself 5 26 1951 Savage Garden Truly Madly Deeply 4 32 1949 Jimmy Young Unchained Melody 1 22 1948 Frankie Laine A woman in love 1 21 1946 Kenny Rogers Ruby don’t take your love to town 2 23 1943 Julie Rodgers Wedding 3 24 1938 Dean Martin Return to me 2 22 1935 Tinie Tempah Written in the stars 1 38 1932 Aqua Barbie Girl 1 27 1930 Del Shannon Runaway 1 22 1923 Route 94 My Love 1 34 1919 Tom Jones Green green grass of home 1 22 1916 D:Ream Things can only get better 1 27 1915 Roy Orbison In dreams 6 23 1910 Gerry & the pacemakers Youll never walk alone 1 22 1907 Martin Solveig Hello 13 31 1902 Glee Don’t stop believin 2 37 1901 Beatles I want to hold your hand 1 25 1899 Maroon 5 Payphone 1 30 1897 Spice Girls Wannabe 1 26 1897 Dean Martin Gentle on my mind 2 24 1893 Wombles Wombling Song 4 26 1892 Chris Brown Ayo 6 29 1885 Mark Morrison Return of the mack 1 27 1885 Kay Starr Rock and roll waltz 1 20 1882 Bluebells Young at heart 1 24 1881 Sigma Changing 1 30 1879 Shirley Bassey For all we know 6 24 1874 Seekers Ill never find another you 1 23 1874 Akon Right Now 6 31 1873 Akon Beautiful 8 35 1869 Katy Perry California Girls 1 35 1868 Bruno Mars Billionaire 3 32 1868 Olly Murs Troublemaker 1 35 1864 Sinitta So Macho 2 30 1864 Boyz II men End of the road 1 26 1864 Taylor Swift Black Space 4 32 1862 Leona Lewis Run 1 44 1861 Platters Smoke gets in your eyes 1 20 1860 Madonna Crazy for you 2 23 1857 Naughty Boy Runnin 4 27 1855 One Direction Drag me down 1 31 1852 David Guetta Play Hard 6 29 1849 Ellie Goulding Your Song 2 33 1846 Calvin Harris I need your love 4 29 1845 Pat Boone Friendly Persuassion 3 21 1843 Lorde Royals 1 34 1839 Slim Whitman Rose Marie 1 19 1839


Philip View member profile	5th July 2016, 10:35 AM Post #12
Creator/ Joined: 2 March 2006 Posts: 8,048 User: 1	yes this is annoying, will be sorted in the new site (either initial or second release). In the mean time you have to add the extra tabs yourself to lineup the data..


Dannyboy View member profile	5th July 2016, 12:08 PM Post #13
BuzzJack Legend Joined: 26 May 2006 Posts: 24,574 User: 632	QUOTE(Phil @ Jul 5 2016, 11:35 AM) yes this is annoying, will be sorted in the new site (either initial or second release). In the mean time you have to add the extra tabs yourself to lineup the data.. Extra tabs ? I wasn't aware there was gonna be a new site to be honest


Philip View member profile	5th July 2016, 07:59 PM Post #14
Creator/ Joined: 2 March 2006 Posts: 8,048 User: 1	QUOTE(Dannyboy @ Jul 5 2016, 01:08 PM) Extra tabs ? I wasn't aware there was gonna be a new site to be honest where the alignment is off just add/remove a tab in the correct place. It is due to the length of the text pushing the column out.