Avatar for Username

Sök i support

Akta dig för supportbedrägerier: Vi kommer aldrig att be dig att ringa eller skicka ett sms till ett telefonnummer eller dela personlig information. Rapportera misstänkt aktivitet med alternativet "Rapportera missbruk".

Läs mer

Denna tråd har arkiverats. Ställ en ny fråga om du behöver hjälp.

Converting Excel to CSV format during download from website

  • 2 svar
  • 1 har detta problem
  • 1 visning
  • Senaste svar av Washoe01

Washoe01
Washoe01
more options

We utilize FireFox to access and download data from a specific vendor. This vendor recently changed the originating data format from CSV to Excel. These are large files and downloaded several times daily. Can FireFox default the new Excel format back to CSV during the download process without having to open and resave?

We utilize FireFox to access and download data from a specific vendor. This vendor recently changed the originating data format from CSV to Excel. These are large files and downloaded several times daily. Can FireFox default the new Excel format back to CSV during the download process without having to open and resave?

Vald lösning

Firefox does not know how to read XLS or XLSX format, so it cannot do any kind of useful conversion.

Does the URL of the download specify the format? For example, does it contain anything like format=xls or similar parameter you might be able to modify to get the format you prefer?

To compare an old download URL, find one of the CSV files in the downloads list (Ctrl+j or "Show All Downloads"), right-click, and Copy Download Link. Then you can paste that into a Word document or Notepad to compare parameters. Of course, if the site has changed, the old link might not work any more...

Läs svaret i sitt sammanhang 👍 1

Alla svar (2)

jscher2000 - Support Volunteer
jscher2000 - Support Volunteer
  • Top 25 Contributor
more options

Vald lösning

Firefox does not know how to read XLS or XLSX format, so it cannot do any kind of useful conversion.

Does the URL of the download specify the format? For example, does it contain anything like format=xls or similar parameter you might be able to modify to get the format you prefer?

To compare an old download URL, find one of the CSV files in the downloads list (Ctrl+j or "Show All Downloads"), right-click, and Copy Download Link. Then you can paste that into a Word document or Notepad to compare parameters. Of course, if the site has changed, the old link might not work any more...

Washoe01
Washoe01 Frågans ägare
more options

Thank you for the information. I will try modifying the parameter while we wait to hear back from the vendor on correcting the format back to CSV.

Thanks again!