# How to import CSV from URL and Dropbox file to Google Sheet

In the below video, I'm showing how you can import CSV files from a URL and Dropbox URL to your Google Sheet.

We're using *IMPORTDATA()* to get the remote CSV file from the URL. Please note that the link you have should either end with *.csv* or can download as a CSV file.

<iframe width="560" height="315" src="https://www.youtube.com/embed/wUcXhmEWRg8" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>


For Dropbox:

You cannot directly import CSV directly to Google Sheet. Therefore, you have to replace the last *dl=0* with *dl=1*. Please check [this](https://help.dropbox.com/files-folders/share/force-download) Dropbox page as a reference.

Use Case:

- [https://support.google.com/docs/thread/15838120/importing-a-csv-from-dropbox-using-importdata?hl=en](https://support.google.com/docs/thread/15838120/importing-a-csv-from-dropbox-using-importdata?hl=en)
- I also saw a Reddit page where it's discussing importing CSV from Dropbox and then to Shopify. please see [here](https://www.reddit.com/r/ecommerce/comments/sdiw16/csv_from_a_dropbox_to_shopify/).

We are Makeinfo, we build solid productivity solutions for your Google Workspace and Chrome browser. If you're looking for informative tips like this or want to see what we're making, please visit Makeinfo.co