This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a large data file sent to me bi-monthly in an adobe reader version, I need to copy/paste the info to a excel spreadsheet so that I can sort the date and pull out certain info as needed for my reports. when I copy pasted the info it didn''t auto sort into columns it put the whole line of info into the first column of the spreadsheet. so fro example Soc.#,name,stat,policy,active/cancelled,date started date ended, should all have their own columns but all of it was copied to column a. the data is about 10,000 lines of individual peoples info.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Copy/paste first into Notepad or any Text Editor.
Save as a *.txt file.
Open the *.txt file Excel and step through the Test Import Wizard when it pops up.
Gord
The other suggestions are all good ones, and I'll add one more:
Look at Data --> Text to columns and see if that might be useable to split the data into separate columns. The Text to Columns option is just to the right of center on the [Data] tab.
I have a large data file sent to me bi-monthly in an adobe reader version, I need to copy/paste the info to a excel spreadsheet so that I can sort the date and pull out certain info as needed for my reports.
Can you post several lines of this data so we can see what it looks like?
DON'T FORGET TO CHANGE THE SOCIAL SECURITY NUMBERS AND NAMES TO PROTECT PRIVACY.
Unfortunately that is how it works. The data when copied from pdf sometimes loses the formatting.
You could also check online for converters to convert the .pdf file to .xlsx.
http://office.microsoft.com/en-us/excel-help/save-as-pdf-HA010354239.aspx#_Toc257196640