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?
#3
(Mar-18-2020, 10:53 PM)Larz60+ Wrote: 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

Hey thanks for the reply. For whatever reason its formatted weird in pastebin. The .txt file is formatted correctly and when I manually copy and paste it into excel, it also is pasted in correctly.

I tried converting it to a .csv and importing it that way but it didnt work right. How can I do this?
Reply


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

Possibly Related Threads…
Thread Author Replies Views Last Post
  Why is the copy method name in python list copy and not `__copy__`? YouHoGeon 2 310 Apr-04-2024, 01:18 AM
Last Post: YouHoGeon
  Python openyxl not updating Excel file MrBean12 1 383 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 492 Feb-07-2024, 12:24 PM
Last Post: Viento
  What script to paste folders thenewcoder 1 689 Nov-29-2023, 09:40 AM
Last Post: Pedroski55
  Search Excel File with a list of values huzzug 4 1,307 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 907 Nov-03-2023, 05:13 PM
Last Post: noisefloor
  How to copy work sheet data one workbook to other? sayyedkamran 2 727 Nov-03-2023, 09:10 AM
Last Post: Larz60+
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 2,001 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 2,143 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,151 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone

Forum Jump:

User Panel Messages

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