Converting Excel to CSV format during download from website
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?
פתרון נבחר
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...
Read this answer in context 👍 1כל התגובות (2)
פתרון נבחר
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...
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!