Taking data from one source and bringing it into the new application or service for use

learn more… | top users | synonyms

2
votes
1answer
230 views

Import a CSV file from a URL to Google Sheets and update it periodically

I'm looking to pull data from a CSV file that gets update regularly into a Google spreadsheet that I can format the way I want. I know how to import the CSV as a one time thing but I don't know how to ...
2
votes
1answer
291 views

google spreadsheet question about data linking between sheets

Here is my spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AgmD6-Z4d2aVdE9pR095OTJrVE1wS3FIZzZpVFRJMmc#gid=4 What I want to happen is I enter data in the sheets marked Head, Neck, Shoulders ...
2
votes
0answers
27 views

Updating/merging rows from imported data that share the same primary key in Google Sheets

I'm using an IMPORTDATA function tied to a auto-running script to pull in a .TSV data file from an obscure webform system. That all works well, and I'm able to generate a nice dashboard from this ...
2
votes
0answers
12 views

Is it possible to import cell data AND cell format from one Google sheet to another? [duplicate]

I'm trying to import data "and" formatting from one sheet to another. I'm using =importrange("docID", "sheetName!A1:A30") to get the data, but it doesn't get the format. Suggestions?
2
votes
0answers
36 views

How to import generic messages into Gmail as emails?

I have some messages that I'd like to import to Gmail. The messages were never emails but are conversations from another service. Right now I have them in a csv file with columns From,To,Date,Message ...
2
votes
0answers
312 views

Google Maps; saved KML files will not import

KML files saved from Google Maps will not work when I use "Create map" and try to import them. I have tried from two different PCs using 2 different browsers (IE;Opera). I resorted to this as a test ...
2
votes
1answer
2k views

How can I import from ReadItLater to Instapaper?

I've all but migrated to Instapaper from ReadItLater, but can't acomplish the import and am bummed by the options of using both for a while or (gasp) manual click-add import of couple of hundreds of ...
1
vote
2answers
42 views

Display imported data in reverse order, so that the most recent entries are on top

I want to invert the spreadsheet so I get the data at the top every day. I've tried to =sort(importdata("=importdata("http://www.tr4der.com/download/historical-prices/SPY/"),1,false) but that ...
1
vote
2answers
4k views

How do I import an external HTML file's text into a page on my Blogger blog?

I want to include an APA-style reference list as an unordered list in a Page on my Blogger blog (now called Google Blogs?). I do not want to type it directly on the Page, for several reasons: I want ...
1
vote
2answers
135 views

Sticky Notes with Send/Import Note

There are browser add-ons like Internote Firefox Add-on that save personal sticky notes for web pages in a local file. Is there one that extends the browser Send Link to pass my notes for a page with ...
1
vote
1answer
46 views

Using ImportXML to pull HTML tags along with data

Can ImportXML be used to pull the HTML tags along with the data? For example: importxml(A1,"//div[@id='qlist-wrapper']") on stackoverflow.com will pull all the data in the div with the id ...
1
vote
1answer
26 views

Prevent importXML from spilling text across multiple columns

When importing chat transcript by importXML, e.g., =IMPORTXML("http://chat.stackexchange.com/transcript/7/2015/8/13", "//div[@class='content']") I find that some messages split across several ...
1
vote
1answer
81 views

ImportXML formula no longer working

Here is the formula: =ImportXML("http://www.bloomberg.com/quote/7501:JP", "//div[@class='price-container down']//div[@class='price']") As of several days ago, this formula stopped working. Why ...
1
vote
1answer
1k views

Only display importrange rows that match specific criteria in Google Sheets

In Google Sheets, I'm using IMPORTRANGE to pull in a large list of data (about 400 rows, 6 columns) and I want to only display rows where column D matches EXAMPLE TEXT. Is this a possible? For ...
1
vote
2answers
320 views

IMPORTXML: xpath to get non-distinct parent node data for each child node

Google Spreadsheets has an IMPORTXML function, which I am trying to use to maintain a list of TV episodes, based on the API at http://services.tvrage.com/feeds/episode_list.php?sid=3183. I am trying ...
1
vote
1answer
69 views

Associate cells to imported ones with importrange in Google Sheets

I have the following issue: I have table A with several columns and I use the following function to import some of data to table B: ...
1
vote
1answer
110 views

Transfer data from a form to a new spreadsheet

I have a simple form that inputs entries into a spreadsheet in Google Doc's. All I want to do is open a new sheet and import the data from the forms spreadsheet so I can manipulate it in my own way. ...
1
vote
1answer
217 views

Tumblr RSS importer stopped working

I've been administering several Tumblr blogs since 2009 by means of the RSS import feature and, without any notifications, it would seem like the last time they were updated is late December 2011. It ...
1
vote
2answers
1k views

Export contacts from Yahoo! & Hotmail to Outlook 2007

How can I export my contact lists in Yahoo! and Hotmail accounts to Outlook 2007? If you have done that before, was it easy and %100 percent successful (i.e. no missing or duplicate entries)?
1
vote
0answers
67 views

