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

learn more… | top users | synonyms

1
vote
1answer
78 views

How do you import multiple VCF or CSV Files to Google Contacts

I was trying to find a way to import multiple VCF/CSV contacts to Google Contacts in one shot, instead of adding one by one.
1
vote
1answer
22 views

Align the rows of one sheet with the rows of an imported sheet

I have a spreadsheet of employee names. I am using =IMPORTRANGE() to import the names into another spreadsheet that tracks expenses in rows next each of the imported employee names. The problem is ...
3
votes
3answers
525 views

Import current price from website to spreadsheet

As you can probably gather from the title, the goal is to plug the current price of this product into a spreadsheet. Perhaps I'm over-complicating things, but there must be an easy way to do this. ...
0
votes
2answers
136 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, S&...
2
votes
1answer
108 views

Extracting GICS codes from Fidelity website

This is the website: https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols=aapl&type=o-NavBar I'm trying to pull out the following two pieces of data into a Google Sheet: ...
1
vote
2answers
362 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 ...
2
votes
1answer
196 views

ImportXML with XPath does not return an entry of a table

Using Google Sheets with IMPORTXML to scrape a piece of information from a website via XPath. Here's the site (click here). The specific piece of information I'm trying to extract is the Price/Sales ...
0
votes
0answers
22 views

IMPORTDATA() with Google Sheets

I am trying to use the IMPORTDATA() function on Google Sheets. Initially I tried downloading yahoo finance data, which didn't work. However, I cannot seem to get the function to work even using ...
3
votes
1answer
100 views

IMPORTHTML 'could not fetch URL' but used to be able to

