Once you have converted a PDF to a CSV, the last step is getting that file into Google Sheets cleanly. It sounds like a one-click job, and most of the time it is, but two snags catch people out: the whole file lands in a single column, or the amounts and dates change the moment they import. Both are easy to avoid once you know which option to pick in the import dialog.
This guide walks through the reliable way to import a CSV into Google Sheets, why the one-column problem happens, and how to keep your numbers, dates, and account numbers exactly as they were in the file.
How do I import a CSV file into Google Sheets?
Open the sheet you want the data in, click File, then Import, then Upload, and choose your CSV. In the dialog, set Import location (Replace spreadsheet, Insert new sheet, or Append to current sheet), pick the Separator type, decide whether to convert text to numbers and dates, then click Import data. The rows fill in with each value in its own cell.
The Import location choices matter more than they look. Replace spreadsheet wipes everything and drops the CSV in, Insert new sheet keeps your existing tabs and adds the data as a fresh one, and Append to current sheet stacks the new rows under what is already there, which is handy when you are combining several months of the same statement layout.
Can you import a CSV into Google Sheets?
Yes. Google Sheets reads CSV files natively, so you can import one through File then Import, drag the file into Google Drive and open it with Sheets, or paste the contents and split them with Data then Split text to columns. File then Import is the most controlled route because it lets you set the separator and the number-conversion behavior before the data lands, which is exactly where the common problems get fixed.
Why does my CSV import into one column in Google Sheets?
A CSV lands in one column when Google Sheets uses the wrong separator. The file is probably delimited with semicolons or tabs rather than commas, which is common when a CSV is exported in a European locale where the comma is the decimal mark. In the import dialog, change Separator type from Detect automatically to the character your file actually uses, often Custom with a semicolon, and the columns split correctly.
If you have already imported and everything is jammed into column A, you do not have to start over. Select the column, choose Data then Split text to columns, and pick the matching separator. Sheets redistributes the values across columns in place.
How do I stop Google Sheets changing my numbers and dates on import?
Uncheck "Convert text to numbers, dates, and formulas" in the import dialog to keep every value exactly as written. Leave it on and Sheets reads 00123 as 123 and may reformat dates to its own locale. Turn it off when the file contains account numbers, ZIP codes, or invoice IDs with leading zeros you cannot afford to lose, and on when you want totals to calculate straight away.
There is a trade-off either way, because the toggle applies to the whole file, not to a single column. If one column needs to stay text and another needs to be numeric, import with the convert option off, then format the numeric column afterward with Format then Number. It is a minute of cleanup that beats finding a broken total a week later.
How do I import multiple CSV files into Google Sheets?
Import each CSV into its own sheet with Insert new sheet, or use Append to current sheet to stack files that share the same columns into a single tab. There is no built-in way to bulk-import a folder of CSVs at once, so if you have many files from the same source, it is faster to convert and combine them before they reach Sheets. The batch PDF to Excel converter turns a stack of PDFs into one file, which then imports in a single pass.
How do I import a CSV into Google Sheets automatically?
For a CSV that lives at a public web address, the IMPORTDATA function pulls it in and refreshes on its own: type =IMPORTDATA("your-csv-url") into a cell and Sheets loads the file. It only works for a URL Sheets can reach without a login, so it suits published exports and feeds, not a file sitting on your computer. For those, File then Import is still the fastest route, and a marketplace add-on can schedule recurring imports if you need them.
When the data you want in a sheet arrives by email rather than as a file you download, an email parser that extracts data to CSV can capture it and hand you a clean file to import on a schedule, which removes the copy-and-paste step entirely.
What is the best way to get a PDF into Google Sheets as a CSV?
Convert the PDF to a CSV with a structure-aware tool first, then import that file, because Google Sheets cannot read a PDF on its own. Upload the document to the PDF to Google Sheets converter or the PDF to CSV converter, check the preview so the columns and numbers tie out, download the CSV, and import it with the steps above. Compared with the free copy-and-paste trick, you keep the table structure instead of rebuilding it by hand.
If your destination is QuickBooks rather than a spreadsheet, the same CSV can go a different way: a CSV to QuickBooks converter turns a bank or card export into a QBO file you import straight into your books. And for the whole Excel side of the workflow, the PDF to Excel converter covers it, while how to convert a PDF to Google Sheets compares every method end to end.
Importing a CSV into Google Sheets is quick once you control two settings: the separator that keeps your columns apart, and the convert toggle that decides whether your numbers and dates stay as written. Get a clean CSV out of your PDF first, choose those two options on the way in, and the data lands ready to filter, total, and share.