Google Docs — How to do lossless exporting?

I have several documents created using Google Docs. They are not plain text documents, but documents with images, tables, etc, etc. How can I export this Google Document to my computer, such that I ...
1
vote
0answers
589 views

Import IMO chat history into something readable

I've got a bunch of chats from third-party clients from IMO.im before their service decided to become a proprietary-only client. Problem is, the chat logs are hardly readable as-is, here's a sample ...
1
vote
0answers
202 views

Import messages from Exchange to Google Groups Collaborative Inbox

At the moment we are an Exchange house and wanting to move to Google Apps. We currently have a shared inbox in Exchange that we want to move to Google's Groups Collaborative Inbox but there only seems ...
1
vote
0answers
115 views

How to remove all “alien contacts” appeared after importing contacts from an exported CSV file?

After I exported my Gmail Contacts to a .csv file and reimported them back, I got the “alien” contacts as in the below screenshot—they have no name and something related to Google+. How can I remove ...
1
vote
2answers
874 views

Google Spreadsheet =ImportHTML #value error for specific URL

I'm trying to get the data from http://wodindex.wikispaces.com/ into my spreadsheets. Also from a different subdomain of wikispaces.com the grabbing doesn't work. Trying to get data from this site ...
1
vote
0answers
119 views

Importing online docs into SkyDrive

I hate to download-upload. It is stupid. The acceptable approach is the one we have to insert images into SE posts: there is an option to choose between "from my computer" and URL. Now, I want to know ...
1
vote
0answers
423 views

get a “.ics” Outlook calendar file into Google Calendar

My office IT prevents me from saving an ics file on my computer (at least I can figure out how to do that), but i am able to email myself a calendar at my Gmail address. I open the mail message and ...
1
vote
0answers
868 views

How to import emails from IMAP supporting email provider to Outlook.com?

My current email provider does not support POP or POP3, but does support IMAP. How to import emails from that web-mail account to Outlook.com?
1
vote
0answers
326 views

Google Sheet document using ImportXML doesn't Automatically Republish

I created a file that uses ImportXML to pull prices from a set of web pages, and bless me, it works! To stay updated with the changes in price, I ticked the "Automatically republish when changes are ...
1
vote
0answers
337 views

Does Google calendar import vtodo in ics format?

I am trying to import a vtodo (task in ics format) in Google Calendar BEGIN:VTODO CALSCALE:GREGORIAN BEGIN:VTASK DTSTART:20120731T000000 DUE:20120731T000000 SUMMARY:test ORGANIZER:CN=xxx@xxx.com ...
1
vote
0answers
168 views

If I import email from another email account into Gmail, will sent email also be imported? And will appear as sent in Gmail?

I just had this question. The title really just says it all—if I import email from another account (not a Gmail one) into Gmail, will old sent email also get imported? And will it appear as sent in ...
1
vote
0answers
102 views

Importing Unicode Big Endian files into Google Fusion Tables

Is there a way to import Unicode Big Endian files into Google Fusion Tables? UTF-8 isn't working for me.
1
vote
1answer
634 views

Is there a way to import Trello boards into Todoist?

It doesn't look like there's an officially supported way to do this. Is anyone aware of any other way to import Trello boards into Todoist? Update: Got this link from Todoist support: ...
0
votes
2answers
684 views

Transfer posts from LiveJournal to Blogger

I started off blogging using LiveJournal but I switched to Blogger as I like to do as much as possible inside the Google ecosystem. Is there an easy way to transfer my LiveJournal posts to Blogger, ...
0
votes
1answer
76 views

Import old email from Opera to gmail

Does anyone know how can I move all the email I have in Opera 12 to a gmail account linked to google apps ?
0
votes
1answer
123 views

Retrieve last entry via ImportXML

Looking for help pulling specific cells from a web site into a Google Spreadsheet. I want to pull "last" price from this page but only a few specific ones. Such as Dow, Nasdaq 100, S&P 500, ...
0
votes
1answer
976 views

Importing Gmail contacts to another Google account by Adding a POP3 account

I want to import a gmail account to a google apps account. I have tried the recommended method of adding a pop account. POP forwarding is enabled. I get the following message: Server denied POP3 ...
0
votes
1answer
796 views

How to import mails by contacts from another Gmail account?

I want to import emails from another Gmail account by some specific email addresses? I have created another Gmail account for family and friends and I want all mails by them in my newly created ...
0
votes
4answers
2k views

Is there any web app or script to import contacts using OAuth? [closed]

We want to add invite feature to our site, so users can invite their friends. Is there any web app or script that can import contacts from Gmail, Yahoo, Live, etc using OAuth, so we can send invite ...
-1
votes
2answers
29 views

Fetching JSON in Google Sheets (ImportJSONAdvanced not defined?)

Currently working on fetching data from an API with Basic Authentication. Through this script: https://gist.github.com/anemitz/8cc6ef6c41ea4cefe51a13fbd6d8676a function ...