Score of 19
19
votes
How to import data in Excel from the clipboard as if it was in a text file?
Alternatively, if you have the text data on your clipboard,
you can Use Text Import Wizard...
(I've confirmed that this works for Excel 2010+; not sure about older versions.)
Score of 7
7
votes
Transfer history from firefox to chrome?
Transferring history, bookmarks and other things are easy.
Go to Chrome
Type "chrome://settings/importData" in url.
Then choose what you need to transfer and import.
After that, you should have all ...
Score of 7
7
votes
Import Chrome bookmarks from previous installation
I was unable to make Chrome and Firefox restore my bookmarks from the Bookmarks or Bookmarks.bak json files.
But I found this really helpful online tool to convert those json files to an HTML file ...
Score of 6
6
votes
Import passwords from LastPass to Firefox
Here is an up-to-date method answer:
Export from Lastpass:
Open your Vault
Click on the three dots (More Options) in the bottom left corner and then: Advanced > Export
Save the .csv file
Import ...
Score of 6
6
votes
Accepted
GPG imported and exported public keys do not match
It actually looks a lot like the key on the website – only differing in a few characters at the beginning and in the middle1. In fact, if you strip off the Base64 encoding using gpg --dearmor and then ...
Score of 5
5
votes
Can I retrieve and access a simple JSON object via HTTP in LibreOffice Calc?
After 4 years, they still haven't implemented the suggested FILTERJSON().
This is obviously not a real solution, but one that works for now, for very simple cases:
Send a request to your API using: =...
Score of 4
4
votes
Accepted
Can I retrieve and access a simple JSON object via HTTP in LibreOffice Calc?
I've found the easiest way is using the GetRest Plugin for LibreOffice.
You can use separate cells, one for pulling the data, one for formatting it, and so on. However by combining functions (or ...
Score of 4
4
votes
Accepted
I need to change the palette (.pal file) of multiple images at once. How can I do this?
First you create a new palette by using one of the photos that already has the color plaette applyed to it.
ffmpeg -i SomeImage.png -vf "palettegen" MyPalette.png
Then you copy the following ...
Score of 3
3
votes
I know how to fix Excel dates stored as text, but *why* does it happen?
So, which is the culprit: exporting tool, or Excel?
In one word, both.
Any export utility that creates an Excel formatted file (xls, xlsx, etc) should use Excel formats but far too many don't and we ...
Score of 3
3
votes
GnuPG 2.2 refuses secret key import: "error sending to agent: operation cancelled"
Set pinentry-mode on the command line or in the ~/.gnupg/gpg.conf file.
--pinentry-mode loopback
or just
pinentry-mode loopback in the config file.
Score of 3
3
votes
Accepted
gpgsm: Cannot import private key
It turned out to be a bug that is fixed in GnuPG 2.2.35.
See this mail thread.
Score of 2
2
votes
Anki fails to import from .csv file
I just had this. You need to modify your note type so that it generates cards from the fields in the note.
Go to Manage Notes Types and select the note you want to use.
Add or modify at least one ...
Score of 2
2
votes
Import Vcard (.vcf file) to Nokia 3310 3G phone
Your VCARD format (version 2.1) is fine, the problem is the format of file you are using. You need to set the file format of your .vcf file to dos format. In unix this is easy, open the file in vi, ...
Score of 2
2
votes
How to transfer saved Firefox passwords into Google Chrome
I understand that the problem is importing into Chrome passwords from
Portable Firefox, and the difficulty is that Chrome cannot detect this version
of Firefox for automatic import.
Although not ...
Score of 2
2
votes
How to load existing WinSCP sessions into PuTTY sessions?
For Winscp you can export the settings from winscp to a configfile:
To export/back up your configuration, go to Tools > Export/Backup
configuration on Login dialog.
For Putty you can export the ...
Score of 2
2
votes
Accepted
How to import an old email database into eM Client?
After a good ton of tinkering, the solution turned out to be to downgrade my version of eM Client to one that still used the old database file structure.
From there, I could simply replace the ...
Score of 2
2
votes
Accepted
zfs disk drive letter changed. how to reimport by id
First: The import -d option is not meant to specify the drives, but the directory in which they are exposed:
zpool import [-d dir | -c cachefile] [-D]
Lists pools available to import. If the -d ...
Score of 2
2
votes
Accepted
How can I find and replace in Word 365 (Delete all after year and add a tab)?
More than one way to skin the document hygeine cat, but since the list is messy, and there are years in the miscellaneous info, I don't think there is a one step solution. I would recommend doing a ...
Score of 2
2
votes
Can Outlook update existing calendar events during import?
The .ics file itself needs to have METHOD:REQUEST set for updates, and the SEQUENCE:0 value needs to be incremented for each event entry. Then Outlook will check for existing calendar item IDs to ...
Score of 1
1
vote
How to load existing WinSCP sessions into PuTTY sessions?
As @SavGuard already answered, you can actually use WinSCP as a better session manager for PuTTY.
There's no additional work comparing to opening the session in PuTTY directly. You can open PuTTY ...
Score of 1
1
vote
Accepted
unresolved import 'chromedriver_install' Python(unresolved-import)
Using Ubuntu Linux here... so adapt for Windows or whatever you have<
If you have one package version already installed, and need to replace it with e.g. a newer version - then these things might ...
Score of 1
1
vote
How to add new CSV columns in Power Query?
When you use the Power Query UI to generate a query reading from a CSV file, it unfortunately sets an optional parameter Columns on the Source step, which is not exposed through the Edit Settings pop-...
Score of 1
1
vote
Accepted
How to import a previously exported Ubuntu tarball in WSL?
According to how I read the documentation, importing a WSL distribution is not
connected at all to the Microsoft Store.
You do the import using the command of:
wsl --import <DistributionName> &...
Score of 1
1
vote
Importing big bunch of files to LibreOffice Base table in one shot
The CSV files you describe are not yet ready for insertion into a database. So first, write a script or use shell commands to create a single CSV file containing all records that need to go into the ...
Score of 1
1
vote
tkinter doesnt work for me on anything
For Python 3 you use:
from tkinter import*
window = Tk()
window.geometry("300x300")
window.title("welcome")
window.mainloop()
I should have been using this code....
Score of 1
1
vote
Import Vcard (.vcf file) to Nokia 3310 3G phone
I was not able to direct connect as @Rohan had suggested, but sending file with Bluetooth worked great for me. The phone will load the vcard into your Contacts automatically after the file has been ...
Score of 1
1
vote
Import Vcard (.vcf file) to Nokia 3310 3G phone
it's now end of 2020 and nobody answered. I found a solution by first exporting all the contacts into a csv (comma separated) file. I did this using PC suite on an old XP laptop and connected via ...
Score of 1
1
vote
Accepted
When importing a spreadsheet into Access, how do you prevent Excel from auto assigning a data field type?
You have two choices to handle the issue:
Option 1:
Before Import Sheet to Access, select entire database (Excel Data Range) and set Cell format type TEXT.
Then after if you Import you find all ...
Score of 1
1
vote
Accepted
How to import mantis project?
Now, I've followed the next steps and it works:
Stop running servers for new mantis.
Copy the old mantis "data" folder which in mysql folder to the new mantis mysql folder"Rename the old one".
3.Copy ...
Score of 1
1
vote
How to import "RECYCLER" folders into Windows?
Per chance, I just discovered a workaround:
backup the content of D:\RECYCLER\ to avoid dataloss
create an empty file in D:\
delete this file – this creates the directory D:\RECYCLER\%SID_new%\ where %...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
import × 370microsoft-excel × 92
export × 52
csv × 43
thunderbird × 23
firefox × 20
windows-7 × 19
email × 19
microsoft-outlook × 18
google-chrome × 14
microsoft-excel-2010 × 13
macos × 11
bookmarks × 11
vba × 10
windows-10 × 9
database × 9
microsoft-access × 9
windows × 8
microsoft-word × 8
passwords × 8
mysql × 8
html × 8
microsoft-outlook-2007 × 8
windows-xp × 7
virtualbox × 7