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
|
|
Ronbatman Administrator Posts: 2530
8/17/2020
|
You can print by boxes but not export.
Ron
|
|
|
0
link
|
|
Spidey63 Posts: 100
8/17/2020
|
Thank you Ron.
|
|
|
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
|
|
claydwilli Posts: 66
8/18/2020
|
Thanks kds! Useful work around.
Ron, is this a possible feature update at some point? It would be a really useful thing to have
|
|
|
0
link
|
|
ChipS Posts: 1
2/13/2022
|
*** How do I 'Save the box as a PDF file'??? ***
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.
|
|
|
0
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
|
|
Jayc13 Posts: 55
5/7/2023
|
I’ve asked this question years ago. CPG tries to keep it locked down and proprietary.
Saving out to excel and delineate tabs is a pain. Export PDF and save as has been working for me. 😕
|
|
|
0
link
|
|
ruk Posts: 979
5/7/2023
|
Thanks Jayc
appreciate that you have seen this issue years ago
|
|
|
0
link
|
