Apps by Arlomedia

BandHelper => Repertoire Help => Topic started by: Schmakus on July 13, 2024, 12:17:21 AM

Title: GEMA Excel export
Post by: Schmakus on July 13, 2024, 12:17:21 AM
Hello,
GEMA uses a excel template for it's setlist.
Have anybody an idea how I can simply copy the items from a PDF to a CSV or XLS?

Or, maybe Arlo, is it possible to export a setlist to the GEMA XLS File?

Attached the template:
Title: Re: GEMA Excel export
Post by: arlo on July 13, 2024, 11:04:07 AM
Did you try copying and pasting from the PDF to Excel?
Title: Re: GEMA Excel export
Post by: Schmakus on November 01, 2024, 01:44:22 PM
Yes, it is possible with Excel Power Query and some skills..... ;-)
But it would be easier directly from BH. ;-)
Title: Re: GEMA Excel export
Post by: arlo on November 01, 2024, 04:18:47 PM
Hmm, I thought a copy from a PDF would paste into Excel neatly, but it doesn't when I tried it. However, if I export from the app, I can set the Email Format to HTML, then open the exported file in a web browser. Then that copies and pastes neatly into Excel.