How to copy table data from PDF to excel
up vote
5
down vote
favorite
When I copy data in a table like this from a PDF, it gets translated into plain text without any delimiting characters to distinguish which column the data is in.
It would be helpful if I could highlight only a single column in the pdf at a time, but it currently tries to select left to right both columns as I highlight. Is there any trick for this?
pdf copy-paste
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
asked Feb 13 '15 at 20:46
Luke Allen
14815
add a comment |
up vote
5
down vote
favorite
When I copy data in a table like this from a PDF, it gets translated into plain text without any delimiting characters to distinguish which column the data is in.
It would be helpful if I could highlight only a single column in the pdf at a time, but it currently tries to select left to right both columns as I highlight. Is there any trick for this?
pdf copy-paste
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
asked Feb 13 '15 at 20:46
Luke Allen
14815
1
For something like this, I would paste it into Excel and then use Excel's parsing functions to pull apart the data into separate cells.
– Jim Fell
Feb 13 '15 at 21:11
@JimFell If this is a "one time only" instance I would recommend the same.
– dkanejs
Feb 13 '15 at 21:23
1
@Geditdk Unfortunately, I think this is just a limitation of working with PDF files. Short of investing in a professional PDF editor, maybe you could write an Excel macro or custom VB function to speed up the process.
– Jim Fell
Feb 13 '15 at 21:42
Scripting is a good idea but You could use the Microsoft word "convert to table" function?
– dkanejs
Feb 13 '15 at 21:45
add a comment |
up vote
5
down vote
favorite
up vote
5
down vote
favorite
When I copy data in a table like this from a PDF, it gets translated into plain text without any delimiting characters to distinguish which column the data is in.
It would be helpful if I could highlight only a single column in the pdf at a time, but it currently tries to select left to right both columns as I highlight. Is there any trick for this?
pdf copy-paste
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
asked Feb 13 '15 at 20:46
Luke Allen
14815
When I copy data in a table like this from a PDF, it gets translated into plain text without any delimiting characters to distinguish which column the data is in.
It would be helpful if I could highlight only a single column in the pdf at a time, but it currently tries to select left to right both columns as I highlight. Is there any trick for this?
pdf copy-paste
pdf copy-paste
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
asked Feb 13 '15 at 20:46
Luke Allen
14815
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
asked Feb 13 '15 at 20:46
Luke Allen
14815
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
edited Dec 14 '17 at 11:19
Chenmunka
2,77481931
2,77481931
asked Feb 13 '15 at 20:46
Luke Allen
14815
asked Feb 13 '15 at 20:46
Luke Allen
14815
asked Feb 13 '15 at 20:46
Luke Allen
14815
14815
1
For something like this, I would paste it into Excel and then use Excel's parsing functions to pull apart the data into separate cells.
– Jim Fell
Feb 13 '15 at 21:11
@JimFell If this is a "one time only" instance I would recommend the same.
– dkanejs
Feb 13 '15 at 21:23
1
@Geditdk Unfortunately, I think this is just a limitation of working with PDF files. Short of investing in a professional PDF editor, maybe you could write an Excel macro or custom VB function to speed up the process.
– Jim Fell
Feb 13 '15 at 21:42
Scripting is a good idea but You could use the Microsoft word "convert to table" function?
– dkanejs
Feb 13 '15 at 21:45
add a comment |
1
For something like this, I would paste it into Excel and then use Excel's parsing functions to pull apart the data into separate cells.
– Jim Fell
Feb 13 '15 at 21:11
@JimFell If this is a "one time only" instance I would recommend the same.
– dkanejs
Feb 13 '15 at 21:23
1
@Geditdk Unfortunately, I think this is just a limitation of working with PDF files. Short of investing in a professional PDF editor, maybe you could write an Excel macro or custom VB function to speed up the process.
– Jim Fell
Feb 13 '15 at 21:42
Scripting is a good idea but You could use the Microsoft word "convert to table" function?
– dkanejs
Feb 13 '15 at 21:45
1
1
For something like this, I would paste it into Excel and then use Excel's parsing functions to pull apart the data into separate cells.
– Jim Fell
Feb 13 '15 at 21:11
For something like this, I would paste it into Excel and then use Excel's parsing functions to pull apart the data into separate cells.
– Jim Fell
Feb 13 '15 at 21:11
@JimFell If this is a "one time only" instance I would recommend the same.
– dkanejs
Feb 13 '15 at 21:23
@JimFell If this is a "one time only" instance I would recommend the same.
– dkanejs
Feb 13 '15 at 21:23
1
1
@Geditdk Unfortunately, I think this is just a limitation of working with PDF files. Short of investing in a professional PDF editor, maybe you could write an Excel macro or custom VB function to speed up the process.
– Jim Fell
Feb 13 '15 at 21:42
@Geditdk Unfortunately, I think this is just a limitation of working with PDF files. Short of investing in a professional PDF editor, maybe you could write an Excel macro or custom VB function to speed up the process.
– Jim Fell
Feb 13 '15 at 21:42
Scripting is a good idea but You could use the Microsoft word "convert to table" function?
– dkanejs
Feb 13 '15 at 21:45
Scripting is a good idea but You could use the Microsoft word "convert to table" function?
– dkanejs
Feb 13 '15 at 21:45
add a comment |
4 Answers
4
active
oldest
votes
up vote
5
down vote
accepted
Holding down the Alt key should allow you to select a column of text.
(Note: I've only tested this with Acrobat Pro, not Acrobat Reader.)
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
add a comment |
up vote
1
down vote
You can use the Microsoft word "Convert to table" function outlined here.
It's not exactly what you need but at least it is quicker.
answered Feb 13 '15 at 21:46
dkanejs
665412
add a comment |
up vote
0
down vote
Try to upload it to Google Docs and then save as XLS file, it should work
answered Mar 19 '15 at 13:52
MichaelT
91
add a comment |
up vote
0
down vote
It's not straight forward, however there are a large number of free or cheap services in the cloud for extracting such tables from PDFs.
Please find below the comparison table automated table extraction solutions according to Zanran:
So based on above, you may consider Zanran's Table Xtractor which has ability to finds the tables in your PDFs and converts them to Excel.
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
add a comment |
4 Answers
4
active
oldest
votes
4 Answers
4
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
5
down vote
accepted
Holding down the Alt key should allow you to select a column of text.
(Note: I've only tested this with Acrobat Pro, not Acrobat Reader.)
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
add a comment |
up vote
5
down vote
accepted
Holding down the Alt key should allow you to select a column of text.
(Note: I've only tested this with Acrobat Pro, not Acrobat Reader.)
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
add a comment |
up vote
5
down vote
accepted
up vote
5
down vote
accepted
Holding down the Alt key should allow you to select a column of text.
(Note: I've only tested this with Acrobat Pro, not Acrobat Reader.)
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
Holding down the Alt key should allow you to select a column of text.
(Note: I've only tested this with Acrobat Pro, not Acrobat Reader.)
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
answered Feb 13 '15 at 22:13
Mike Fitzpatrick
14.3k33440
14.3k33440
add a comment |
add a comment |
up vote
1
down vote
You can use the Microsoft word "Convert to table" function outlined here.
It's not exactly what you need but at least it is quicker.
answered Feb 13 '15 at 21:46
dkanejs
665412
add a comment |
up vote
1
down vote
You can use the Microsoft word "Convert to table" function outlined here.
It's not exactly what you need but at least it is quicker.
answered Feb 13 '15 at 21:46
dkanejs
665412
add a comment |
up vote
1
down vote
up vote
1
down vote
You can use the Microsoft word "Convert to table" function outlined here.
It's not exactly what you need but at least it is quicker.
answered Feb 13 '15 at 21:46
dkanejs
665412
You can use the Microsoft word "Convert to table" function outlined here.
It's not exactly what you need but at least it is quicker.
answered Feb 13 '15 at 21:46
dkanejs
665412
answered Feb 13 '15 at 21:46
dkanejs
665412
answered Feb 13 '15 at 21:46
dkanejs
665412
answered Feb 13 '15 at 21:46
dkanejs
665412
665412
add a comment |
add a comment |
up vote
0
down vote
Try to upload it to Google Docs and then save as XLS file, it should work
answered Mar 19 '15 at 13:52
MichaelT
91
add a comment |
up vote
0
down vote
Try to upload it to Google Docs and then save as XLS file, it should work
answered Mar 19 '15 at 13:52
MichaelT
91
add a comment |
up vote
0
down vote
up vote
0
down vote
Try to upload it to Google Docs and then save as XLS file, it should work
answered Mar 19 '15 at 13:52
MichaelT
91
Try to upload it to Google Docs and then save as XLS file, it should work
answered Mar 19 '15 at 13:52
MichaelT
91
answered Mar 19 '15 at 13:52
MichaelT
91
answered Mar 19 '15 at 13:52
MichaelT
91
answered Mar 19 '15 at 13:52
MichaelT
91
91
add a comment |
add a comment |
up vote
0
down vote
It's not straight forward, however there are a large number of free or cheap services in the cloud for extracting such tables from PDFs.
Please find below the comparison table automated table extraction solutions according to Zanran:
So based on above, you may consider Zanran's Table Xtractor which has ability to finds the tables in your PDFs and converts them to Excel.
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
add a comment |
up vote
0
down vote
It's not straight forward, however there are a large number of free or cheap services in the cloud for extracting such tables from PDFs.
Please find below the comparison table automated table extraction solutions according to Zanran:
So based on above, you may consider Zanran's Table Xtractor which has ability to finds the tables in your PDFs and converts them to Excel.
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
add a comment |
up vote
0
down vote
up vote
0
down vote
It's not straight forward, however there are a large number of free or cheap services in the cloud for extracting such tables from PDFs.
Please find below the comparison table automated table extraction solutions according to Zanran:
So based on above, you may consider Zanran's Table Xtractor which has ability to finds the tables in your PDFs and converts them to Excel.
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
It's not straight forward, however there are a large number of free or cheap services in the cloud for extracting such tables from PDFs.
Please find below the comparison table automated table extraction solutions according to Zanran:
So based on above, you may consider Zanran's Table Xtractor which has ability to finds the tables in your PDFs and converts them to Excel.
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
answered Apr 26 '16 at 11:20
kenorb
10.6k1577110
10.6k1577110
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f877688%2fhow-to-copy-table-data-from-pdf-to-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
For something like this, I would paste it into Excel and then use Excel's parsing functions to pull apart the data into separate cells.
– Jim Fell
Feb 13 '15 at 21:11
@JimFell If this is a "one time only" instance I would recommend the same.
– dkanejs
Feb 13 '15 at 21:23
1
@Geditdk Unfortunately, I think this is just a limitation of working with PDF files. Short of investing in a professional PDF editor, maybe you could write an Excel macro or custom VB function to speed up the process.
– Jim Fell
Feb 13 '15 at 21:42
Scripting is a good idea but You could use the Microsoft word "convert to table" function?
– dkanejs
Feb 13 '15 at 21:45