Questions tagged [import]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
23 views

Import and SUM chosen (from drop-down) column to Sheet1 from Sheet2

What formula I can use in cell C2 to import one column from sheet 2 using a drop-down list? Here's the document.
18
votes
3answers
36k 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 ...
0
votes
1answer
53 views

Transport Gmail label to Zimbra

I have several hundreds of emails in a Gmail label which I want to forward to Zimbra. I want to do this systematically, just like the "Accounts and Import" in Gmail, so that making those emails in ...
0
votes
0answers
26 views

Is it possible to export GIFI from QuickBooks Online?

I use QuickBooks Online for my business transactions. Now I need to do corporation tax return and I want to use UFileT2 for this. So I need to import data to Ufile. For import I need to have GIFI ...
0
votes
1answer
56 views

How to import bookmarks.htm into Google bookmarks (NOT Chrome bookmarks)

You can export from https://www.google.com/bookmarks/ because there is an option at the bottom of the list, called "export bookmarks"... but ... you cannot import from a list i.e. bookmarks.htm ...
2
votes
1answer
2k views

Is it possible to re-import a board to Trello?

After exporting a Trello board as a JSON file, is it possible to import it again?
0
votes
1answer
245 views

How to select existing sheet to be populated by a Google form?

I have a team working in pan India with 6 Team leaders. I have created a Google form to collect the everyday status report. Now the question is: How can I assign a particular sheet[already created in ...
2
votes
1answer
25 views

How to import an iCalendar event with diferent time zones

On Google Calendar I'm able to manually create an event that starts and ends in different time zones: I would like to recreate entries like this using the import feature in Google Calendar ((gear) &...
0
votes
1answer
2k views

Importing contacts into Gmail does nothing. Why?

In the Contacts section of GMail, I go to the More... menu, select the .csv file of my contacts and the click Import. The browser thinks for a minute or so then comes back. However, none of the ...
18
votes
6answers
114k views

How do I import email from another email account into my Gmail account?

I have an email account with a provider other than Gmail and want to import that email into Gmail. Is it possible to do this?
0
votes
0answers
134 views

Import Android phone SMS into Google Sheets

I would like to import some filtered SMS from my Android phone to Google Sheets. It could be done: regularly (i.e. every 20 minutes), event based, when an sms is arriving and matches one or more ...
0
votes
1answer
208 views

Where is the “Import from Drive” button in Google Photos

Since July 10th, Google is claiming that there will be an "Import from Drive" option in Google Photos. I don't see it. Is it available yet? The release log from "Backup & Sync" mentions July ...
1
vote
0answers
2k views

Exporting and Importing various Amazon lists; Shopping Lists, Wish lists, Idea Lists, Default List?

This question circa 2011: How to export/download my Amazon wishlist? Now, we have multiple lists in addition to the default wish list, that we make and change various times. At times we wish to ...
11
votes
6answers
39k views

Insert image from Google Drive into Google Sheets

How do I insert/link to images existing in a folder in Google Drive into a Google Sheets spreadsheet? There is the image() function, I imagine using it something like this: image("googledrive://...
0
votes
0answers
73 views

Howto import m3u playlist file to a new or existing YouTube playlist from the command line on Linux

I have a m3u playlist file containing only YouTube urls. How can I import my m3u playlist file to a new or existing YouTube playlist from the command line on Linux into my YouTube channel?
3
votes
1answer
208 views

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 ...
0
votes
0answers
8 views

Import projects with multiple emails into Litmus

I am having trouble with my litmus account. I've talked to their support, and the answers have been less than helpful. I'll get back to that. I had a basic account, and in that account I utilized ...
1
vote
2answers
3k views
1
vote
2answers
136 views

All mail from import went directly to spam folder in Gmail

I have 2 gmail accounts, for example: user1@gmail.com and user2@mydomain.com (using Google apps). On user2@mydomain.com I went to settings: Check mail from other accounts: and added user1@gmail.com ...
0
votes
1answer
668 views

Is it possible to import a formula from another spreadsheet?

I have a master spreadsheet, call it Master, and a lot of copies of this spreadsheet, one for every person in my organization, because they need their own copy. The Master sheet has a lot of formulas. ...
0
votes
1answer
508 views

How to import historical open price in Google Sheets with GOOGLEFINANCE?

For some reason, I can't get the google finance function to work with any open-price lookups I do. For example: =GOOGLEFINANCE("AAPL","priceopen", DATE(2019,4,12)) comes back as #N/A with message: ...
0
votes
0answers
222 views

Can Apple Mail fetch Gmail signatures?

My organisation's people use a mixture of Apple Mail and gmail.com as a client for our Gmail addresses. We use a GSuite app to set peoples' Gmail signatures, which works great for those sending email ...
51
votes
5answers
29k views

How can I import a large list of tasks into Trello

How can I import a large list of tasks (.csv or .txt) into Trello and convert into cards that are part of a list
2
votes
1answer
913 views

Importing sheet into Google Docs but cell images are not shown

I am importing Google Sheet (with images embedded into cells with =image("img_url")) into Google Docs document but the images are not displayed, just the text data. Any idea how to achieve that ...
1
vote
1answer
148 views

Export data from 1 Foursquare account and import it to another one

I see that there's "Export data" option (already requested it). However, is there a way to import it into a new Foursquare account?
4
votes
2answers
3k views

How do I import Playlists to Amazon Music?

I have music that I have purchased from various sources and have them stored on my PC. I want to put everything on Amazon Music so that I can play them from my Amazon Echo or Amazon Dot via Alexa. I ...
0
votes
0answers
17 views

In a Google Doc, how can I make a refreshable “Table of Contents” in a different doc than it indexes?

When I create the table of contents in a particular doc, I'm able to refresh it after changes are made to that doc. I can even copy and paste this TOC to another doc and the links still work. However, ...
0
votes
2answers
2k views

Importing “Reminders” to Google Calendar using CSV file

Google has added reminders in place of tasks on the calendar - very nice as they carry forward to the next day if not completed. I'd like to use these more as I have workflows that follow dates before ...
5
votes
1answer
8k views

How to duplicate a blog on Blogger?

I am wondering how to duplicate a blog. I would like to copy the contents of my original blog and house it under a new URL. The two blogs would not be linked to one another and would be able to grow ...
0
votes
0answers
41 views

Migrate entire IMAP4 mail, including folders structure, to Gmail

When I am adding a new external IMAP4 server to Gmail I am offered an option to specify a label under which all mail from that server will be categorized in my Gmail account. If I do so, will Gmail ...
3
votes
1answer
4k views

How can I import Gmail ZIP (contacts, emails) into another Gmail account?

I have exported all my contacts and emails from my Gmail account (as ZIP file) and want to import them into another Gmail account. How can I do it? I only found solutions using POP3/Imap and it doesn'...
2
votes
4answers
20k 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?
0
votes
1answer
461 views

Why import of my gmail filters is silently failing?

Import of Gmail filters started to silently fail and I am looking for way to fix that. I am using an option on https://mail.google.com/mail/u/0/?hl=pl&shva=1#settings/filters („Import filters”, „...
57
votes
10answers
119k 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 ...
12
votes
1answer
27k views

How to import a Visio format diagram into draw.io?

I've been trying to import a Visio .vsd file into the draw.io web application, without success. I've seen various online references to Visio import being supported, but no exact steps. I've tried "...
12
votes
2answers
36k views

Importing only certain rows between spreadsheet documents

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?
0
votes
1answer
8k views

How can I copy all events from one calendar to another?

Normally if you want to copy all Google Calendar events from one calendar to another, you'd export from one and import into the other. However, if the calendar isn't your own, the export feature isn't ...
0
votes
0answers
4k 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
250 views

Is it possible to import LaTeX document (with formating) into Google-docs?

I prepared a resume / CV using moderncv (http://www.latextemplates.com/template/moderncv-cv-and-cover-letter) in LaTeX. Is there any possibility to import my document into Google-Docs? Since LaTeX is ...
2
votes
1answer
744 views

How to make importJSON leave existing data alone, if calculation not performed?

I'm using the 3rd party importJSON() function, and I needed a way to make it calculate only when I explicitly requested it. Thanks to this question, I now have a way to do that, but a big problem ...
26
votes
5answers
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?
5
votes
7answers
19k views

Importing data into a Google Forms response sheet

I have some Google Forms and would like to import legacy survey data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but I've been ...
0
votes
1answer
539 views

Convert exported Trello JSON to Pivotal Tracker CSV?

I am exporting a board from Trello, to import it into Pivotal Tracker. In order to get the full detail out of Trello, it's necessary to export as JSON. In order to import that detail into Pivotal ...
3
votes
1answer
7k 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
1answer
8k 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
0answers
27 views

Privacy-friendly way of importing 'following' users into new Twitter account?

I am following about 600 Twitter users. Because I don't post anything, I don't care about my followers (90% of them are spam bots anyway). I created a new Twitter account and wish to import the '...
0
votes
1answer
136 views

Dynamically connect Google Sheets to Excel with protection of privacy of information

I know of only one way to import information (live) to Excel from Google Sheets, but it requires "publish to the web" on that Google sheet, and adding a "connection" to Excel. My concern with this is ...
0
votes
0answers
510 views

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

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 ...
0
votes
2answers
282 views

Transfer data from a Forms result sheet to another sheet

I have a simple form that inputs entries into a Sheets. All I want to do is open a new sheet and import the data from the forms sheet so I can manipulate it in my own way. I have tried: =index('...
6
votes
3answers
4k views

Import Yahoo! Mail and contacts to Gmail without Y! Mail Plus

I don't have Yahoo! Mail Plus so when I tried to import from Gmail as someone else has it doesn't work for me and I get migration errors. Only a month's worth of email is imported after I tried to ...