+ Reply to Thread
Results 1 to 2 of 2

Import from Excel to Google keeping formatting

  1. #1
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sefton
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    131

    Import from Excel to Google keeping formatting

    I have a document with 9 tabs, each tab has over 300 rows of data.
    In Excel half of each tab contains cells which have content in two different formats. Some of the text in the cell is black, and some of it is bold & red (within the same cell). The red text comes from external customers to update the issue identified in that cell.
    I need a way to quickly import this data to the google sheet keeping this formatting in tact. Both uploading the whole document, and copying the data across fails to keep the formatting.

    The table looks something like this - the faults can go up to #30 on occasion. It's the fault cells which contain the mixed formatting text.
    Comany Manager Name Address Info1 Address Info2 Visit Date Visit Reason Savings £ Job ID Fault 1 Fault 2 Fault 3

    The data that populates this table is exported from elsewhere in this format, so for the time being at least I'm looking for a solution that would benefit this process as it currently stands.
    If you can however suggest a better process for recording this information (and the clients responses) I'm open to ideas - but would need a method to import the historical data from my Excel document.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    08-16-2012
    Location
    Sefton
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    131

    Re: Import from Excel to Google keeping formatting

    I know you can sort the columns via the text colour, so is it possible to separate the cell contents using the change in font colour as the limiter? There must be something somewhere that recognises the different font colour as the sort options work.

+ 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. Google news alerts import
    By dankin in forum Excel General
    Replies: 0
    Last Post: 09-08-2015, 12:29 PM
  2. Import from Google Docs
    By www.vyuka-excelu.cz in forum Excel General
    Replies: 0
    Last Post: 07-22-2015, 11:30 AM
  3. discrepancy between Excel and Google spreadsheet import
    By Bniemeyer in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-26-2014, 05:53 PM
  4. Error formatting when import data from google into excel
    By Jeferson11 in forum Excel General
    Replies: 5
    Last Post: 02-18-2013, 11:14 AM
  5. How can I import Google results number to Excel?
    By pinkpantherksa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2012, 07:59 PM
  6. Google Earth lat./long. import to Excel
    By PCAg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2012, 10:47 AM
  7. Replies: 0
    Last Post: 08-12-2010, 07:52 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