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
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 ...
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
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?
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 ...
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.
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
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
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 ...
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 ...
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 ...
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
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
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 ...
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
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”, „...
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 ...
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?
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 ...
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
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 ...
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. ...
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
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 ...
1
vote
1answer
1k views

LastPass import feature does not work, v4.1.62 on Firefox v55.0.2 (64-bit)

I'm trying to get LastPass to import my passwords in a CSV file exported from Avast Passwords. For some strange reason, the option to import passwords doesn't seem to work. The screenshots below ...
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 ...
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 ...
1
vote
2answers
3k views

How do we insert images from Google Drive to spreadsheet cells? [duplicate]

How do we insert images from Google Drive to spreadsheet cells?
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 ...
1
vote
1answer
691 views

How to slow down too-frequent execution of Import() functions?

I have a Google Spreadsheet that uses a number of import() functions, including the third-party importJSON() function. It all works great, except that I keep apparently exceeding the limit on how ...
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 ...
4
votes
1answer
831 views

How to use Gmail to check emails from external accounts

I had my Gmail account checking another (non-Gmail) account, with "leave a copy of retrieved message on the server" option set. The provider changed the username format (by adding the @-part). When ...
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 ...
-2
votes
1answer
427 views

Google Sheets slow - 1. mobile? 2. why? 3. importrange [closed]

Update: Google Sheets is much faster when using Incognito Google Sheets is so slow on desktop but really fast on mobile. Is it supposed to be like that? If so, why? If not, what are some factors that ...
0
votes
1answer
604 views

How to import only sheets with specific text in the name?

I'm using this script but it takes all sheets of current spreadsheet. A bit modified script from original, but it doesn't achieve what I want: function importallMain() { var id = 'some id'; var ...
-1
votes
1answer
111 views

Importing selective rows from JSON to Google Sheets and avg

I would like to import two rows from JSON into a Google Sheet. The JSON is structured like this: {"type":"A","features":[{"type":"Feature","properties":{"countA":27,"name":"NameA","countB":2},"...
1
vote
1answer
3k views

MotoGP 2017 events to Google Calendar

The 2017 Calendar of MotoGP™ is published on the web. Is there any way to import MotoGP 2017 events to my Google Calendar?
0
votes
1answer
1k views

How to filter range and return only specific columns?

This is what I have tried just yet: =QUERY(FILTER(Recherche!A4:O1002), "select Col1, Col15, Col2, Col3, Col4") based on this format =QUERY(FILTER(B:D,D:D>=2),"select Col2, Col1") What I get is ...
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'...
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 "...
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
votes
2answers
2k 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
0answers
36 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....
4
votes
1answer
2k 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 ...
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 ...
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://...
1
vote
0answers
95 views

How do I go about importing emails from my cPanel export into Gmail Apps for Work?

Long story short I'm moving my hosting to Digital Ocean from Namecheap, and I paid $15 to get a full export of the cPanel (no longer have access to the hosting account itself so the backup export was ...
2
votes
1answer
760 views

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. There is no way I will remember everyone I gave this email to. How can I keep receiving emails sent to this address? ...
2
votes
0answers
75 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 ...