Hot answers tagged

26 votes

How to import data in Excel from the clipboard as if it was in a text file?

Text to columns (in data tab) have almost the same functionality than your "import from text file has". You can split the text to columns by fixed length or at separators, select data type for each ...
Máté Juhász's user avatar
25 votes

Importing an EPS vector file to Microsoft Word without losing quality

Convert the .eps file to .emf (Enhanced MetaFile, a spool file format used in printing by Microsoft software). There are several ways to do this conversion; for example by using the following ...
Andreas Ley's user avatar
23 votes

gpg2 asking for passphrase when importing secret keys

The issue was explained here in the GnuPG bugtracker; I did not see that earlier today. The solution is: gpg2 --batch --import ~/.gnupg/secring.gpg
0range's user avatar
  • 800
19 votes

How do I import Microsoft Sticky Notes from Windows 7 to Windows 10

On your Windows 7 machine, navigate to the following folder: %AppData%\Microsoft\Sticky Notes Save the StickyNotes.snt file found within to an external backup device. On your Windows 10 machine, ...
Tanner Jotblad's user avatar
17 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.)
YenForYang's user avatar
13 votes

Is there an easy way to convert a Parallels disk to a VirtualBox disk?

The procedure is like this: (Parallels Desktop 12) 1) Prepare the Parallels VM by removing the Parallels Tools and anything that is “special" (mounts, shared folders, etc).. sudo /usr/lib/parallels-...
Imifos's user avatar
  • 311
11 votes

Google Chrome: Import/Export Passwords?

Enable password export in Chrome by going to chrome://flags/#password-import-export, then you can export it to CSV file. Source: How to Export and Import passwords in Chrome browser.
Adam's user avatar
  • 221
8 votes

New .gnupg directory: Import old secret keys into new install

First of all, you're doing a kind of "no-op". gpg is still GnuPG 1.4.20 on Ubuntu 16.04, while gpg2 made a jump from GnuPG 2.0.28 to 2.1.11. Then, while GnuPG 2.1 made some changes to the file formats ...
Jens Erat's user avatar
  • 17.7k
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 ...
Roman's user avatar
  • 179
6 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 ...
absolutezero's user avatar
6 votes

Excel CSV import treating quoted strings of numbers as numeric values, not strings

Excel will auto-detect the format of a CSV field unless the CSV column is in this format: "=""Data Here""" This also works for Google sheets
Chris Halcrow's user avatar
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 ...
5moufl's user avatar
  • 142
5 votes

Where is VirtualBox's virtual hard disks repository?

At the risk of being scolded for not answering the EXACT question... On Ubuntu (and other Linux distributions?), the directory is: /home/[USER NAME]/.config/VirtualBox
BuvinJ's user avatar
  • 271
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: =...
Juha Untinen's user avatar
5 votes

Import passwords from LastPass to Firefox

Here is a simple python script to transform the export into import.csv file="Export.csv" print(""" "hostname","username","password","formSubmitURL","httpRealm","usernameField","passwordField" """ ) ...
Anona112's user avatar
  • 149
5 votes

What are the "tmp" .RAW files showing up when importing pics from Android to Windows PC?

It seems these temporary images are originating from the LPE folder. Basing on the explanation give on this answer: The LPE folder is used by Samsung's Camera and Photo Editor apps. The files ...
xavier_fakerat's user avatar
4 votes

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 ...
jon.bray.eth's user avatar
4 votes

Import passwords from LastPass to Firefox

The LastPass add-on for Firefox has an option to do this. Choose Tools → Advanced Tools → Export To → Firefox
Richard Turner's user avatar
4 votes

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 ...
Ricardo Bohner's user avatar
3 votes

Outlook 2007 - Move EVERYTHING

There is possible way to do this On The Old Machine Outlook 2007 is nice enough to put all of its account info for each profile under one key. HKEY_CURRENT_USER\Software\Microsoft\Windows NT\...
BDRSuite's user avatar
  • 6,226
3 votes

Excel 2010 - Get CSV wizard to open by default

Just checking, do you use this method? Data Tab then From Text
BOB's user avatar
  • 228
3 votes

GnuPG 2.2 refuses secret key import: "error sending to agent: operation cancelled"

The issue – I think – is that GnuPG detects that it is running in a pipe, i.e. in a non-interactive shell. Since non-interactive means there's no user interacting with it, there is little point in ...
kqr's user avatar
  • 181
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 ...
ProfoundlyOblivious's user avatar
3 votes

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 ...
u1686_grawity's user avatar
3 votes

gpgsm: Cannot import private key

It turned out to be a bug that is fixed in GnuPG 2.2.35. See this mail thread.
Torsten Bronger's user avatar
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 ...
harrymc's user avatar
  • 464k
2 votes

Import e-mail via IMAP into GMail?

When using Google Apps Gmail you don't get Import by default. Your administrator must enable this explicitly.
xastor's user avatar
  • 859
2 votes

How to transfer Firefox passwords to Opera

FINALLY!!..... Opera would not import Mozilla passwords despite the option (apparently). All my bookmarks were imported without issue. Mozilla does encrypt/decrypt saved passwords using the Master ...
DFA119's user avatar
  • 31
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 ...
Guest's user avatar
  • 21

Only top scored, non community-wiki answers of a minimum length are eligible