Files to spreadsheets
apple Verified ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I have a large file with a lot of items in it. I am wondering if I can find some way to transfer straight from the file onto a spreadsheet? I have looked extensively, but maybe I am just missing the answer because of nomenclature or because I am looking in the wrong places.
7 replies
Sign in or join Beachball Help to reply.
- 0
Theoden_King ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
It depends on the kind of file.
I've had some success copying and pasting data into an Excel spreadsheet if it's already in a table format, but often it won't separate the cells the way it should. Sometimes Excel's Text Import Wizard is helpful.
What is the file format you are transferring from, and what spreadsheet program are you using?
- 0
Krusha55 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I am transferring from a file to a spreadsheet. You know, the file has a list of everything in it. I want to transfer that straight onto a spreadsheet.
- 0
Theoden_King ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
If you're talking about a regular text file, such as a Word document (.doc), plain text (.txt), .rtf, or hopefully even a PDF, it should work for you to simply copy and paste.
Select the list of everything you want on the spreadsheet.
Copy (Command-C, or choose Edit>Copy)
Open a new blank spreadsheet in Excel, Numbers, or whatever app you're using.
Click on the cell of the spreadsheet that you want to be first in the list.
Paste (Command-V, or Edit>Paste)
Normally each line of the list you copied from should appear in a separate cell down the length of the spreadsheet.
- 0
Krusha55 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
It is NOT from a regular file. When you go to finder and choose a file, a list comes up with all of the contents in that file. I want to transfer that list of the contents onto a spreadsheet.
- 0
Theoden_King ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Oh! I think we begin to understand each other.
Do you mean the contents of a folder?
- 0
Theoden_King ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
In that case, I'm not sure of the best way, but I can think of A way.
You could use the Terminal to get a text list of all the files in a particular folder, using:
cd /volumes/[your hard drive name]
followed by the path to the folder you want. (If there are any spaces in the names of folders in the path, they must be preceded by a "").
Once there, enter the command "ls" (that's a small L, not a capital i) followed by Enter.
The list of files should appear in the terminal window, and you can copy them from there and paste into your spreadsheet.
If the list is too long to select in one screenfull, I think you can save the terminal output to a text file.
(Sorry if I'm forgetting a step - I'm on my phone instead of my computer, so I can't go in and check the specifics right now.)
Let me know if that does what you're trying to do.
- 0
Krusha55 ·
Imported from the Apple Support Forums via the Wayback Machine 🔗
Thank you. I Got It. YEAH