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

learn more… | top users | synonyms

-2
votes
0answers
11 views

Import PDF Form [closed]

Hi I have a lot of forms that are already in a pdf format that I would like to see if I can just import them into you form builder and work from there instead of recreating the wheel. Is that ...
1
vote
1answer
16 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 ...
0
votes
0answers
16 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
54 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
42 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 ...
1
vote
2answers
47 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
50 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 ...
2
votes
1answer
29 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
37 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
28 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 ...
1
vote
1answer
106 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
58 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
1answer
578 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 ...
2
votes
1answer
209 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
1answer
177 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 ...
3
votes
0answers
124 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 ...
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 ...
2
votes
1answer
102 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: ...
3
votes
1answer
88 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
1answer
79 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 ?
5
votes
2answers
391 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 ...
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 ...
2
votes
1answer
248 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 ...
6
votes
1answer
8k 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 ...
1
vote
2answers
339 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
70 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
673 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: ...
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 ...
3
votes
2answers
496 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
1answer
124 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, ...
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
0answers
642 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 ...
3
votes
2answers
355 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 ...
1
vote
0answers
204 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
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 ...
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?
4
votes
2answers
504 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 ...
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
882 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 ...
0
votes
1answer
978 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 ...
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, ...
1
vote
0answers
121 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 ...
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: ...
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?
5
votes
1answer
13k views

Google spreadsheet: Importing only certain rows

Regarding Google spreadsheets, document 1 has many rows of data. How do I import into document 2 only those rows that have a certain value in column C?
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 ...
1
vote
0answers
426 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 ...
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 ...
4
votes
0answers
545 views

Is there a way to export all blog posts in Google Sites and import it into Blogger?

I have a Google Site that contains an announcement page. This announcement page is serving like a blog within Google Sites right now, but I would like to migrate it to use Blogger instead. I ...