Posted July 3, 20169 yr 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 Edited July 3, 20169 yr by Dannyboy
July 3, 20169 yr 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.
July 3, 20169 yr Author 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
July 3, 20169 yr 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 ;) 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.
July 3, 20169 yr 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.
July 3, 20169 yr Author 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 ?
July 3, 20169 yr Author It doesn't even have to be a table, just coding that will put things into more organised columns
July 4, 20169 yr <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? Edited July 4, 20169 yr by richie
July 4, 20169 yr 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.
July 4, 20169 yr Author 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
July 5, 20169 yr 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..
July 5, 20169 yr Author 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
July 5, 20169 yr 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.
Create an account or sign in to comment