Copy Data from Notepad to Excel - Separate 2 Columns

In summary, the conversation discusses various methods for extracting data from different types of files into Excel. Suggestions include using the import function in Excel, downloading Nitro PDF pro, and using OCR software. If the file is not a scanned PDF, copying and pasting the data into Notepad may also be an option.
  • #1
drizzle
Gold Member
200
57
does anyone know how to copy data from Notepad file [Text Document] into Excel? the data I need to copy is two columns of numbers, but when I copy-paste them they appear as one column, I just couldn’t manage to separate them [they are about 40 pages long:cry:]. anyone have any suggestion, thanks in advance.
 
Computer science news on Phys.org
  • #2
in Excel, go to Data->Import External Data->Import Data and select the text file. You can then choose delimmeters or spacing to import columns from the text file.
 
  • #3
cheers, that'll save a LOT of time :biggrin:
 
  • #4
Does anyone know how to extract data from a pdf file into an excel file? :biggrin:

There're limited choices of files where one can import data from, any idea anyone? Thanks in advance.
 
  • #5
There are a bunch of ways, your best bet is to download Nitro PDF pro trial (14 days) and that has a built in function to extract a PDF to Excel (or Word).

Aside from that you've only got other OCR software.

Both these methods work best when it is not a scanned PDF document.
 
  • #6
If the document isn't a scanned PDF, you can copy and paste the data into Notepad, where you'll probably need to do some formatting.
 
  • #7
Cheers.
 

FAQ: Copy Data from Notepad to Excel - Separate 2 Columns

How do I copy data from Notepad to Excel?

To copy data from Notepad to Excel, follow these steps:

  1. Select the data in Notepad.
  2. Right-click and choose "Copy" or press "Ctrl + C" on your keyboard.
  3. Open Excel and click on the cell where you want to paste the data.
  4. Right-click and choose "Paste" or press "Ctrl + V" on your keyboard.
The data from Notepad will now be copied to Excel.

How do I separate data into two columns in Excel?

To separate data into two columns in Excel, follow these steps:

  1. Select the data that you want to separate.
  2. Click on the "Data" tab and then click on "Text to Columns".
  3. In the "Convert Text to Columns Wizard", choose "Delimited" and click "Next".
  4. Select the delimiter that separates the data in your file (e.g. space, comma, tab) and click "Next".
  5. Choose the format for your data and click "Finish".
Your data will now be separated into two columns in Excel.

Can I automatically update the data from Notepad in Excel?

Yes, you can automatically update the data from Notepad in Excel by using the "Refresh All" function. This will update all the external data connections in your Excel file, including the data from Notepad.

How do I convert the data in Notepad to numbers in Excel?

To convert the data in Notepad to numbers in Excel, follow these steps:

  1. Select the data in Excel that you want to convert.
  2. Right-click and choose "Format Cells".
  3. In the "Number" tab, choose "Number" as the category and set the decimal places if needed.
  4. Click "OK" to apply the changes.
The data from Notepad will now be converted to numbers in Excel.

Is there a way to copy data from Notepad to Excel without the formatting?

Yes, you can copy data from Notepad to Excel without the formatting by using the "Paste Special" function. This will allow you to paste only the values and not the formatting from Notepad to Excel. To do this, follow these steps:

  1. Select the data in Notepad and copy it.
  2. In Excel, click on the cell where you want to paste the data.
  3. Right-click and choose "Paste Special".
  4. In the dialog box, choose "Values" under "Paste" and click "OK".
The data from Notepad will now be copied to Excel without the formatting.

Similar threads

Very strange copy-paste bug in PDF document
2
Replies
36
Views
877
What Causes #HREF! Errors in Excel 2007?
Replies
5
Views
1K
What is a Data Lake? Understanding the Buzzword
Replies
3
Views
1K
Searching for unusual characters in a Word document
Replies
2
Views
272
How can I clone a USB drive to a VFD file for use in Windows?
Replies
14
Views
3K
How to delete column in notepad
Replies
2
Views
19K
Export only selected bookmarks/folders from Firefox
Replies
2
Views
3K
Edit Tab Delimited Text File w/Data for Use w/Gnuplot
Replies
2
Views
3K
Understanding DRAM Refresh Operations
Replies
14
Views
3K
Upgrading to Ubuntu 22.04 from 20.04: Will all my applications work?
Replies
23
Views
4K

Hot Threads

Recent Insights

Back
Top