+ Reply to Thread
Results 1 to 4 of 4

converting spreadsheet from website to different format

  1. #1
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    converting spreadsheet from website to different format

    For years I have been puzzling over a spreadsheet which consists of a list of products, each product described on one row consisting of 10 cells.

    But when I copy the spreadsheet and print it on an excel blank sheet - each product is converted into a column of 15 cells, all stacked on top of each other, creating a long column of single cells.

    Is there any way to reproduce this spreadsheet into an excel sheet that looks just like the original?

  2. #2
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: converting spreadsheet from website to different format

    Do you have a copy of this starting sheet to new sheet.
    Have you also tried to paste special - Unicode this tends to help with such issues.

    Really though an example of this would be helpful in finding you the right fix as the originating spreadsheet or data set has a lot to do with the outcome.
    -If you think you are done, Start over - ELeGault

  3. #3
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: converting spreadsheet from website to different format

    to see the sheet - search for "elnativo growers" - then click on "Availability" - then install user name "elnativo" and password "report" - then click on "full list"

  4. #4
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: converting spreadsheet from website to different format

    Ah- Its PDF. There is actually an option within PDF/Adobe that will allow you to export into Excel.
    It is a paid account, but you get the first 12 months free or something like that. And even so it is not a big price.

    That would be the best course of action... Now, you could also set an offset formula... but I would recommend just signing up and using the export option as it will be much quicker for you and less to maintain.

    Attached is what you would get if you did the export!

    Note - There are free websites such as https://www.pdftoexcelonline.com/en/ you could utilize too
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using Spreadsheet to link to a website
    By Erik Thomas in forum Excel General
    Replies: 9
    Last Post: 12-09-2012, 08:29 AM
  2. Publish spreadsheet to website.
    By schleprock in forum Excel General
    Replies: 0
    Last Post: 07-11-2011, 12:25 AM
  3. Spreadsheet to website forms?
    By LTT in forum Excel General
    Replies: 0
    Last Post: 10-27-2010, 03:26 PM
  4. Website to Spreadsheet
    By RGBvsCMYK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2008, 07:46 PM
  5. Replies: 1
    Last Post: 10-08-2005, 12:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1