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.
 

Related to Copy Data from Notepad to Excel - Separate 2 Columns

1. 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.

2. 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.

3. 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.

4. 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.

5. 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

What Causes #HREF! Errors in Excel 2007?
    • Computing and Technology
Replies
5
Views
1K
What is a Data Lake? Understanding the Buzzword
    • Computing and Technology
Replies
3
Views
1K
How can I clone a USB drive to a VFD file for use in Windows?
    • Computing and Technology
Replies
14
Views
2K
Export only selected bookmarks/folders from Firefox
    • Computing and Technology
Replies
2
Views
2K
Upgrading to Ubuntu 22.04 from 20.04: Will all my applications work?
    • Computing and Technology
Replies
23
Views
3K
How to delete column in notepad
    • Computing and Technology
Replies
2
Views
19K
Understanding DRAM Refresh Operations
    • Computing and Technology
Replies
14
Views
3K
How to open a JSON file in Godot that contains 2 arrays?
    • Programming and Computer Science
Replies
1
Views
611
LaTeX Can we see the latex source code for each post?
    • MATLAB, Maple, Mathematica, LaTeX
Replies
8
Views
1K
What are the different types of memory used for data entry?
    • Biology and Medical
Replies
5
Views
979

Hot Threads

Recent Insights

Back
Top