How to Import Keywords via CSV: A Step-by-Step Guide for Google Ads

If you've ever stared at a spreadsheet full of keywords and dreaded the thought of manually adding them one by one into Google Ads, you're not alone. CSV imports are the workhorse of PPC management—they let you bulk-add hundreds or thousands of keywords in minutes instead of hours. But here's the thing: one formatting mistake, one mismatched column header, and your entire import can fail. I've seen agency teams lose half a day troubleshooting rejected uploads because they used curly braces instead of square brackets for exact match keywords.

This guide walks you through the complete process of importing keywords via CSV into Google Ads. We'll cover the exact spreadsheet structure Google expects, how to format match types correctly (because yes, the symbols matter), and how to troubleshoot the most common import failures. Whether you're managing a single account or juggling dozens of clients, mastering CSV imports will fundamentally change how you scale campaigns.

Let's get into it.

Step 1: Prepare Your Keyword List in a Spreadsheet

Open Google Sheets or Excel and create a new file. This is where you'll structure your keyword data before uploading it to Google Ads. The platform expects specific column headers, and getting these right from the start will save you from mapping headaches later.

Required columns: At minimum, you need four columns: Campaign, Ad Group, Keyword, and Match Type. These tell Google Ads where to place each keyword and how to match it to search queries.

Optional but highly useful columns: Consider adding Max CPC (to set custom bids), Final URL (to direct traffic to specific landing pages), and Status (to control whether keywords are active or paused on upload). These optional fields give you more control without needing to edit keywords after import.

Here's the critical rule: one keyword per row. Don't try to combine multiple keywords in a single cell thinking it'll save time. Google Ads processes each row as a separate entity. If you put "running shoes, athletic footwear, sneakers" in one cell, the platform will treat that entire string as a single keyword—not what you want.

Keep formatting simple. Use plain text only. No formulas, no special characters beyond the match type symbols we'll cover in the next step, and no merged cells. In most accounts I audit, import failures trace back to someone copying keywords from a PDF or website that included hidden formatting characters. Paste values only, always.

Your spreadsheet should look clean and structured. Campaign names should match existing campaigns exactly—Google Ads is case-sensitive here. If your campaign is called "Brand Search - Exact" in the platform, typing "brand search - exact" in your CSV will create a new campaign instead of adding keywords to the existing one.

Pro tip: Before building your CSV, open Google Ads and copy the exact campaign and ad group names you're targeting. Paste them into your spreadsheet as a reference column. This eliminates typos and ensures perfect matching when you upload. If you're still figuring out which keywords to include, start by learning how to find the best keywords for PPC before building your import file.

Step 2: Format Match Types Correctly

This is where most import errors happen. Google Ads uses specific symbols to define how keywords match to search queries, and using the wrong symbol—or no symbol at all—will either cause your import to fail or, worse, set your keywords to the wrong match type and burn through budget on irrelevant traffic.

Broad match: Enter the keyword as-is with no symbols. Just type "running shoes" in the Keyword column and "broad" in the Match Type column. Broad match gives Google maximum flexibility to show your ads for related searches, including synonyms and variations. It's powerful for discovery but requires tight negative keyword management.

Phrase match: Wrap your keyword in quotation marks like this: "running shoes". In the Match Type column, enter "phrase". Phrase match triggers your ads when someone's search includes your keyword phrase in the same order, but allows additional words before or after. As of recent updates, phrase match absorbed what used to be modified broad match, so it now captures a wider range of queries than it historically did.

Exact match: Wrap your keyword in square brackets like this: [running shoes]. In the Match Type column, enter "exact". Exact match shows your ads only for searches that match your keyword's intent closely—Google still allows for minor variations like plurals and misspellings, but it's the most restrictive match type.

The mistake most agencies make is using curly braces {} or parentheses () instead of the correct symbols. These don't work. Google Ads will reject them or interpret them as literal characters in your keyword, which creates bizarre targeting issues. I've seen accounts targeting keywords like "{buy shoes}" because someone assumed curly braces meant exact match. Understanding how match types work for negative keywords follows similar logic and helps you avoid costly mistakes.

Another common error: leaving the Match Type column blank and relying only on symbols. While the symbols technically define match type, Google Ads Editor and bulk uploads often require both the symbol in the keyword and the match type specified in a separate column. Always include both to avoid ambiguity.

Why this matters: Incorrect match types don't just cause import failures—they cause wasted spend. If you accidentally upload high-intent transactional keywords as broad match instead of exact, you'll trigger impressions for informational queries that never convert. Getting match types right at import prevents expensive cleanup work later.

Step 3: Save Your File as a CSV

Once your spreadsheet is structured and formatted correctly, you need to save it as a CSV file. CSV stands for "comma-separated values"—it's a plain text format that Google Ads can read and process.

In Google Sheets: Click File, then Download, then select "Comma Separated Values (.csv, current sheet)". Google Sheets will download the active sheet as a CSV file to your computer. Make sure you're on the correct sheet before downloading—if you have multiple tabs, only the active one gets exported.

