How to Import Multiple CSV Files into Google Sheets

To import multiple CSV files into one Google spreadsheet, repeat File → Import → Upload for each file. Choose Insert new sheet(s) to keep each export in a separate tab, or Append to current sheet to combine matching exports into one table. This is a manual, one-file-at-a-time workflow—not a single batch upload or an automatic merge.

Choose separate tabs or one combined table

• Separate tabs: use this for files with different columns, such as orders and inventory, or when you want to review each export before combining it.
• One table: use this for files with the same columns in the same order, such as non-overlapping monthly order exports.
• Separate spreadsheets: the CSV to Google Sheets extension creates a new spreadsheet for the selected local CSV. It is not a bulk importer into one workbook.

Prepare the files before importing

Keep the original CSVs and make a copy of an important destination workbook. List the files you plan to import so you can mark each one complete and avoid importing it twice. Check the delimiter, readable UTF-8 characters, and header row in every export; do not assume all files from different tools have identical settings.

For a combined table, compare the column names and their order. Appending places values by position; it does not match columns by their names or update records by ID. If one file uses order_id,date,amount and another uses date,order_id,amount, keep them in separate tabs until you have aligned the columns.

Option 1: import each CSV into a separate tab

1. Open the Google spreadsheet that should contain the files, or create a blank spreadsheet.
2. Choose File → Import → Upload and select the first CSV.
3. Choose Insert new sheet(s). Avoid Replace spreadsheet if you want to preserve existing tabs.
4. Confirm Separator type. Use Custom with ; for a semicolon-separated file when automatic detection does not work.
5. Disable Convert text to numbers, dates, and formulas if identifiers or dates must stay exactly as written. Click Import data.
6. Check the new tab's headers and sample values. Rename the tab to identify its source or reporting period.
7. Repeat File → Import → Upload and Insert new sheet(s) for each remaining CSV. Review every new tab before using the data.

Separate tabs do not combine the datasets automatically. They give you a safe place to inspect incompatible headers, different separators, or overlapping records before deciding how to build your report.

Option 2: append matching CSVs into one table

1. Import the first CSV using Insert new sheet(s) and check the resulting table. This becomes your destination tab.
2. Confirm that the second CSV uses the same columns in the same order and does not repeat records already imported.
3. Select the destination tab, then choose File → Import → Upload and select the second file.
4. Choose Append to current sheet, confirm its separator and conversion settings, and click Import data.
5. Inspect the boundary between old and new rows. If the CSV header was appended as a row, remove that repeated header from the new section only.
6. Compare the added records and amounts with the second export. Mark that file complete, then repeat for the remaining matching files.

Avoid the common multi-file mistakes

• Overlapping exports: a full-quarter file plus monthly files may repeat orders. Append does not deduplicate or merge updates; use non-overlapping exports or review duplicates before reporting totals.
• Repeated headers: check each join between imported files so header text does not appear among data rows.
• Lost leading zeros: disable conversion before each import when IDs must remain text. Formatting the result afterward cannot restore missing digits.
• Different separators: choose settings per file. A semicolon export and a comma export can require different separator choices.
• Text amounts: disabling conversion preserves identifiers but also imports amounts as text. Convert only the numeric columns you need and compare totals with the sources.
• Capacity: separate tabs still share one spreadsheet's cell capacity. If an import fails, reduce the export or use separate spreadsheets rather than repeatedly adding the same file.

When to use the extension or a recurring workflow instead

Use CSV to Google Sheets when each local CSV should open as its own new spreadsheet: select a file or recent download in the popup and review the resulting Sheet. The documented extension workflow does not select multiple files for a single bulk import, append to an existing workbook, or run on a schedule.

For a small set of exports, the manual tab or append workflow keeps the destination choices explicit. For ongoing scheduled sources, see the related recurring-import guide. For detailed individual import settings and formatting fixes, use the related manual-import and formatting guides.