Download CSV with Semicolon is a Google Sheets extension created to address a common issue: Google Sheets does not natively export CSV files using a semicolon (;) as the delimiter. Many developers and professionals working with CSV files in UTF-8 format need semicolon-separated values (CSV), especially in regions where the semicolon is the standard CSV delimiter.
This extension simplifies the process of exporting Google Sheets to CSV files using semicolons, saving you time and ensuring compatibility with your workflows.
- Export Google Sheets to CSV files with a semicolon (;) as the delimiter.
- UTF-8 encoding to ensure compatibility with most systems.
- Easy and fast download process directly from Google Sheets.
- Deleted CSV files are stored in your Google Drive trash for up to 30 days, so you can recover them if needed.
CSV files are commonly used for data exchange, especially in development environments. However, Google Sheets doesn't offer a built-in way to export CSVs with a semicolon delimiter, which is frequently required by developers in certain regions. This extension was designed to streamline this process, ensuring that your exported files are properly formatted with semicolons and UTF-8 encoding.
To install the extension: Unfortunately google workspace marketplace have too many requierements to add an a new Add-On to the marketplace, so here is the manual process:
-
Create a spreadsheet in your google sheets that you will use everytime that you want to export to CSV with semicolon.
-
Open that spreadsheet, and just for the first time go to "Extensions" -> "Apps Scripts"
-
Copy and paste the
Code.gsfile from this repo to your app scripts and create theDownloadDialogHTML file and do the same
-
Then, just one, go to
Code.gsin apps scripts and select the functionshowDownloadDialogand click "RUN" -
Accept all de requirements to use your google drive for this app that you are creating right now
You will receive and email notifying you about that!
-
After all, check if it shows "Execution completed":
-
Go back to your spreadsheet browser tab and check te box:
-
Done! After refreshing once your current browser tab, Now, every time that you use this specific spreadsheet, will be showing the button in "Extensions" MENU to use the app scripts to download CSV:
Please open a issue if you have any problem