Ask the community for help and advice here
|
Spidey63 Posts: 100
8/17/2020
|
Hello -
I know we can export to excel by publisher, then sort from there.
But is it possible to export boxes to excel?
Because of the way I grouped the books together in the boxes.
|
|
|
0
link
|
|
kds_comics Posts: 686
8/17/2020
|
pukie2122 wrote:
Thank you Ron.
Here is the work around.
1) save the box or collection as a PDF file.
OPTION 1
2) If you have the latest version of Microsoft word - Start the MS Word Program. Open the PDF as a file in MS Word. Word will convert the PDF to an MS word file.
OPTION 2
2) Copy the text from from the PDF to a MS Word file. Put placeholder text for the Notes column if it is blank.
3) Convert the text to a Table. This takes some work an is not perfect. (May be easier in latest version).
4) Copy the MS Word table in MS excel.
Easy? - no - Can be done? yes.
|
|
|
+3
link
|
|
ruk Posts: 979
5/6/2023
|
wd be great if we cd easily transfer a box to an excel file
I do my analysis thru boxes-and wd love to manipulate the data in a box-but need excel for that
I can do it by Publisher but it is a much longer process------------
I am too old to figure the work around you guys suggest but I appreciate your effort.
|
|
|
+1
link
|