In Excel: Click File, then Save As, then choose "CSV UTF-8 (Comma delimited)" from the file type dropdown. Don't just select "CSV (Comma delimited)"—the UTF-8 version is critical if your keywords include special characters, accented letters, or non-English text. Standard CSV encoding can corrupt these characters during upload.

UTF-8 encoding matters more than most people realize. If you're running international campaigns with keywords in Spanish, French, German, or any language with diacritical marks, standard CSV encoding will turn "café" into "café" or worse. Google Ads will reject these malformed keywords. UTF-8 preserves the original characters exactly as you typed them.

After saving, double-check the file extension. It should end in .csv, not .xlsx or .xls. If you see an Excel icon next to your file, you saved it in the wrong format. Go back and save as CSV UTF-8 again.

One more check before moving on: Open your CSV file in a plain text editor like Notepad (Windows) or TextEdit (Mac). You should see your data separated by commas with no weird formatting. If you see HTML tags, XML code, or anything that doesn't look like plain text with commas, something went wrong in the export process. Re-save from your original spreadsheet.

Step 4: Navigate to Google Ads Editor or Bulk Upload

You have two options for importing your CSV: Google Ads Editor (a free desktop application) or the web interface's bulk upload feature. Each has its place depending on the size of your import and your workflow preferences.

Option A: Google Ads Editor. This is the power user's choice. If you're importing more than a few hundred keywords, or if you manage multiple accounts and need to make bulk changes regularly, download Google Ads Editor from Google's website. It's a free desktop app that syncs with your Google Ads account and lets you work offline.

In Google Ads Editor, open the account you want to update, then click "Import" in the toolbar. Select "Import from file" and choose your CSV. Editor is faster for large imports because it processes changes locally before pushing them to Google's servers. You can also review and edit keywords in a spreadsheet-like interface before posting changes.

Option B: Web interface bulk upload. For smaller imports—let's say under 500 keywords—the web interface works perfectly fine. Log into Google Ads, click the tools icon in the upper right, then navigate to "Bulk actions" under the Planning section. Click "Uploads" to access the bulk upload tool. If you prefer a more visual approach, our guide on where to add keywords in Google Ads walks through the interface step by step.

What usually happens here is people default to Editor because they think it's more "professional," but for quick imports or one-off additions, the web upload is actually faster. You don't need to wait for Editor to sync your account, and you get immediate feedback on errors.

Choose Editor if you're managing large-scale imports across multiple campaigns, making frequent bulk edits, or need to work offline. Choose the web upload if you're adding keywords to a single campaign or working with smaller lists. Both methods produce identical results—it's purely about workflow efficiency.

