Apps by Arlomedia

BandHelper => Repertoire Help => Topic started by: soloracer on August 08, 2024, 11:15:06 AM

Title: Export songs to Excel/CSV?
Post by: soloracer on August 08, 2024, 11:15:06 AM
Can this be done? I don't see a way to get anything but PDF, text, or html. Ideally, I'd like to be able to import as well.

I work with an Excel whiz and he's dead set on putting song-ending info in an excel format and nothing else. I'd like to be able to provide him the list with the field available for him to fill in. I can paste it back into BH if there's no way to import but he refuses to work with BH or anything else.
Title: Re: Export songs to Excel/CSV?
Post by: arlo on August 08, 2024, 06:19:18 PM
You can use the Export button at the bottom of the Repertoire > Songs page of the website.

You cannot edit and reimport; this function is meant only for moving data into another system, not for editing it elsewhere and importing it back in.
Title: Re: Export songs to Excel/CSV?
Post by: soloracer on August 09, 2024, 08:49:00 AM
Thanks. That's OK I can manually make changes.
However it looks as though it will only export as .txt. Is that true?
I see "Spreadsheet View" but when I hit that then "Export" disappears.
Title: Re: Export songs to Excel/CSV?
Post by: arlo on August 09, 2024, 09:10:12 AM
It exports a tab-delimited text file, which you can open in Excel or another spreadsheet program.
Title: Re: Export songs to Excel/CSV?
Post by: soloracer on August 09, 2024, 10:27:18 AM
Thanks!