CSV to Google Sheets — Free One-Click Converter
Drop a CSV file and click Open in Google Sheets. It becomes a real Google Sheet in your own Drive — columns, special characters and semicolon-separated files handled for you.
Drop a CSV file anywhere on this page
It renders instantly as a searchable, sortable table — nothing is uploaded.
Tip: you can also press ⌘V / Ctrl+V anywhere to paste CSV data
How to convert a CSV to Google Sheets
- 1
Drop your CSV on the page (or paste the rows). The table previews instantly, so you can check the columns came out right.
- 2
Click Open in Google Sheets and choose your Google account. Google asks for permission to create this one file in your Drive.
- 3
Your new Google Sheet opens in a new tab, saved in your Drive and ready to edit and share.
Features
- One click from CSV to a native Google Sheet
- Uploads the full file, not just the preview
- Semicolon-, pipe- and tab-separated files converted correctly
- Preview, search and sort before you import
- Saved to your own Google Drive — we never see the data
- Narrowest Google permission: access only to the file it creates
- Rather not sign in? Copy-and-paste into a blank Sheet instead
- Free, no signup, no ads
What does this CSV to Google Sheets converter do?
It turns a CSV file on your computer into a native Google Sheet in your own Google Drive, in one click. The file goes straight from your browser to Google — never through our servers — and is converted on upload, so you get a real Sheet you can edit, share and use formulas in, not a CSV preview.
When to use this instead of Google's import
Use it when Google Sheets' File → Import wizard is more steps than you want, when your CSV uses semicolons or tabs (common in European and bank exports) and Drive would cram everything into column A, or when you want to check the data before it lands in Sheets.
Why not just use File → Import in Google Sheets?
Google's own route works, but it's a detour: open Drive, upload the file, open it, pick the import options, then save it as a Sheet. And Drive only splits columns on commas and tabs — a semicolon-separated export (Excel in most of Europe saves CSVs that way) lands as one long column of text.
This converter detects the delimiter, re-saves the file as standard CSV where needed and uploads it already converted, so the Sheet opens with every column in place. Our CSV to Google Sheets guide compares every method, including IMPORTDATA and Apps Script.
Keep your data intact
Google Sheets applies its usual formatting on import, so values that look like numbers or dates are treated as numbers or dates. If your file has ZIP codes, phone numbers or product IDs with leading zeros, read how to preserve leading zeros first. For garbled characters, see fixing CSV encoding errors.
Files are limited by Google Sheets itself to 10 million cells. Bigger than that? Our large CSV guide shows how to split them.
Do this every day? Skip the browser
If CSVs land in your Downloads folder all day, the CSVtoSheets app for Mac and Windows makes double-clicking any CSV, XLS or XLSX open it straight in Google Sheets — no website, no upload step. See how to automate CSV to Google Sheets for every option, or make Google Sheets the default app for CSV files on Windows.
Ways to get a CSV into Google Sheets
| This converter | Google Drive import | CSVtoSheets app | |
|---|---|---|---|
| Steps | Drop file → click | Upload → open → import → save | Double-click the file |
| Semicolon / pipe CSVs | Converted automatically | One column of text | Converted automatically |
| Preview before import | Yes | No | No |
| Where the file goes | Your Google Drive | Your Google Drive | Your Google Drive |
| Works on | Any browser | Any browser | Mac and Windows |
| Cost | Free | Free | Free for 3 files, then one-time |
Frequently asked questions
How do I convert a CSV file to Google Sheets?
Drop the CSV on this page and click Open in Google Sheets. After choosing your Google account, the file is uploaded from your browser to your own Google Drive and converted into a native Google Sheet, which opens in a new tab.
Is it safe? Can you see my data?
No. The file is read in your browser and sent directly to your own Google Drive; it never passes through our servers. The Google permission we ask for (drive.file) only lets the tool create and open the file it makes — it can't see anything else in your Drive.
Why does Google ask me to sign in?
To create a Sheet in your Drive, Google needs your OK. You'll see a Google window: pick your account and click Continue. If you'd rather not sign in, use the copy-and-paste option, which copies the table and opens a blank Google Sheet to paste into.
Does it work with semicolon-separated CSV files?
Yes. Semicolon- and pipe-delimited files are detected and re-saved as standard comma-separated CSV before upload, so every column lands in its own column in Google Sheets.
Is there a file size limit?
You can load files up to 100 MB. Google Sheets itself caps a spreadsheet at 10 million cells, and the tool tells you before uploading if a file is over that limit.
Can I make CSV files always open in Google Sheets?
Not with a website — your computer decides which app opens a file. The CSVtoSheets app for Mac and Windows registers as the default app for CSV, XLS and XLSX files, so double-clicking one opens it in Google Sheets.
Import CSVs into Google Sheets every day? Make it a double-click.
CSVtoSheets for Mac and Windows (beta): double-click any CSV, XLS, or XLSX and it opens in Google Sheets instantly. Free for your first 3 files, then $9 once — no subscription.