In most accounts I work with, agencies use Editor for client onboarding (when you're building entire account structures from scratch) and web uploads for ongoing optimization (adding new keyword variations or expanding existing ad groups).

Step 5: Upload Your CSV and Map Columns

Now comes the moment of truth. Click "Upload" (or "Import" in Editor) and select your CSV file from your computer. Google Ads will analyze the file and attempt to auto-detect which columns correspond to required fields like Campaign, Ad Group, and Keyword.

If your column headers match Google's expected names exactly—"Campaign", "Ad group", "Keyword", "Match type"—the platform will auto-map them and you're good to go. You'll see a preview showing which columns map to which fields.

If your headers don't match, you'll need to manually map columns. Google Ads will show dropdowns next to each column in your CSV. Click each dropdown and select the corresponding field. For example, if your spreadsheet uses "Campaign Name" instead of "Campaign", map that column to the Campaign field manually.

Pay close attention to the preview. This is your last chance to catch errors before committing the import. Scan through a few rows and verify that keywords are landing in the correct campaigns and ad groups. Check that match types are displaying correctly—you should see the symbols (quotes for phrase, brackets for exact) in the preview.

One common issue at this stage: Google Ads might flag campaigns or ad groups as "not found" if the names don't match existing entities exactly. Double-check for typos, extra spaces, or capitalization differences. The platform is unforgiving about exact matches here.

If everything looks correct in the preview, click "Apply" (web interface) or "Post" (Editor). For Editor users, remember that changes don't take effect until you post them to Google's servers. The app will show a progress bar as it uploads your keywords. For a complete walkthrough of the manual process, check out our guide on how to add keywords to Google Ads step by step.

The mistake most agencies make is skipping the preview and clicking through quickly. I've seen teams accidentally upload 5,000 keywords to the wrong campaign because they didn't verify the mapping. Take 30 seconds to review the preview—it'll save you hours of cleanup.

Step 6: Review Errors and Fix Common Issues

After uploading, Google Ads will generate an error report if any keywords failed to import. Don't panic if you see errors—they're usually easy to fix. Click "Download error report" to see which rows were rejected and why.

Common issue: Duplicate keywords. Google Ads won't let you add the same keyword twice to the same ad group, even with different match types in some cases. The error report will list the duplicates. Remove them from your CSV or assign them to different ad groups, then re-upload only the corrected rows.

Common issue: Invalid characters. Special characters like ™, ®, or emoji will cause rejections. Google Ads only accepts standard alphanumeric characters and basic punctuation. Scan your keywords for any unusual symbols and remove them.

Common issue: Missing required fields. If you left the Campaign, Ad Group, or Keyword columns blank for any row, those rows will fail. Fill in the missing data and re-upload. This usually happens when people copy-paste from multiple sources and accidentally leave gaps.

Common issue: "Campaign not found" or "Ad group not found" errors. This means the campaign or ad group name in your CSV doesn't match an existing entity in your account. Check for typos, capitalization differences, or extra spaces. In most accounts I audit, this error traces back to someone typing "Search Campaign" when the actual campaign name is "Search - Campaign" with a dash.

To fix these errors without re-importing successful keywords, create a new CSV with only the rejected rows (you can export them from the error report). Correct the issues, then upload this smaller file. Google Ads will process only the new rows, leaving your previously imported keywords untouched.

If you're using Google Ads Editor, you can fix errors directly in the app before posting changes. Editor highlights problematic rows in red and provides inline error messages. Fix them, then post the corrected data. You can also use third-party tools to validate keywords before uploading to catch issues early.

Pro tip: Keep your original CSV file and the error report. If you need to troubleshoot later or track what was uploaded when, having these files saved makes auditing much easier.

Step 7: Verify Your Import and Organize Keywords

Once your import completes successfully, navigate to your campaigns in Google Ads and confirm the keywords appear correctly. Don't assume everything worked just because the upload didn't throw errors—manual verification catches issues that automated checks miss.

Click into the campaigns you updated, then navigate to the Keywords tab. Use the date filter to show "Last 7 days" or "Today" so you're only viewing newly added keywords. This makes it easier to spot your imports among existing keywords.

Check match types are applied as intended. Look for the symbols in the keyword column. Phrase match keywords should have quotation marks, exact match should have square brackets, and broad match should have no symbols. If you see keywords without the correct symbols, Google may have defaulted them to broad match—go back and fix them manually or re-upload with correct formatting.

Use filters to quickly audit newly imported keywords. Apply a filter for "Status = Enabled" to see only active keywords, or filter by "Quality Score" to identify any keywords that might have low relevance scores right out of the gate. Low initial Quality Scores usually indicate poor keyword-to-ad-group alignment—consider reorganizing those keywords into more tightly themed ad groups. Learning how to choose keywords for Quality Score improvement can help you structure better ad groups from the start.

Speaking of organization: now's the time to group related keywords for better Quality Scores. If you imported a mix of brand terms, product terms, and competitor terms all into one ad group, your ad relevance will suffer. Create separate ad groups for each theme and move keywords accordingly. Google rewards tight keyword-to-ad alignment with lower CPCs and better ad positions.

In most accounts I work with, the difference between "imported and done" versus "imported and organized" is 20-30% in Quality Score improvements. Taking 15 minutes to group keywords logically after import pays dividends in campaign performance.

Finally, set up any bid adjustments or negative keywords you need for the newly imported keywords. If you uploaded high-intent transactional terms, you might want higher bids. If you imported broad match discovery keywords, layer in negative keywords immediately to prevent wasted spend on irrelevant queries. Our guide on how to add negative keywords in Google Ads covers the complete process.

Your CSV Import Workflow: Final Checklist

You've just learned the complete process for importing keywords via CSV into Google Ads. Let's lock it in with a quick checklist you can reference every time you do an import:

✓ Spreadsheet has required columns: Campaign, Ad Group, Keyword, Match Type

✓ Match types use correct symbols: quotation marks for phrase match, square brackets for exact match, no symbols for broad match

✓ File saved as CSV with UTF-8 encoding to preserve special characters

✓ Campaign and ad group names match existing structure exactly—no typos or capitalization differences

✓ Preview checked before final upload to catch mapping errors

✓ Error report reviewed and issues fixed before considering import complete

✓ Keywords verified in the platform with correct match types and organization

Once you've done this process a few times, CSV imports become second nature. You'll build templates with pre-formatted columns, save common campaign structures, and streamline the entire workflow down to minutes instead of hours.

But here's the thing: CSV imports are powerful for bulk additions, but they're still a back-and-forth process. You're working in spreadsheets, downloading files, uploading, checking for errors, then jumping back into Google Ads to verify everything. For ongoing campaign management—adding negatives, adjusting match types, or building new keyword groups from search term data—there's a faster way.

Optimize Google Ads Campaigns 10X Faster. Without Leaving Your Account. Keywordme lets you remove junk search terms, build high-intent keyword lists, and apply match types instantly—right inside Google Ads. No spreadsheets, no switching tabs, just quick, seamless optimization. Start your free 7-day trial (then just $12/month) and take your Google Ads game to the next level.