AAN CSV Redirect Tool

Merge and format CSV files for 301 redirects

Old Site CSV (Old URLs)
Upload Old Site CSV file here

File should contain old URLs and an identifier

New Site CSV (New URLs)
Upload New Site CSV file here

File should contain new URLs and the same identifier

Select the columns from each CSV that contain the common identifier (e.g., "stockno", "VIN").
Old Site CSV

Match columns on common identifier

New Site CSV
Processing...

Processing your files...

Files processed successfully!
Processing Statistics

0

Total Rows

0

Matched

0

Unmatched

0%

Match Rate

Merged Output File

Combined file with all data from both CSVs, matched by identifier.

Download Merged CSV
301 Redirect Import File

Formatted file ready to import into redirection plugin.

Download 301 Redirect CSV

Initial processing complete!

Ready for additional matching with sitemap

An error occurred during processing.
This step helps match additional content pages (like /about, /contact) by comparing URL slugs with the new site's XML sitemap.
New Site XML Sitemap
Enter the URL to the XML sitemap of the new site to find additional matches.
Processing sitemap...

Processing sitemap and matching URLs...

Sitemap processing complete!

Found 0 new matches based on URL slugs

Ready to finalize your redirects

Sitemap Matching Statistics

0

Total Unmatched

0

New Matches

0

Still Unmatched

0%

Match Rate

The sitemap processing found additional matches based on URL slugs. These matches have been added to a new section in the enhanced 301 redirect file.

An error occurred while processing the sitemap.
Troubleshooting

Sitemap processing complete!

Ready to finalize your redirects

This step finalizes your redirect file by stripping domains and preventing infinite redirects.
Finalize Redirects

The finalizer will:

  1. Strip domains from all URLs, leaving only the path (e.g., /vdp/12345/...)
  2. Remove any infinite redirects where source and target are the same path
  3. Format the final CSV for import into your redirect plugin
Finalizing redirects...

Finalizing redirects...

Redirects finalized successfully!
Finalization Results

0

Total Redirects

0

Infinite Redirects Removed

0

Final Redirects

An error occurred while finalizing redirects.
How to Use This Tool
  1. Upload your source CSV (containing old URLs) and target CSV (containing new URLs).
  2. Select the column in each CSV that contains the common identifier (e.g., stock number, VIN).
  3. Enter a common name for this identifier field (e.g., "stockno").
  4. Process the files to merge them based on the identifier.
  5. Download the merged file and/or the 301 redirect import file for your redirection plugin.

Note: This tool processes files locally in your browser. Your CSV data is not stored on any server.