Python Forum
How can I copy and paste data from text file into an Excel sheet?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How can I copy and paste data from text file into an Excel sheet?
#2
Is this the original file?
if so you have a problem, The file you posted to pastebin is space delimited, and it looks like a random number of spaces separates fields.

Is this the way the original file is, or are there tabs (or some other delimiter)?

if tabs (or other unique delimiter) you can treat the file as csv, import directly into excel
Reply


Messages In This Thread
RE: How can I copy and paste data from text file into an Excel sheet? - by Larz60+ - Mar-18-2020, 10:53 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Copy and Paste Files - Command MicheliBarcello 2 133 Yesterday, 05:04 AM
Last Post: rodiongork
  Reading an ASCII text file and parsing data... oradba4u 2 258 Jun-08-2024, 12:41 AM
Last Post: oradba4u
  Why is the copy method name in python list copy and not `__copy__`? YouHoGeon 2 420 Apr-04-2024, 01:18 AM
Last Post: YouHoGeon
  Python openyxl not updating Excel file MrBean12 1 533 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 610 Feb-07-2024, 12:24 PM
Last Post: Viento
  What script to paste folders thenewcoder 1 789 Nov-29-2023, 09:40 AM
Last Post: Pedroski55
  Search Excel File with a list of values huzzug 4 1,446 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 1,044 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  How to copy work sheet data one workbook to other? sayyedkamran 2 825 Nov-03-2023, 09:10 AM
Last Post: Larz60+
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 2,276 Oct-31-2023, 10:21 AM
Last Post: Pedroski55

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020