I made a spreadsheet, a part of which uses the IMPORTHTML function to get data from this webpage. For the first couple of weeks that it ran, it worked pretty great, getting all the data from the table ...
-1
votes
2answers
59 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 ImportJSONBasicAuthentication(...
1
vote
2answers
48 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
1answer
57 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 qlist-...
2
votes
1answer
34 views

Present importXML output in reverse order

How to reverse the order of the output of imporxml? For example, =importxml("http://example.com","//p") outputs +---+---------------------+ | 1 | This domain is ... | | 2 | More information... | +--...
1
vote
1answer
51 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 ...
2
votes
0answers
29 views

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

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 data....
1
vote
1answer
125 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 ...
4
votes
1answer
64 views

Is it possible to 'reset' the value of a cell in one sheet from another sheet?

I have two separate google sheets (GlobalReport & IndividualReport). Both share information between each-other, but I need to be able to "reset" a cell value in the IndividualReport sheet. Cell ...
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
4answers
12k views

How to export / import entire Google Sites?

Is there a way to export / import an entire Google Site? If not possible, is there a way to export / import selected pages?
9
votes
1answer
9k views

How to import JSON data into Google Spreadsheets?

There is IMPORTXML function to import data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Is there any similar solution to import data in JSON ...
2
votes
1answer
824 views

Import JSON to Google Sheet using Google Apps Script

I am using Apps Script in Google Sheets to import JSON from Google Analytics. I have previously used the ImportJSON function to easily get the JSON from an open API just using =ImportJSON(url) within ...
3
votes
0answers
141 views

Calculate distances between various places in Google Maps

I have the following problem: I have two lists of addresses X and Y, both as an excel table or csv file, and would like to use google maps to automatically calculate the distance between each possible ...
3
votes
1answer
2k views

Importing contacts from Gmail, Yahoo, Hotmail and Facebook [closed]

I need to import my contacts from Gmail, Yahoo, Hotmail and Facebook and many more. I am aware of the Google APIs. Are there any libraries which allow me to import all the contacts or should I dirty ...
0
votes
1answer
801 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 ...
2
votes
1answer
224 views

College is going to delete all email accounts. How to keep receiving emails with same address from places I cannot remember right now

My college is using Gmail. The format of my address is 'myname@student.college.edu' How can I keep receiving emails sent to this address? There is no way I will remember everyone I gave this email ...
2
votes
0answers
37 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 ...
4
votes
2answers
514 views

Monitor webpage changes using Google Spreadsheets

I want to monitor a web page. The best solution I found was Google Spreadsheets (apart from feed43 which has limitations). I'm using the importHTML function in Google Spreadsheet which will update ...
2
votes
1answer
9k views

Importing contacts and emails from Yahoo to Gmail

How do I import ALL contacts and emails from Yahoo to Gmail in one go, if there is no "Accounts/Import" tab? Is there an easy work around?
2
votes
2answers
2k views

How to import somebody else document from GD to my Google Drive?

I have a link to somebody else GD document. I would like to copy/import it to my GD so for example, if that person deletes the file I would have a "local" copy. I can copy&paste entire document, ...
2
votes
1answer
256 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 ...
10
votes
3answers
4k views

How to import from Google Keep or save all locally?

I have a lot of notes in Google Keep. Can I save this info locally on computer or import to MS Word? Not every note separately but all together?
3
votes
1answer
89 views

Calling importRange from within another function

I have a bunch of separate spreadsheets and I'm creating an overview spreadsheet which pulls data from each of the others. I also need to apply the COUNTUNIQUE formula to that data. If I simply type ...
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
vote
1answer
112 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
73 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: =QUERY(IMPORTRANGE("0AuFgJ0VZkU8kdHdnU0N2Y3hFU3B6bkpjdEFsUEZOcXc"&...
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 ...
5
votes
2answers
405 views

With Google Docs/ImportHTML(), how do I then modify the data?

I'm using ImportHTML() on a Google Sheet to import a large table from a website. It's great, and it's now all there, but now I want to hand-modify the data to my needs. Unfortunately, every time I try ...
0
votes
1answer
82 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 ?
10
votes
1answer
33k views

Google Calendar Import or Copy All Entries From a WebCal:// URL

I have a webcal:// url for a calendar with a lot of entries, I can "add" the calendar in the "other calendars" section of my Google Calendar. But this isn't part of my calendar so will not sync with ...
6
votes
5answers
9k views

How to upload a file into Google Docs, given a URL

I want to edit a web document that I see open in my browser. What can I do? I have discovered that I can use the viewer, like this: https://docs.google.com/viewer?url=http://www.irs.gov/pub/irs-pdf/...
1
vote
1answer
702 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: https://www....
1
vote
0answers
70 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 ...
22
votes
3answers
2k views

How can I import Facebook events into my Google calendar?

I get a lot of invitations via Facebook, but I keep track of my schedule with Google calendar. Is there any way to automatically import or sync my Facebook events to my Google calendar?
6
votes
2answers
1k views

How can I import an hResume into LinkedIn?

I have a public CV at careers.stackoverflow.com which supports the hResume format. I understand that LinkedIn supports hResume format. How can I import my careers.stackoverflow.com resume into ...
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 ...
41
votes
9answers
97k views

Automatically open ICS files in Google Calendar

Lots of web sites have an option to export events as an ICS file that can then be imported into a desktop or web-based calendar (for example if you're invited to a Facebook event there will be an ...
1
vote
0answers
716 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 ...
8
votes
1answer
898 views

How to add long list of names to Google Plus circles?

I belong to a group for which I'd like to create a Google Plus circle. I already have a flat ASCII file containing the names. There are about 40 of them, and I'd prefer not to have to type each one ...
2
votes
2answers
4k views

Importing to GMail from Yahoo! Mail Plus takes forever

I've decided to migrate over to GMail, so of course I would like to migrate my old Yahoo emails and forward Yahoo mail to GMail for a few months until the transition is complete. (Yes, I've already ...
3
votes
2answers
361 views

importXML strips leading zeros in Google spreadsheet

I extract one number from an XML online file with Google Spreadsheets. Sometimes the number starts with a zero but the spreadsheet removes it. I'm sure the format of the cell is 'plain text' (I press ...